A_LegalDocument

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 A_LegalDocument.
-- 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: ALEGALDOCUMENT

CREATE VIEW A_LegalDocument AS
SELECT
  LegalDocument.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  LegalDocument.LglCntntMDocument AS LglCntntMDocument,
  LegalDocument.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  LegalDocument.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  LegalDocument.LegalTransaction AS LegalTransaction,
  LegalDocument.LegalTransactionUUID AS LegalTransactionUUID,
  LegalDocument.LglCntntMDocContentType AS LglCntntMDocContentType,
  LegalDocument.LglCntntMLanguage AS LglCntntMLanguage,
  LegalDocument.DocumentDescription AS DocumentDescription,
  LegalDocument.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  LegalDocument.LegalDocumentSource AS LegalDocumentSource,
  LegalDocument.LglCntntMDocPaperType AS LglCntntMDocPaperType,
  LegalDocument.LglCntntMMainLinkdObjType AS LglCntntMMainLinkdObjType,
  LegalDocument.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  LegalDocument.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  LegalDocument.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  LegalDocument.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  LegalDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  LegalDocument.InternalDocumentStatus AS InternalDocumentStatus,
  LegalDocument.LglCntntMProfile AS LglCntntMProfile,
  LegalDocument._LegalTransaction.LglTransAccessLvl AS LglTransAccessLvl,
  LegalDocument._LegalTransaction.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalDocument._LegalTransaction.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  LegalDocument._LegalTransaction.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  LegalDocument.LglCntntMDocumentIsTopVersion AS LglCntntMDocumentIsTopVersion,
  LegalDocument.LglCntntMVirtualDocVersKey AS LglCntntMVirtualDocVersKey,
  LegalDocument._LglCntntMDocAssemblyInfo.LglCntntMDocAssemblyStatus AS LglCntntMDocAssemblyStatus,
  LegalDocument.LglCntntMTmplID AS LglCntntMTmplID,
  LegalDocument.LglCntntMDocType AS LglCntntMDocType,
  LegalDocument.LglCntntMDocLowTouchLevel AS LglCntntMDocLowTouchLevel,
  LegalDocument.LglCntntMParentDocument AS LglCntntMParentDocument,
  LegalDocument.LglCntntMDocumentKind AS LglCntntMDocumentKind,
  LegalDocument.LglCntntMDocAmendmentType AS LglCntntMDocAmendmentType,
  LegalDocument.LglCntntMDocEffectiveFromDate AS LglCntntMDocEffectiveFromDate,
  _LglCntntMDocEffectiveDate.LglCntntMFromDate AS LglCntntMDocEffectiveToDate,
  LglCntntMSgntrPreference,
  LegalDocument.LglCntntMDocLockedReasonCode AS LglCntntMDocLockedReasonCode,
  _LglCntntMDocLockedReasonText.LglCntntMDocLockedReasonText AS LglCntntMDocLockedReasonText
FROM I_LcmDocumentTP AS LegalDocument
LEFT OUTER JOIN A_LglDocStamp AS _LglCntntMDocumentStampTP ON LglCntntMDocumentUUID = _LglCntntMDocumentStampTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN A_LglCntntMDocParCategory AS _LglCntntMDocParCategoryTP ON LglCntntMDocumentUUID = _LglCntntMDocParCategoryTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN A_LegalDocAgreement AS _LglCntntMDocAgreementTP ON LglCntntMDocumentUUID = _LglCntntMDocAgreementTP.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionDate AS _LglCntntMDocEffectiveDate ON LegalTransactionUUID = _LglCntntMDocEffectiveDate.LegalTransactionUUID AND _LglCntntMDocEffectiveDate.LglCntntMDateType = 'SAP2'  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocLockedReasonText AS _LglCntntMDocLockedReasonText ON LglCntntMDocLockedReasonCode = _LglCntntMDocLockedReasonText.LglCntntMDocLockedReasonCode  -- association [1..1]
;