C_PurgCatMatlGroup

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_PurgCatMatlGroup.
-- 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: CPURCATMATLGROUP
-- Parameters: P_KeyDate : sydate

CREATE VIEW C_PurgCatMatlGroup AS
SELECT
  MaterialGroup,
  PurCatMaterialGroupUUID,
  PurgCatUUID,
  cast(_MaterialGroupText[1: Language = $session.system_language].MaterialGroupText as /srmsmc/description_medium) AS MaterialGroupText,
  _MaterialGroupText[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  I_PurchasingCategoryMatlGroup._MaterialGroup.MaterialAuthorizationGroup AS MaterialAuthorizationGroup,
  cast(_AssignedMaterialsCount.AssignedMaterialsCount as /srmsmc/assgd_matls_count preserving type ) AS AssignedMaterialsCount,
  cast( 0 as /srmsmc/spend_per_group_long ) AS MatlGrpTotalNetAmountInDspCrcy,
  _DisplayCurrencyMaterialGroup.MaterialGroupDisplayCurrency AS MaterialGroupDisplayCurrency,
  coalesce( _MatGrpAnnualSpend( P_KeyDate : $parameters.P_KeyDate ).MatlGrpTotalNetAmountInDspCrcy, 0) AS PurgCatTotalSpendInDspCrcy
FROM I_PurchasingCategoryMatlGroup
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN C_MaterialGroupLongText AS _MaterialGroupLongText ON MaterialGroup = _MaterialGroupLongText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN P_MatGrpAnnualSpend AS _MatGrpAnnualSpend ON PurgCatUUID = _MatGrpAnnualSpend.PurgCatUUID AND MaterialGroup = _MatGrpAnnualSpend.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN P_AssignedMaterialsCount AS _AssignedMaterialsCount ON MaterialGroup = _AssignedMaterialsCount.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN P_DisplayCurrencyMaterialGroup AS _DisplayCurrencyMaterialGroup ON MaterialGroup = _DisplayCurrencyMaterialGroup.MaterialGroup  -- association [0..1]
;