I_LCMContextRelationshipTP

DDL: I_LCMCONTEXTRELATIONSHIPTP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources 2 Associations

Transactional view for LCM Context Relationship

I_LCMContextRelationshipTP is a Transactional CDS View that provides data about "Transactional view for LCM Context Relationship" in SAP S/4HANA. It reads from 1 data source (I_LCMContextRelationship) and exposes 11 fields with key field LglCntntMCntxtRelshpUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LCMContextRelationship I_LCMContextRelationship from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_LglCntntMRltnTypeText _LglCntntMRltnTypeText $projection.LglCntntMRelshpType = _LglCntntMRltnTypeText.LglCntntMRelshpType
[0..1] I_LegalTransaction _LegalTransaction $projection.LglCntntMCntxtRelshpLglTrans = _LegalTransaction.LegalTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transactional view for LCM Context Relationship view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey LglCntntMCntxtRelshpUUID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCntxtRelshpUUID LglCntntMCntxtRelshpUUID Universal Unique ID
LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMRelshpType LglCntntMRelshpType Relationship Type
LglCntntMCntxtRelshpLglTrans LglCntntMCntxtRelshpLglTrans Legal Transaction ID
LglCntntMRelshpLglTransUUID LglCntntMRelshpLglTransUUID Universal Unique ID
LglCntntMIsMandatory LglCntntMIsMandatory Is Mandatory
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant Integrated
_LglCntntMContext _LglCntntMContext
_LCMContextTP _LCMContextTP
_LglCntntMRltnTypeText _LglCntntMRltnTypeText
_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_LCMContextRelationshipTP.
-- 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 I_LCMContextRelationshipTP AS
SELECT
  LglCntntMCntxtRelshpUUID,
  LglCntntMContextUUID,
  LglCntntMRelshpType,
  LglCntntMCntxtRelshpLglTrans,
  LglCntntMRelshpLglTransUUID,
  LglCntntMIsMandatory,
  LglCntntMIsIntegRelevant
FROM I_LCMContextRelationship
LEFT OUTER JOIN I_LglCntntMRltnTypeText AS _LglCntntMRltnTypeText ON LglCntntMRelshpType = _LglCntntMRltnTypeText.LglCntntMRelshpType  -- association [0..*]
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LglCntntMCntxtRelshpLglTrans = _LegalTransaction.LegalTransaction  -- association [0..1]
;

Learn More