I_LglTransRelationshipAPI01

DDL: I_LGLTRANSRELATIONSHIPAPI01 SQL: ILTRELSHIPAPI01 Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Relationships of Legal Transaction

I_LglTransRelationshipAPI01 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_LglTransRelationshipAPI01 is a Basic CDS View that provides data about "Relationships of Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LegalTrRelationship) and exposes 9 fields with key field LegalTransactionRelshpUUID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Purpose
This CDS view provides the details of relationships of a legal transaction. This CDS view provides the data to answer the following business questions: What are the relationship types maintained for a legal transaction? What is maintained for a relationship type in a legal transaction? Which maintained relationship types are required for a legal transaction? Are relationship types relevant for integration? Is relationship type added using the Integration Variable Business Add-In?

Prerequisites
You can create reports for Manage Legal Transaction application using this CDS view. Users who want to run these reports must have a role based on the SAP_BR_ADMINISTRATOR_LCM , SAP_BR_LEGAL_COUNSEL , and SAP_BR_EMPLOYEE_LEGAL_CONTENT business role templates. In this role, the user must have authorization to the following: Certain Profiles Access Level Organisation Company code Sales Organisation Purchase Organisation

Structure
Fields Important fields in this view include the following: RelshpLegalTransaction is used to display the relationship legal transaction. LglCntntMRelshpType is used to display the relationship type. LegalTransactionMandatoryFlag is used to display the control parameter of legal transaction mandatory state. LglCntntMIsIntegRelevant is used to display if relationship type is integrated. LglCntntMIsAddedByIntegVarbl is added by the Integration Variable Business Add-In.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentCM-LT
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the details of relationships of a legal transaction. </p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the relationship types maintained for a legal transaction? </p></li> <li><p>What is maintained for a relationship type in a legal transaction? </p></li> <li><p>Which maintained relationship types are required for a legal transaction? </p></li> <li><p>Are relationship types relevant for integration? </p></li> <li><p>Is relationship type added using the Integration Variable Business Add-In?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LegalTrRelationship I_LegalTrRelationship from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionAPI01 _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ILTRELSHIPAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.representativeKey LegalTransactionRelshpUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Relationships of Legal Transaction view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionRelshpUUID LegalTransactionRelshpUUID Universal Unique Identifier
LegalTransactionUUID LegalTransactionUUID Universal Unique Identifier
RelshpLegalTransaction RelshpLegalTransaction Legal Transaction ID
RelshpLegalTransactionUUID RelshpLegalTransactionUUID Universal Unique Identifier
LglCntntMRelshpType LglCntntMRelshpType Relationship Type
LegalTransactionMandatoryFlag LegalTransactionMandatoryFlag Control Parameter Legal Transaction Mandatory State
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant Integrated
LglCntntMIsAddedByIntegVarbl LglCntntMIsAddedByIntegVarbl Added By Integration Variable BAdI
_LegalTransaction _LegalTransaction

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LglTransRelationshipAPI01.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ILTRELSHIPAPI01

CREATE VIEW I_LglTransRelationshipAPI01 AS
SELECT
  LegalTransactionRelshpUUID,
  LegalTransactionUUID,
  RelshpLegalTransaction,
  RelshpLegalTransactionUUID,
  LglCntntMRelshpType,
  LegalTransactionMandatoryFlag,
  LglCntntMIsIntegRelevant,
  LglCntntMIsAddedByIntegVarbl
FROM I_LegalTrRelationship
LEFT OUTER JOIN I_LegalTransactionAPI01 AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
;

Learn More