P_MATGROUPSUPPLIERSPENDIDC

CDS View
9 Fields 1 CDS Views

Spend per Supplier MaterialGroup combination in Disp Crcy

P_MATGROUPSUPPLIERSPENDIDC is a CDS View in S/4HANA. Spend per Supplier MaterialGroup combination in Disp Crcy. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MatGrpSuplrSpendIDCRe view from CONSUMPTION Spend per Supplier and Mat. Group restricted by a given date

Fields (9)

KeyField CDS FieldsUsed in Views
KEY MaterialGroup MaterialGroup 1
KEY Supplier Supplier 1
BusinessPartner BusinessPartner 1
FromPostingDate FromPostingDate 1
MaterialGroupDisplayCurrency MaterialGroupDisplayCurrency 1
MatlGrpNetAmountInDisplayCrcy MatlGrpNetAmountInDisplayCrcy 1
PurchaseOrderDate PurchaseOrderDate 1
SupplierDisplayCurrency SupplierDisplayCurrency 1
SupplierNetAmountInDisplayCrcy SupplierNetAmountInDisplayCrcy 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Spend per Supplier MaterialGroup combination in Disp Crcy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATGROUPSUPPLIERSPENDIDC (
    MATERIALGROUP,
    SUPPLIER,
    BUSINESSPARTNER,
    FROMPOSTINGDATE,
    MATERIALGROUPDISPLAYCURRENCY,
    MATLGRPNETAMOUNTINDISPLAYCRCY,
    PURCHASEORDERDATE,
    SUPPLIERDISPLAYCURRENCY,
    SUPPLIERNETAMOUNTINDISPLAYCRCY,
    PRIMARY KEY (MATERIALGROUP, SUPPLIER)
);

Learn More