C_LegalTrRelationShip

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_LegalTrRelationShip.
-- 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: CLEGALTRRELSHP

CREATE VIEW C_LegalTrRelationShip AS
SELECT
  LegalTransactionRelshpUUID,
  RelshpLegalTransactionUUID,
  LglCntntMRelshpType,
  _LCMRelationshipTypeValueHelp.LglCntntMRelTypeName AS LglCntntMRelTypeName,
  RelshpLegalTransaction,
  _LegalTransactionIdValueHelp.LegalTransactionTitle AS RelshpLegalTransactionTitle,
  cast ( '' as lcm_is_mandatory preserving type ) AS LglCntntMIsMandatory,
  LegalTransactionMandatoryFlag,
  LegalTransactionUUID,
  _LegalTransactionIdValueHelp.LglCntntMContext AS LglCntntMContext,
  _LegalTransactionIdValueHelp.LglCntntMContextTitle AS LglCntntMContextTitle
FROM I_LegalTrRelationship
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON RelshpLegalTransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LCMRelationshipTypeValueHelp AS _LCMRelationshipTypeValueHelp ON LglCntntMRelshpType = _LCMRelationshipTypeValueHelp.LglCntntMRelshpType  -- association [0..1]
;