I_LcmDocumentTP

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_LcmDocumentTP.
-- 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: ILCMDOCUMENTTP

CREATE VIEW I_LcmDocumentTP AS
SELECT
  I_LcmDocument.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  I_LcmDocument.LglCntntMDocument AS LglCntntMDocument,
  I_LcmDocument.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  I_LcmDocument.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  I_LcmDocument.LglCntntMDocumentIsTopVersion AS LglCntntMDocumentIsTopVersion,
  I_LcmDocument.LegalTransaction AS LegalTransaction,
  I_LcmDocument.LegalTransactionUUID AS LegalTransactionUUID,
  I_LcmDocument.LegalTransactionTitle AS LegalTransactionTitle,
  I_LcmDocument.LglCntntMDocContentType AS LglCntntMDocContentType,
  I_LcmDocument.LglCntntMLanguage AS LglCntntMLanguage,
  I_LcmDocument.LglCntntMParentDocument AS LglCntntMParentDocument,
  I_LcmDocument.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  I_LcmDocument.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  I_LcmDocument.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  I_LcmDocument.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  I_LcmDocument.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  I_LcmDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_LcmDocument.LglCntntMIsMandatory AS LglCntntMIsMandatory,
  I_LcmDocument.LglCntntMAgingTemperature AS LglCntntMAgingTemperature,
  I_LcmDocument.DocumentDescription AS DocumentDescription,
  I_LcmDocument.LglCntntMProfile AS LglCntntMProfile,
  I_LcmDocument.InternalDocumentStatus AS InternalDocumentStatus,
  I_LcmDocument.LglCntntMSignatureDocStatus AS LglCntntMSignatureDocStatus,
  I_LcmDocument.DocumentVersion AS DocumentVersion,
  I_LcmDocument.LegalDocumentVersion AS LegalDocumentVersion,
  I_LcmDocument.LglCntntMDocType AS LglCntntMDocType,
  I_LcmDocument.LglCntntMDocAssemblyStatus AS LglCntntMDocAssemblyStatus,
  I_LcmDocument.LglCntntMLongTextUUID AS LglCntntMLongTextUUID,
  I_LcmDocument.LglCntntMLongText AS LglCntntMLongText,
  I_LcmDocument.LglCntntMLongTextMimeType AS LglCntntMLongTextMimeType,
  I_LcmDocument.LglCntntMTmplUUID AS LglCntntMTmplUUID,
  I_LcmDocument.LglCntntMVirtualDocVersKey AS LglCntntMVirtualDocVersKey,
  I_LcmDocument.LglCntntMVirtualDocSyncSts AS LglCntntMVirtualDocSyncSts,
  I_LcmDocument.LglCntntMCntxtDocUUID AS LglCntntMCntxtDocUUID,
  I_LcmDocument.LglCntntMCreatedFromDocUUID AS LglCntntMCreatedFromDocUUID,
  I_LcmDocument.LglCntntMMainLinkdObjType AS LglCntntMMainLinkdObjType,
  I_LcmDocument.LglCntntMMainLinkedObject AS LglCntntMMainLinkedObject,
  I_LcmDocument.LglCntntMDocEffectiveFromDate AS LglCntntMDocEffectiveFromDate,
  I_LcmDocument.LglCntntMDocAmendmentType AS LglCntntMDocAmendmentType,
  I_LcmDocument.LglCntntMSgntrPreference AS LglCntntMSgntrPreference,
  I_LcmDocument.LegalDocumentSource AS LegalDocumentSource,
  I_LcmDocument.LglCntntMDocReferenceNumber AS LglCntntMDocReferenceNumber,
  I_LcmDocument.LglCntntMDocLowTouchLevel AS LglCntntMDocLowTouchLevel,
  I_LcmDocument.LglCntntMDocRefreshStatus AS LglCntntMDocRefreshStatus,
  cast( '' as abap.char(200) ) AS FileName,
  cast( '' as abap.char(128) ) AS MimeType,
  cast( '' as dokar ) AS DocumentInfoRecordDocType,
  cast( '' as abap.char(25) ) AS DocumentInfoRecordDocNumber,
  cast( '' as abap.char(3) ) AS DocumentInfoRecordDocPart,
  cast( '' as abap.char(2) ) AS DocumentInfoRecordDocVersion,
  cast( '' as abap.char(32) ) AS LogicalDocument,
  cast( '' as abap.char(32) ) AS PhysicalDocument,
  cast( '' as sysuuid_c ) AS FileUUID,
  '' AS LglCntntMDocIsVersCreateEnable,
  '' AS LglCntntMDocumentHasStamp,
  '' AS LglCntntMDocIsCheckedIn,
  '' AS LglCntntMDocIsCrteStmpEnbld,
  '' AS LglCntntMDocIsCrteOblgnEnbld,
  '' AS LglCntntMDocIsFileChanged,
  '' AS LglCntntMIsVarblPushRqd,
  cast( 00 as lcm_created_on ) AS LglCntntMDocCheckOutTime,
  cast( '' as lcm_doc_created_from ) AS LegalDocumentCreatedFrom,
  cast( '' as lcm_tmpl_name ) AS LglCntntMTmplName,
  cast ('' as abap.char(4) ) AS IsCloudSystem,
  cast ( '' as abap.char(255) ) AS LglCntntMDocVirtualDocURL,
  LglCntntMNmbrOfAdminvDocUpdt,
  LglCntntMDocumentKind,
  I_LcmDocument.LglCntntMDocPaperType AS LglCntntMDocPaperType,
  cast ('' as abap.char(255) ) AS LglCntntMVirtualDocDownloadURL,
  I_LcmDocument.LglCntntMGovLaw AS LglCntntMGovLaw,
  _Context.LglCntntMContext AS LglCntntMContext,
  I_LcmDocument.LglCntntMDocLockedReasonCode AS LglCntntMDocLockedReasonCode,
  I_LcmDocument.LglCntntMDocIsToBeDeleted AS LglCntntMDocIsToBeDeleted,
  _LglCntntMTemplate.LglCntntMTmplID AS LglCntntMTmplID,
  LglCntntMCntxtDocumentID,
  LglCntntMIsIntegRelevant,
  I_LcmDocument._LegalTransaction AS _LegalTransaction,
  I_LcmDocument._DocAttach AS _DocAttach,
  I_LcmDocument._ContentTypeText AS _ContentTypeText,
  I_LcmDocument._DocumentKindText AS _DocumentKindText,
  I_LcmDocument._AccessLvlText AS _AccessLvlText,
  I_LcmDocument._DocStatusText AS _DocStatusText,
  I_LcmDocument._SgntrDocStatusText AS _SgntrDocStatusText,
  I_LcmDocument._DocSyncStatusText AS _DocSyncStatusText,
  I_LcmDocument._LglCntntMDocLowTouchLvlTxt AS _LglCntntMDocLowTouchLvlTxt,
  I_LcmDocument._LglCntntMDocAmendmentTypeTxt AS _LglCntntMDocAmendmentTypeTxt,
  I_LcmDocument._LglCntntMSgntrPreferenceText AS _LglCntntMSgntrPreferenceText,
  I_LcmDocument._LglCntntMDocAssemblyInfo AS _LglCntntMDocAssemblyInfo,
  I_LcmDocument._LglCntntMDocPaperTypeTxt AS _LglCntntMDocPaperTypeTxt
