I_LglCntntMDocObligationTP

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_LglCntntMDocObligationTP.
-- 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: ILCMDOCOBLGNTP

CREATE VIEW I_LglCntntMDocObligationTP AS
SELECT
  LglCntntMDocOblgnUUID,
  LglCntntMDocumentUUID,
  LglCntntMDocObligation,
  LglCntntMDocOblgnType,
  _LCMDocumentTP.LglCntntMDocument AS LglCntntMDocument,
  LglCntntMDocObligationDesc,
  LglCntntMDocOblgnRisk,
  LglCntntMDocOblgnStrtDte,
  LglCntntMDocOblgnEndDte,
  LglCntntMDocOblgnCndnTxt,
  LglCntntMDocOblgnHasRem,
  _LCMDocumentTP.LegalTransaction AS LegalTransaction,
  LglCntntMDocOblgnDescUUID,
  LglCntntMDocOblgnCndnUUID,
  LglCntntMDocOblgnChgInDescTxt,
  LglCntntMDocOblgnChgInCndnTxt,
  LglCntntMOblgnDescMimeType,
  LglCntntMOblgnCndnMimeType
FROM I_LglCntntMDocObligation
LEFT OUTER JOIN I_LcmDocumentTP AS _LCMDocumentTP ON LglCntntMDocumentUUID = _LCMDocumentTP.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnEntityTP AS _LglCntntMDocOblgnEntityTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnEntityTP.LglCntntMDocOblgnUUID  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMDocOblgnTypeTxt AS _LglCntntMDocOblgnTypeTxt ON LglCntntMDocOblgnType = _LglCntntMDocOblgnTypeTxt.LglCntntMDocOblgnType AND _LglCntntMDocOblgnTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnRiskText AS _LglCntntMDocOblgnRiskText ON LglCntntMDocOblgnRisk = _LglCntntMDocOblgnRiskText.LglCntntMDocOblgnRisk AND _LglCntntMDocOblgnRiskText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnRemTP AS _LglCntntMDocOblgnRemTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnRemTP.LglCntntMDocOblgnUUID  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMDocOblgnRcpntTP AS _LglCntntMDocOblgnRcpntTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnRcpntTP.LglCntntMDocOblgnUUID  -- association [1..*]
;