I_LglCntntMDocAgeAnalysis

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_LglCntntMDocAgeAnalysis.
-- 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: ILCMDOCANA
-- Parameters: P_LglCntntMResidenceTime : int4

CREATE VIEW I_LglCntntMDocAgeAnalysis AS
SELECT
  _Document.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  _Document.LglCntntMDocument AS LglCntntMDocument,
  _Document.DocumentDescription AS DocumentDescription,
  _Document.LegalTransaction AS LegalTransaction,
  _Document.LegalTransactionUUID AS LegalTransactionUUID,
  _ContentType.LglCntntMDocContentType AS LglCntntMDocContentType,
  _ContentType.LglCntntMDocContentTypeName AS LglCntntMDocContentTypeName,
  _Document.LglCntntMLanguage AS LglCntntMLanguage,
  _LanguageText.LanguageName AS LanguageName,
  _Document.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  _Document.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  _Document.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  _Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _Document.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime
FROM I_LcmDocument AS _Document
LEFT OUTER JOIN I_LglCntntMDocToBeAged ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON _LanguageText.Language = $session.system_language AND _Document.LglCntntMLanguage = _LanguageText.LanguageCode  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocContentTypeText AS _ContentType ON _Document.LglCntntMDocContentType = _ContentType.LglCntntMDocContentType AND _ContentType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_LcmDocument AS _DocumentAuth ON LglCntntMDocumentUUID = _DocumentAuth.LglCntntMDocumentUUID  -- association [1..1]
;