C_LegalTransactionQuickView

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_LegalTransactionQuickView.
-- 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: CLGLTRQUICKVIEW

CREATE VIEW C_LegalTransactionQuickView AS
SELECT
  LegalTransaction,
  LegalTransactionUUID,
  LglCntntMEntity,
  _LegalTrEntityAggrgn.LglCntntMEntityName AS LglCntntMEntityName,
  _LegalTrEntityAggrgn.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTrEntityAggrgn.LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  LegalTransactionHealth,
  _LegalTransactionHealthText[1: Language = $session.system_language].LegalTransactionHealthName AS LegalTransactionHealthName,
  LglCntntMProfile,
  IsEndOfPurposeBlocked,
  LglTransAccessLvl,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LegalTransactionQuickView.LegalTransactionEntityUUID AS LegalTransactionEntityUUID
FROM I_LegalTransactionQuickView AS LegalTransactionQuickView
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggrgn ON LegalTransactionEntityUUID = _LegalTrEntityAggrgn.LegalTransactionEntityUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionHealthVH AS _LegalTransactionHealthVH ON LegalTransactionHealth = _LegalTransactionHealthVH.LegalTransactionHealth  -- association [0..1]
;