FROM I_LcmDocument
LEFT OUTER JOIN I_LglCntntMDocumentStampTP AS _LglCntntMDocumentStampTP ON LglCntntMDocumentUUID = _LglCntntMDocumentStampTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMDocTemplateInfoTP AS _LglCntntMDocTemplateInfoTP ON LglCntntMDocumentUUID = _LglCntntMDocTemplateInfoTP.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocParCategoryTP AS _LglCntntMDocParCategoryTP ON LglCntntMDocumentUUID = _LglCntntMDocParCategoryTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMVirtualDocVersTP AS _LglCntntMVirtualDocVersTP ON LglCntntMDocumentUUID = _LglCntntMVirtualDocVersTP.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LcmDocument AS _ParentDocument ON LglCntntMParentDocument = _ParentDocument.LglCntntMDocument  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMDocStatusChgsTP AS _LglCntntMDocStatusChgsTP ON LglCntntMDocumentUUID = _LglCntntMDocStatusChgsTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMDocObligationTP AS _LglCntntMDocObligationTP ON LglCntntMDocumentUUID = _LglCntntMDocObligationTP.LglCntntMDocumentUUID  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMDocAggregation AS _LglCntntMDocAggregation ON _LglCntntMDocAggregation.LglCntntMDocumentUUID = LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN E_LegalDocument AS _Extenstion ON LglCntntMDocumentUUID = _Extenstion.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMTemplate AS _LglCntntMTemplate ON LglCntntMTmplUUID = _LglCntntMTemplate.LglCntntMTmplUUID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocAgreementTP AS _LglCntntMDocAgreementTP ON LglCntntMDocumentUUID = _LglCntntMDocAgreementTP.LglCntntMDocumentUUID  -- association [0..1]
;