R_LegalDocumentTP

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 R_LegalDocumentTP.
-- 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.

CREATE VIEW R_LegalDocumentTP AS
SELECT
  LglCntntMDocumentUUID,
  LglCntntMDocument,
  LglCntntMDocumentLinkedObject,
  LglCntntMDocumentLinkedObjKey,
  LegalTransaction,
  LegalTransactionUUID,
  LglCntntMDocContentType,
  LglCntntMLanguage,
  DocumentDescription,
  LglCntntMDocAccessLvl,
  LegalDocumentSource,
  LglCntntMChangedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMCreatedByUser,
  IsEndOfPurposeBlocked,
  InternalDocumentStatus,
  LglCntntMDocPaperType,
  LglCntntMProfile,
  LglCntntMDocType,
  LglCntntMDocumentIsTopVersion,
  LglCntntMVirtualDocVersKey,
  LglCntntMDocAssemblyStatus,
  LglCntntMTmplUUID,
  LglCntntMDocLowTouchLevel,
  _LglCntntMTemplate.LglCntntMTmplID AS LglCntntMTmplID,
  LglCntntMParentDocument,
  LglCntntMIsMandatory,
  DocumentVersion,
  LegalDocumentVersion,
  LglCntntMDocReferenceNumber,
  LglCntntMDocumentKind,
  LglCntntMMainLinkdObjType,
  LglCntntMDocAmendmentType,
  LglCntntMDocEffectiveFromDate,
  LglCntntMDocEffectiveToDate,
  LglCntntMSgntrPreference,
  LglCntntMMainLinkedObject,
  LglCntntMDocLockedReasonCode,
  _LglCntntMDocLockedReasonText.LglCntntMDocLockedReasonText AS LglCntntMDocLockedReasonText,
  _LegalTransaction.LglTransAccessLvl AS LglTransAccessLvl,
  _LegalTransaction.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  _LegalTransaction.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  _LegalTransaction.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg
FROM I_LcmDocument
LEFT OUTER JOIN I_LglCntntMTemplate AS _LglCntntMTemplate ON LglCntntMTmplUUID = _LglCntntMTemplate.LglCntntMTmplUUID  -- association [0..1]
LEFT OUTER JOIN E_LegalDocument AS _Extenstion ON LglCntntMDocumentUUID = _Extenstion.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN R_LegalDocParCategoryTP AS _LegalDocParCategory ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_LegalDocStampTP AS _LegalDocStamp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_LegalDocObligationTP AS _LegalDocObligation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_LegalDocTmplInfoTP AS _LegalDocTmplInfo ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_LegalDocAgreementTP AS _LegalDocAgreement ON /* condition not available in parsed metadata */  -- association [0..1]
;