C_LglCntntMReltdLglTransList

DDL: C_LGLCNTNTMRELTDLGLTRANSLIST SQL: CLCMRELTDLTS Type: view CONSUMPTION Package: ODATA_LCM_LT
7 Fields 2 Data Sources

Related Legal Transactions of a Legal Transaction

C_LglCntntMReltdLglTransList is a Consumption CDS View that provides data about "Related Legal Transactions of a Legal Transaction" in SAP S/4HANA. It reads from 2 data sources (I_LegalTransaction, I_LegalTrRelationship) and exposes 7 fields. Part of development package ODATA_LCM_LT.

Data Sources (2)

SourceAliasJoin Type
I_LegalTransaction LegalTransaction union
I_LegalTrRelationship Relationship from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLCMRELTDLTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Related Legal Transactions of a Legal Transaction view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
LegalTransaction _LegalTransaction LegalTransaction Legal Transaction ID
LegalTransactionUUID I_LegalTrRelationship LegalTransactionUUID Universal Unique ID
RelshpLegalTransaction I_LegalTrRelationship RelshpLegalTransaction Legal Transaction ID
LegalTransactionasLegalTransaction
LegalTransactionUUID I_LegalTransaction LegalTransactionUUID Universal Unique ID
RelshpLegalTransaction I_LegalTransaction LegalTransaction Legal Transaction ID
RelshpLegalTransactionUUID I_LegalTransaction LegalTransactionUUID Universal Unique ID

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_LglCntntMReltdLglTransList.
-- 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: CLCMRELTDLTS

CREATE VIEW C_LglCntntMReltdLglTransList AS
SELECT
  _LegalTransaction.LegalTransaction AS LegalTransaction,
  Relationship.LegalTransactionUUID AS LegalTransactionUUID,
  Relationship.RelshpLegalTransaction AS RelshpLegalTransaction,
  Relationship.RelshpLegalTransactionUUID as RelshpLegalTransactionUUID AS LegalTransactionasLegalTransaction,
  LegalTransaction.LegalTransactionUUID AS RelshpLegalTransactionUUID
FROM I_LegalTrRelationship AS Relationship
-- UNION with additional select branch(es): I_LegalTransaction
;

Learn More