I_LglCntntMNotesLglTransObjDet

DDL: I_LGLCNTNTMNOTESLGLTRANSOBJDET SQL: ILCMNOTELTOBJDET Type: view COMPOSITE

Related Objects for Legal Transactions

I_LglCntntMNotesLglTransObjDet is a Composite CDS View that provides data about "Related Objects for Legal Transactions" in SAP S/4HANA. It reads from 3 data sources (I_LglCntntMNotesDocObjDet, I_LglCntntMNotesLglTransObj, I_LglCntntMNotesLglTransObj) and exposes 16 fields with key fields LglCntntMParApplObjUUID, LglCntntMObjType, LglCntntMObjUUID, LglCntntMObjType, LglCntntMObjUUID.

Data Sources (3)

SourceAliasJoin Type
I_LglCntntMNotesDocObjDet DOC inner
I_LglCntntMNotesLglTransObj I_LglCntntMNotesLglTransObj from
I_LglCntntMNotesLglTransObj LT union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ILCMNOTELTOBJDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Related Objects for Legal Transactions view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMParApplObjUUID LglCntntMParApplObjUUID Universal Unique ID
KEY LglCntntMObjType LglCntntMObjType
KEY LglCntntMObjUUID LglCntntMObjUUID Universal Unique ID
LglCntntMObjectID LglCntntMObjectID Object ID
LglCntntMObjTitle LglCntntMObjTitle
LglCntntMParObjUUID LglCntntMParObjUUID Universal Unique ID
LglCntntMParObjID LglCntntMParObjID Legal Transaction ID
LglCntntMParObjTitle LglCntntMParObjTitle
KEY LglCntntMObjType I_LglCntntMNotesDocObjDet LglCntntMObjType
KEY LglCntntMObjUUID I_LglCntntMNotesDocObjDet LglCntntMObjUUID Universal Unique ID
LglCntntMObjectID I_LglCntntMNotesDocObjDet LglCntntMObjectID Object ID
LglCntntMObjTitle I_LglCntntMNotesDocObjDet LglCntntMObjTitle
LglCntntMParObjUUID I_LglCntntMNotesDocObjDet LglCntntMParObjUUID Universal Unique ID
LglCntntMParObjID I_LglCntntMNotesDocObjDet LglCntntMParObjID Legal Transaction ID
LglCntntMParObjTitle I_LglCntntMNotesDocObjDet LglCntntMParObjTitle
_LegalTransaction I_LglCntntMNotesLglTransObj _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_LglCntntMNotesLglTransObjDet.
-- 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: ILCMNOTELTOBJDET

CREATE VIEW I_LglCntntMNotesLglTransObjDet AS
SELECT
  LglCntntMParApplObjUUID,
  LglCntntMObjType,
  LglCntntMObjUUID,
  LglCntntMObjectID,
  LglCntntMObjTitle,
  LglCntntMParObjUUID,
  LglCntntMParObjID,
  LglCntntMParObjTitle,
  LT._LegalTransaction AS _LegalTransaction
FROM I_LglCntntMNotesLglTransObj
INNER JOIN I_LglCntntMNotesDocObjDet AS DOC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_LglCntntMNotesLglTransObj
;