I_LegalTransactionEntityMain

DDL: I_LEGALTRANSACTIONENTITYMAIN SQL: ILEGALTRENTITYM Type: view COMPOSITE Package: VDM_LCM_LT
14 Fields 1 Data Sources 3 Associations

Composite View for LCM Legal Transaction Entity Main

I_LegalTransactionEntityMain is a Composite CDS View that provides data about "Composite View for LCM Legal Transaction Entity Main" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionEntity) and exposes 14 fields with key field LegalTransactionEntityUUID. It has 3 associations to related views. Part of development package VDM_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionEntity LegalTransactionEntity from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[0..1] I_LCMEntityTypeText _EntityTypeText $projection.LglCntntMEntityType = _EntityTypeText.LglCntntMEntityType and _EntityTypeText.Language = $session.system_language
[0..*] I_LCMEntityTypeText _LCMEntityTypeText $projection.LglCntntMEntityType = _LCMEntityTypeText.LglCntntMEntityType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILEGALTRENTITYM view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey LEGALTRANSACTIONENTITYUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Composite View for LCM Legal Transaction Entity Main view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionEntityUUID I_LegalTransactionEntity LegalTransactionEntityUUID Universal Unique ID
LglCntntMRank I_LegalTransactionEntity LglCntntMRank Seq No
LglCntntMEntity I_LegalTransactionEntity LglCntntMEntity Entity ID
LglCntntMEntityType I_LegalTransactionEntity LglCntntMEntityType Entity Type
LglCntntMTechEntityType I_LegalTransactionEntity LglCntntMTechEntityType Entity Techn. Type
LegalTransactionUUID I_LegalTransactionEntity LegalTransactionUUID Universal Unique ID
LegalTransactionMandatoryFlag I_LegalTransactionEntity LegalTransactionMandatoryFlag Mandatory
LglCntntMIsMainEntity I_LegalTransactionEntity LglCntntMIsMainEntity Main Entity
_LegalTransaction _LegalTransaction
_EntityTypeText _EntityTypeText
_LCMEntityTypeText _LCMEntityTypeText
_Supplier I_LegalTransactionEntity _Supplier
_Customer I_LegalTransactionEntity _Customer
_BusinessPartner I_LegalTransactionEntity _BusinessPartner

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_LegalTransactionEntityMain.
-- 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: ILEGALTRENTITYM

CREATE VIEW I_LegalTransactionEntityMain AS
SELECT
  LegalTransactionEntity.LegalTransactionEntityUUID AS LegalTransactionEntityUUID,
  LegalTransactionEntity.LglCntntMRank AS LglCntntMRank,
  LegalTransactionEntity.LglCntntMEntity AS LglCntntMEntity,
  LegalTransactionEntity.LglCntntMEntityType AS LglCntntMEntityType,
  LegalTransactionEntity.LglCntntMTechEntityType AS LglCntntMTechEntityType,
  LegalTransactionEntity.LegalTransactionUUID AS LegalTransactionUUID,
  LegalTransactionEntity.LegalTransactionMandatoryFlag AS LegalTransactionMandatoryFlag,
  LegalTransactionEntity.LglCntntMIsMainEntity AS LglCntntMIsMainEntity,
  LegalTransactionEntity._Supplier AS _Supplier,
  LegalTransactionEntity._Customer AS _Customer,
  LegalTransactionEntity._BusinessPartner AS _BusinessPartner
FROM I_LegalTransactionEntity AS LegalTransactionEntity
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LCMEntityTypeText AS _EntityTypeText ON LglCntntMEntityType = _EntityTypeText.LglCntntMEntityType AND _EntityTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LCMEntityTypeText AS _LCMEntityTypeText ON LglCntntMEntityType = _LCMEntityTypeText.LglCntntMEntityType  -- association [0..*]
;

Learn More