I_LcmDocument

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_LcmDocument.
-- 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: ILCMDOCUMENT

CREATE VIEW I_LcmDocument AS
SELECT
  Document.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  Document.LglCntntMDocument AS LglCntntMDocument,
  Document.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  Document.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  Document.LglCntntMDocumentIsTopVersion AS LglCntntMDocumentIsTopVersion,
  Document.LegalTransaction AS LegalTransaction,
  Document.LegalTransactionUUID AS LegalTransactionUUID,
  Document.LglCntntMDocContentType AS LglCntntMDocContentType,
  Document.LglCntntMLanguage AS LglCntntMLanguage,
  Document.LglCntntMParentDocument AS LglCntntMParentDocument,
  Document.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  Document.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  Document.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  Document.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  Document.DocumentDescription AS DocumentDescription,
  Document.LglCntntMLongTextUUID AS LglCntntMLongTextUUID,
  Document.LglCntntMIsMandatory AS LglCntntMIsMandatory,
  Document.LegalDocumentSource AS LegalDocumentSource,
  Document.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  Document.LglCntntMAgingTemperature AS LglCntntMAgingTemperature,
  InternalDocumentStatus,
  Document.LglCntntMSignatureDocStatus AS LglCntntMSignatureDocStatus,
  DocumentVersion,
  LegalDocumentVersion,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.LglCntntMDocType AS LglCntntMDocType,
  _LglCntntMDocAssemblyInfo.LglCntntMDocAssemblyStatus AS LglCntntMDocAssemblyStatus,
  Document.LglCntntMTmplUUID AS LglCntntMTmplUUID,
  Document.LglCntntMVirtualDocVersKey AS LglCntntMVirtualDocVersKey,
  Document.LglCntntMVirtualDocSyncSts AS LglCntntMVirtualDocSyncSts,
  Document.LglCntntMCntxtDocUUID AS LglCntntMCntxtDocUUID,
  Document.LglCntntMDocIsToBeDeleted AS LglCntntMDocIsToBeDeleted,
  Document.LglCntntMDocReferenceNumber AS LglCntntMDocReferenceNumber,
  Document.LglCntntMDocLowTouchLevel AS LglCntntMDocLowTouchLevel,
  Document.LglCntntMCreatedFromDocUUID AS LglCntntMCreatedFromDocUUID,
  Document.LglCntntMDocPaperType AS LglCntntMDocPaperType,
  Document.LglCntntMMainLinkdObjType AS LglCntntMMainLinkdObjType,
  Document.LglCntntMMainLinkedObject AS LglCntntMMainLinkedObject,
  Document.LglCntntMDocEffectiveFromDate AS LglCntntMDocEffectiveFromDate,
  _LglCntntMDocEffectiveDate.LglCntntMFromDate AS LglCntntMDocEffectiveToDate,
  Document.LglCntntMDocAmendmentType AS LglCntntMDocAmendmentType,
  Document.LglCntntMSgntrPreference AS LglCntntMSgntrPreference,
  _LegalTransaction.LglCntntMProfile AS LglCntntMProfile,
  _LegalTransaction.LglCntntMGovLaw AS LglCntntMGovLaw,
  _LegalTransaction.LglCntntMContextUUID AS LglCntntMContextUUID,
  _LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  _Note.content AS LglCntntMLongText,
  _Note.mimetype AS LglCntntMLongTextMimeType,
  _DocStatusText.LglCntntMDocStatusName AS LglCntntMDocStatusName,
  _DocLock.LglCntntMDocLockedReasonCode AS LglCntntMDocLockedReasonCode,
  LglCntntMCntxtDocumentID,
  LglCntntMIsIntegRelevant,
  _LglCntntMDocRefreshStatus.LglCntntMDocRefreshStatus AS LglCntntMDocRefreshStatus,
  LglCntntMNmbrOfAdminvDocUpdt,
  LglCntntMDocumentKind
