C_LegalTransactionEntityMain

DDL: C_LEGALTRANSACTIONENTITYMAIN SQL: CLEGALTRENTITYM Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Legal Transaction Entity

C_LegalTransactionEntityMain is a Consumption CDS View that provides data about "Legal Transaction Entity" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionEntityMain) and exposes 11 fields with key field LegalTransactionEntityUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionEntityMain LglTransactionEntityMain from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LegalTrEntityAggr _LegalTrEntityAggrgn $projection.LegalTransactionEntityUUID = _LegalTrEntityAggrgn.LegalTransactionEntityUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLEGALTRENTITYM view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Legal Transaction Entity view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.semanticKey LglCntntMIsMainEntity view
ObjectModel.representativeKey LegalTransactionEntityUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionEntityUUID LegalTransactionEntityUUID Universal Unique ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMIsMainEntity LglCntntMIsMainEntity Main Entity
LglCntntMEntityType I_LegalTransactionEntityMain LglCntntMEntityType Entity Type
LglCntntMEntityName _LegalTrEntityAggrgn LglCntntMEntityName
LglCntntMTechEntityType I_LegalTransactionEntityMain LglCntntMTechEntityType Entity Techn. Type
LglCntntMEntity LglCntntMEntity Entity ID
_LegalTransaction _LegalTransaction
_Supplier I_LegalTransactionEntityMain _Supplier
_Customer I_LegalTransactionEntityMain _Customer
_BusinessPartner I_LegalTransactionEntityMain _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 C_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: CLEGALTRENTITYM

CREATE VIEW C_LegalTransactionEntityMain AS
SELECT
  LegalTransactionEntityUUID,
  LegalTransactionUUID,
  LglCntntMIsMainEntity,
  LglTransactionEntityMain.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTrEntityAggrgn.LglCntntMEntityName AS LglCntntMEntityName,
  LglTransactionEntityMain.LglCntntMTechEntityType AS LglCntntMTechEntityType,
  LglCntntMEntity,
  LglTransactionEntityMain._Supplier AS _Supplier,
  LglTransactionEntityMain._Customer AS _Customer,
  LglTransactionEntityMain._BusinessPartner AS _BusinessPartner
FROM I_LegalTransactionEntityMain AS LglTransactionEntityMain
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggrgn ON LegalTransactionEntityUUID = _LegalTrEntityAggrgn.LegalTransactionEntityUUID  -- association [0..1]
;

Learn More