C_LglCntntMNotesLglTransObj

DDL: C_LGLCNTNTMNOTESLGLTRANSOBJ SQL: CLCMNOTELTOBJ Type: view CONSUMPTION
10 Fields 1 Associations

Related Objects for Legal Transactions

C_LglCntntMNotesLglTransObj is a Consumption CDS View that provides data about "Related Objects for Legal Transactions" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LcmDocument _DocumentAuth _DocumentAuth.LglCntntMDocumentUUID = LTObj.LglCntntMParObjUUID and LglCntntMObjType = 'DOC'

Annotations (9)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMParApplObjUUID LTObj LglCntntMParApplObjUUID
KEY LglCntntMObjType LTObj LglCntntMObjType
KEY LglCntntMObjUUID LTObj LglCntntMObjUUID
LglCntntMObjectID LTObj LglCntntMObjectID Object ID
LglCntntMObjTitle LTObj LglCntntMObjTitle
LglCntntMParObjUUID LTObj LglCntntMParObjUUID
LglCntntMParObjID LTObj LglCntntMParObjID
LglCntntMParObjTitle LTObj LglCntntMParObjTitle
_LegalTransaction _LegalTransaction
_DocumentAuth _DocumentAuth

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_LglCntntMNotesLglTransObj.
-- 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: CLCMNOTELTOBJ

CREATE VIEW C_LglCntntMNotesLglTransObj AS
SELECT
  LTObj.LglCntntMParApplObjUUID AS LglCntntMParApplObjUUID,
  LTObj.LglCntntMObjType AS LglCntntMObjType,
  LTObj.LglCntntMObjUUID AS LglCntntMObjUUID,
  LTObj.LglCntntMObjectID AS LglCntntMObjectID,
  LTObj.LglCntntMObjTitle AS LglCntntMObjTitle,
  LTObj.LglCntntMParObjUUID AS LglCntntMParObjUUID,
  LTObj.LglCntntMParObjID AS LglCntntMParObjID,
  LTObj.LglCntntMParObjTitle AS LglCntntMParObjTitle
LEFT OUTER JOIN I_LcmDocument AS _DocumentAuth ON _DocumentAuth.LglCntntMDocumentUUID = LTObj.LglCntntMParObjUUID AND LglCntntMObjType = 'DOC'  -- association [1..1]
;

Learn More