C_LglCntntMOvwPgSmrtFilter

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_LglCntntMOvwPgSmrtFilter.
-- 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: CLCMSMARTFILTER

CREATE VIEW C_LglCntntMOvwPgSmrtFilter AS
SELECT
  Context.LglCntntMContextUUID AS LglCntntMContextUUID,
  LegalTransaction.LegalTransaction AS LegalTransaction,
  Context.LglCntntMContext AS LegalContext,
  Context.LglCntntMContextTitle AS LglCntntMContextTitle,
  Context.LglCntntMContextVersion AS LglCntntMContextVersion,
  LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  LegalTransaction.LglCntntMEntity AS LglCntntMEntity,
  LegalTransaction.LglCntntMEntityType AS LglCntntMEntityType,
  LegalTransaction._LCMEntityTypeText[1: Language = $session.system_language].LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _LegalTrEntityAggrgn.LglCntntMEntityName AS LglCntntMEntityName,
  LegalTransaction.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  LegalTransaction.LglTransAccessLvl AS LglTransAccessLvl,
  LegalTransaction.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalTransaction.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  LegalTransaction.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  Context.LglCntntMProfile AS LglCntntMProfile,
  Context.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_LCMContextTP AS Context
INNER JOIN I_LegalTransactionTP AS LegalTransaction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_LCMContextIdValueHelp AS _ContextIdValueHelp ON LegalContext = _ContextIdValueHelp.LglCntntMContext AND LglCntntMContextVersion = _ContextIdValueHelp.LglCntntMContextVersion AND LglCntntMContextTitle = _ContextIdValueHelp.LglCntntMContextTitle  -- association [0..1]
LEFT OUTER JOIN C_LCMEntityIDValueHelp AS _EntityIDValueHelp ON LglCntntMEntity = _EntityIDValueHelp.LglCntntMEntity AND LglCntntMEntityType = _EntityIDValueHelp.LglCntntMEntityType AND LglTransAccessLvl = _EntityIDValueHelp.LglCntntMAccessLvl AND LglCntntMMainOrgCoCode = _EntityIDValueHelp.LglCntntMMainOrgCoCode AND LglCntntMMainOrgPurOrg = _EntityIDValueHelp.LglCntntMMainOrgPurOrg AND LglCntntMMainOrgSalesOrg = _EntityIDValueHelp.LglCntntMMainOrgSalesOrg AND LglCntntMProfile = _EntityIDValueHelp.LglCntntMProfile  -- association [0..1]
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggrgn ON LglCntntMEntity = _LegalTrEntityAggrgn.LglCntntMEntity AND LglCntntMEntityType = _LegalTrEntityAggrgn.LglCntntMEntityType  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON LegalTransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
;