C_LegalTrRelationshipTP

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_LegalTrRelationshipTP.
-- 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: CLEGALTRRELSHPTP

CREATE VIEW C_LegalTrRelationshipTP AS
SELECT
  LglTransactionRelshp.LegalTransactionRelshpUUID AS LegalTransactionRelshpUUID,
  LglTransactionRelshp.RelshpLegalTransactionUUID AS RelshpLegalTransactionUUID,
  LglCntntMRelshpType,
  LglTransactionRelshp.RelshpLegalTransaction AS LegalTransaction,
  _LegalTransactionIdValueHelp.LegalTransactionTitle AS RelshpLegalTransactionTitle,
  _LegalTransactionIdValueHelp._Context.LglCntntMContext AS LegalContext,
  _LegalTransactionIdValueHelp._Context.LglCntntMContextTitle AS LglCntntMContextTitle,
  '' AS LglCntntMIsMandatory,
  LegalTransactionMandatoryFlag,
  LglCntntMIsIntegRelevant,
  LglTransactionRelshp.LegalTransactionUUID AS LegalTransactionUUID,
  LglCntntMLglTransLockCode,
  _LglTransLockText.LglCntntMLglTransLockCodeText AS LglCntntMLglTransLockCodeText,
  _LegalTransactionAggrgn.LglTransHealthCriticality AS LglTransHealthCriticality,
  LegalTransactionHealth,
  _LegalTransHealthVH.LegalTransactionHealthName AS LegalTransactionHealthName,
  0 AS LglCntntMMandDocCnt
FROM I_LegalTrRelationshipTP AS LglTransactionRelshp
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON LegalTransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LCMRelationshipTypeValueHelp AS _RelationshipTypeValueHelp ON LglCntntMRelshpType = _RelationshipTypeValueHelp.LglCntntMRelshpType  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionQuickView AS _LegalTransactionQuickView ON LegalTransaction = _LegalTransactionQuickView.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMLglTransLockText AS _LglTransLockText ON _LglTransLockText.LglCntntMLglTransLockCode = LglCntntMLglTransLockCode  -- association [1..1]
LEFT OUTER JOIN C_LegalTransactionHealthVH AS _LegalTransHealthVH ON LegalTransactionHealth = _LegalTransHealthVH.LegalTransactionHealth  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionAggr AS _LegalTransactionAggrgn ON RelshpLegalTransactionUUID = _LegalTransactionAggrgn.LegalTransactionUUID  -- association [1..1]
;