C_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 C_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: CLCMOBLGNTP

CREATE VIEW C_LglCntntMDocObligationTP AS
SELECT
  _LglCntntMDocObligationTP.LglCntntMDocOblgnUUID AS LglCntntMDocOblgnUUID,
  _LglCntntMDocObligationTP.LglCntntMDocObligation AS LglCntntMDocObligation,
  LglCntntMDocOblgnType,
  _LglCntntMDocOblgnTypeVH.LglCntntMDocOblgnTypeName AS LglCntntMDocOblgnTypeName,
  _LglCntntMDocObligationTP.LglCntntMDocument AS LglCntntMDocument,
  _LglCntntMDocObligationTP.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  LegalTransaction,
  LglCntntMDocObligationDesc,
  LglCntntMDocOblgnStrtDte,
  LglCntntMDocOblgnEndDte,
  LglCntntMDocOblgnRisk,
  LglCntntMDocOblgnCndnTxt,
  LglCntntMDocOblgnHasRem,
  LglCntntMOblgnDescMimeType,
  LglCntntMOblgnCndnMimeType,
  _LglCntntMDocObligationTP._DocumentAuth AS _DocumentAuth
FROM I_LglCntntMDocObligationTP AS _LglCntntMDocObligationTP
LEFT OUTER JOIN C_LCMDocumentTP AS _LCMDocumentTP ON LglCntntMDocumentUUID = _LCMDocumentTP.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_LglCntntMDocOblgnRcpntTP AS _LglCntntMDocOblgnRcpntTP ON LglCntntMDocOblgnUUID = _LglCntntMDocOblgnRcpntTP.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 [1..1]
;