C_LegalTransactionDocLinkTP

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_LegalTransactionDocLinkTP.
-- 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: CLTDOCLINKTP

CREATE VIEW C_LegalTransactionDocLinkTP AS
SELECT
  DocumentLink.LegalTransactionDocLinkUUID AS LegalTransactionDocLinkUUID,
  DocumentLink.LglCntntMDocument AS LegalDocument,
  _Document.DocumentDescription AS DocumentDescription,
  _Document.LegalTransaction AS LegalTransaction,
  LglCntntMDocumentLinkedObject,
  LglCntntMDocumentLinkedObjKey,
  _Document.LglCntntMDocContentType AS LglCntntMDocContentType,
  _Document.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  _Document.LglCntntMDocStatusName AS LglCntntMDocStatusName,
  _Document.LegalTransactionUUID AS DocLinkLegalTransactionUUID,
  DocumentLink.LegalTransactionUUID AS LegalTransactionUUID,
  cast( '' as abap.char(200) ) AS FileName,
  _Document.LglCntntMDocType AS LglCntntMDocType
FROM I_LegalTransactionDocLinkTP AS DocumentLink
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LcmDocument AS _Document ON LegalDocument = _Document.LglCntntMDocument AND _Document.LglCntntMDocumentIsTopVersion = 'X'  -- association [1..*]
LEFT OUTER JOIN C_LglCntntMDocumentIdValueHelp AS _LglCntntMDocumentIdValueHelp ON LegalDocument = _LglCntntMDocumentIdValueHelp.LglCntntMDocument  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON LegalTransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMDocContentTypeVH AS _LglCntntMDocContentTypeVH ON LglCntntMDocContentType = _LglCntntMDocContentTypeVH.LglCntntMDocContentType  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMDocAccLvlVH AS _LglCntntMDocAccLvlVH ON LglCntntMDocAccessLvl = _LglCntntMDocAccLvlVH.LglCntntMAccessLvl  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionQuickView AS _LegalTransactionQuickView ON LegalTransaction = _LegalTransactionQuickView.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionNavigation ON DocLinkLegalTransactionUUID = _LegalTransactionNavigation.LegalTransactionUUID  -- association [0..1]
;