R_LegalTransRelationshipTP

DDL: R_LEGALTRANSRELATIONSHIPTP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources 1 Associations

Legal Transaction Relationships

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

Data Sources (1)

SourceAliasJoin Type
I_LegalTrRelationship I_LegalTrRelationship from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _RelshpLegalTransaction $projection.RelshpLegalTransactionUUID = _RelshpLegalTransaction.LegalTransactionUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Legal Transaction Relationships view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionRelshpUUID LegalTransactionRelshpUUID Universal Unique ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
RelshpLegalTransaction RelshpLegalTransaction Legal Transaction ID
RelshpLegalTransactionUUID RelshpLegalTransactionUUID Universal Unique ID
LglCntntMRelshpType LglCntntMRelshpType Relationship Type
LegalTransactionMandatoryFlag LegalTransactionMandatoryFlag Mandatory
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant Integrated
LglCntntMIsAddedByIntegVarbl LglCntntMIsAddedByIntegVarbl Added By Integration
_LegalTransaction _LegalTransaction
_RelshpLegalTransaction _RelshpLegalTransaction

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 R_LegalTransRelationshipTP.
-- 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.

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

Learn More