FROM I_LegalDocument AS Document
LEFT OUTER JOIN I_LglCntntMDocStatus AS _DocStatus ON InternalDocumentStatus = _DocStatus.InternalDocumentStatus  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocInfoAttachment AS _DocAttach ON LglCntntMDocumentLinkedObjKey = _DocAttach.LinkedSAPObjectKey  -- association [1..1]
LEFT OUTER JOIN I_LcmContext AS _Context ON LglCntntMContextUUID = _Context.LglCntntMContextUUID  -- association [1..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Cont AS _Note ON _Note.noteid = LglCntntMLongTextUUID AND _Note.objectnodetype = 'LegalDocument' AND _Note.notetype = 'LCM_LONGTEXT'  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocLock AS _DocLock ON LglCntntMDocumentUUID = _DocLock.LglCntntMDocumentUUID AND LglCntntMDocumentLinkedObjKey = _DocLock.LglCntntMDocumentLinkedObjKey  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMAccessLvlText AS _AccessLvlText ON LglCntntMDocAccessLvl = _AccessLvlText.LglCntntMAccessLvl AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON LglCntntMLanguage = _LanguageText.LanguageCode AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocContentTypeText AS _ContentTypeText ON LglCntntMDocContentType = _ContentTypeText.LglCntntMDocContentType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocCntntTypeSrchTxt AS _LglCntntMDocCntntTypeSrchTxt ON LglCntntMDocContentType = _LglCntntMDocCntntTypeSrchTxt.LglCntntMDocContentType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocStatusText AS _DocStatusText ON InternalDocumentStatus = _DocStatusText.InternalDocumentStatus AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMSgntrDocStatusText AS _SgntrDocStatusText ON LglCntntMSignatureDocStatus = _SgntrDocStatusText.LglCntntMSignatureDocStatus AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocSyncStatusText AS _DocSyncStatusText ON LglCntntMVirtualDocSyncSts = _DocSyncStatusText.LglCntntMVirtualDocSyncSts AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocLowTouchLvlTxt AS _LglCntntMDocLowTouchLvlTxt ON LglCntntMDocLowTouchLevel = _LglCntntMDocLowTouchLvlTxt.LglCntntMDocLowTouchLevel AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocumentKindText AS _DocumentKindText ON LglCntntMDocumentKind = _DocumentKindText.LglCntntMDocumentKind AND _DocumentKindText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_LglCntntMDocAmendmentTypeTxt AS _LglCntntMDocAmendmentTypeTxt ON LglCntntMDocAmendmentType = _LglCntntMDocAmendmentTypeTxt.LglCntntMDocAmendmentType AND _LglCntntMDocAmendmentTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_LglCntntMSgntrPreferenceText AS _LglCntntMSgntrPreferenceText ON LglCntntMSgntrPreference = _LglCntntMSgntrPreferenceText.LglCntntMSgntrPreference AND _LglCntntMSgntrPreferenceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocLockedReasonText AS _LglCntntMDocLockedReasonText ON LglCntntMDocLockedReasonCode = _LglCntntMDocLockedReasonText.LglCntntMDocLockedReasonCode  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocRefreshStatus AS _LglCntntMDocRefreshStatus ON LglCntntMDocument = _LglCntntMDocRefreshStatus.LglCntntMDocument  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocTemplateInfo AS _LglCntntMDocTemplateInfo ON LglCntntMDocumentUUID = _LglCntntMDocTemplateInfo.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocInfoAttchAll AS _DocAttachAll ON LglCntntMDocumentLinkedObjKey = _DocAttachAll.LinkedSAPObjectKey  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocumentStamp AS _LglCntntMDocumentStamp ON LglCntntMDocumentUUID = _LglCntntMDocumentStamp.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionDocLink AS _LegalTransactionDocLink ON LglCntntMDocument = _LegalTransactionDocLink.LglCntntMDocument  -- association [0..*]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _CreatedBy ON LglCntntMCreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _ChangedBy ON LglCntntMChangedByUser = _ChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocAssemblyInfo AS _LglCntntMDocAssemblyInfo ON LglCntntMDocumentUUID = _LglCntntMDocAssemblyInfo.LglCntntMDocumentUUID AND Document.LglCntntMVirtualDocVersKey = _LglCntntMDocAssemblyInfo.LglCntntMVirtualDocVersKey  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocPaperTypeTxt AS _LglCntntMDocPaperTypeTxt ON LglCntntMDocPaperType = _LglCntntMDocPaperTypeTxt.LglCntntMDocPaperType AND _LglCntntMDocPaperTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDate AS _LglCntntMDocEffectiveDate ON LegalTransactionUUID = _LglCntntMDocEffectiveDate.LegalTransactionUUID AND _LglCntntMDocEffectiveDate.LglCntntMDateType = 'SAP2'  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocAgreement AS _LglCntntMDocAgreement ON LglCntntMDocumentUUID = _LglCntntMDocAgreement.LglCntntMDocumentUUID  -- association [0..1]
LEFT OUTER JOIN E_LegalDocument AS _Extenstion ON LglCntntMDocumentUUID = _Extenstion.LglCntntMDocumentUUID  -- association [1..1]
;