C_LglCntntMDocObligation

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_LglCntntMDocObligation.
-- 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: CLCMOBLGN

CREATE VIEW C_LglCntntMDocObligation AS
SELECT
  LglCntntMDocOblgnUUID,
  _LCMDocument.LglCntntMDocument AS LglCntntMDocument,
  _LCMDocument.DocumentDescription AS DocumentDescription,
  LglCntntMDocObligation,
  LglCntntMDocOblgnType,
  _LglCntntMDocOblgnTypeVH.LglCntntMDocOblgnTypeName AS LglCntntMDocOblgnTypeName,
  LglCntntMDocumentUUID,
  _LCMDocument.LegalTransaction AS LegalTransaction,
  LglCntntMDocObligationDesc,
  LglCntntMDocOblgnStrtDte,
  LglCntntMDocOblgnEndDte,
  LglCntntMDocOblgnHasRem,
  LglCntntMDocOblgnRisk,
  LglCntntMDocOblgnCndnTxt
FROM I_LglCntntMDocObligation
LEFT OUTER JOIN I_LcmDocument AS _LCMDocument ON LglCntntMDocumentUUID = _LCMDocument.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMDocOblgnTypeVH AS _LglCntntMDocOblgnTypeVH ON LglCntntMDocOblgnType = _LglCntntMDocOblgnTypeVH.LglCntntMDocOblgnType  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMDocOblgnEntityTP AS _LglCntntMDocOblgnEntityTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnEntityTP.LglCntntMDocOblgnUUID  -- association [1..*]
LEFT OUTER JOIN C_LglCntntMDocOblgnRcpnt AS _LglCntntMDocOblgnRcpnt ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnRcpnt.LglCntntMDocOblgnUUID  -- association [1..*]
LEFT OUTER JOIN C_LglCntntMDocOblgnRemTP AS _LglCntntMDocOblgnRemTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnRemTP.LglCntntMDocOblgnUUID  -- association [1..*]
LEFT OUTER JOIN C_LglCntntMDocOblgnRiskVH AS _LglCntntMDocOblgnRiskVH ON LglCntntMDocOblgnRisk = _LglCntntMDocOblgnRiskVH.LglCntntMDocOblgnRisk  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnTypeTxt AS _LglCntntMDocOblgnTypeTxt ON LglCntntMDocOblgnType = _LglCntntMDocOblgnTypeTxt.LglCntntMDocOblgnType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnRiskText AS _LglCntntMDocOblgnRiskText ON LglCntntMDocOblgnRisk = _LglCntntMDocOblgnRiskText.LglCntntMDocOblgnRisk AND Language = $session.system_language  -- association [0..1]
;