P_MatGroupSupplierSpendIDC

DDL: P_MATGROUPSUPPLIERSPENDIDC SQL: PMGRPSUPLRSPNDID Type: view CONSUMPTION
12 Fields 1 Data Sources 2 Associations

Spend per Supplier MaterialGroup combination in Disp Crcy

P_MatGroupSupplierSpendIDC is a Consumption CDS View that provides data about "Spend per Supplier MaterialGroup combination in Disp Crcy" in SAP S/4HANA. It reads from 1 data source (P_SupplierMaterialGroupSpend2) and exposes 12 fields with key fields MaterialGroup, Supplier. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SupplierMaterialGroupSpend2 P_SupplierMaterialGroupSpend2 from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_DisplayCurrencyMaterialGroup _DisplayCurrencyMaterialGroup $projection.MaterialGroup = _DisplayCurrencyMaterialGroup.MaterialGroup
[0..1] P_DisplayCurrencySupplier _DisplayCurrencySupplier $projection.BusinessPartner = _DisplayCurrencySupplier.BusinessPartner

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PMGRPSUPLRSPNDID view
EndUserText.label Spend per Supplier MaterialGroup combination in Disp Crcy view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroup P_SupplierMaterialGroupSpend2 MaterialGroup Product Group
KEY Supplier P_SupplierMaterialGroupSpend2 Supplier Supplier
BusinessPartner P_SupplierMaterialGroupSpend2 BusinessPartner Issuing Authority
PurchaseOrderNetAmount P_SupplierMaterialGroupSpend2 PurchaseOrderNetAmount Net Value
MaterialGroupDisplayCurrency _DisplayCurrencyMaterialGroup MaterialGroupDisplayCurrency
FromPostingDate P_SupplierMaterialGroupSpend2 FromPostingDate
PurchaseOrderDate P_SupplierMaterialGroupSpend2 PurchaseOrderDate PO Date
SupplierDisplayCurrency _DisplayCurrencySupplier SupplierDisplayCurrency
PurchasingDocumentDeletionCode P_SupplierMaterialGroupSpend2 PurchasingDocumentDeletionCode Del. Indicator
ItemIsStatistical P_SupplierMaterialGroupSpend2 ItemIsStatistical
IsReturnsItem P_SupplierMaterialGroupSpend2 IsReturnsItem Returns Item
OriginalCurrency P_SupplierMaterialGroupSpend2 OriginalCurrency

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 P_MatGroupSupplierSpendIDC.
-- 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: PMGRPSUPLRSPNDID
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_MatGroupSupplierSpendIDC AS
SELECT
  P_SupplierMaterialGroupSpend2.MaterialGroup AS MaterialGroup,
  P_SupplierMaterialGroupSpend2.Supplier AS Supplier,
  P_SupplierMaterialGroupSpend2.BusinessPartner AS BusinessPartner,
  P_SupplierMaterialGroupSpend2.PurchaseOrderNetAmount AS PurchaseOrderNetAmount,
  _DisplayCurrencyMaterialGroup.MaterialGroupDisplayCurrency AS MaterialGroupDisplayCurrency,
  P_SupplierMaterialGroupSpend2.FromPostingDate AS FromPostingDate,
  P_SupplierMaterialGroupSpend2.PurchaseOrderDate AS PurchaseOrderDate,
  _DisplayCurrencySupplier.SupplierDisplayCurrency AS SupplierDisplayCurrency,
  P_SupplierMaterialGroupSpend2.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  P_SupplierMaterialGroupSpend2.ItemIsStatistical AS ItemIsStatistical,
  P_SupplierMaterialGroupSpend2.IsReturnsItem AS IsReturnsItem,
  P_SupplierMaterialGroupSpend2.OriginalCurrency AS OriginalCurrency
FROM P_SupplierMaterialGroupSpend2
LEFT OUTER JOIN P_DisplayCurrencyMaterialGroup AS _DisplayCurrencyMaterialGroup ON MaterialGroup = _DisplayCurrencyMaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN P_DisplayCurrencySupplier AS _DisplayCurrencySupplier ON BusinessPartner = _DisplayCurrencySupplier.BusinessPartner  -- association [0..1]
;

Learn More