I_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 I_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: ILCMDOCOBLGN

CREATE VIEW I_LglCntntMDocObligation AS
SELECT
  LglCntntMDocOblgnUUID,
  LglCntntMDocObligation,
  LglCntntMDocOblgnType,
  LglCntntMDocumentUUID,
  LglCntntMDocOblgnRisk,
  LglCntntMDocOblgnStrtDte,
  LglCntntMDocOblgnEndDte,
  LglCntntMDocOblgnHasRem,
  LglCntntMDocOblgnDescUUID,
  LglCntntMDocOblgnCndnUUID,
  LglCntntMDocOblgnChgInDescTxt,
  LglCntntMDocOblgnChgInCndnTxt,
  _NoteDesc.content AS LglCntntMDocObligationDesc,
  _NoteDesc.mimetype AS LglCntntMOblgnDescMimeType,
  _NoteCndn.content AS LglCntntMDocOblgnCndnTxt,
  _NoteCndn.mimetype AS LglCntntMOblgnCndnMimeType
FROM lcm_obligation
LEFT OUTER JOIN I_LegalDocument AS _DocumentAuth ON LglCntntMDocumentUUID = _DocumentAuth.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Cont AS _NoteDesc ON _NoteDesc.noteid = LglCntntMDocOblgnDescUUID AND _NoteDesc.objectnodetype = 'LegalDocument' AND _NoteDesc.notetype = 'LCM_DOC_OBL_DESC'  -- association [0..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Cont AS _NoteCndn ON _NoteCndn.noteid = LglCntntMDocOblgnCndnUUID AND _NoteCndn.objectnodetype = 'LegalDocument' AND _NoteCndn.notetype = 'LCM_DOC_OBL_COND'  -- association [0..1]
;