P_SUPPLIERMATERIALGROUPSPEND2

CDS View
10 Fields 1 CDS Views

Supplier and Material Group Spends with Display Currencies

P_SUPPLIERMATERIALGROUPSPEND2 is a CDS View in S/4HANA. Supplier and Material Group Spends with Display Currencies. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MatGroupSupplierSpendIDC view from CONSUMPTION Spend per Supplier MaterialGroup combination in Disp Crcy

Fields (10)

KeyField CDS FieldsUsed in Views
KEY MaterialGroup MaterialGroup 1
KEY Supplier Supplier 1
BusinessPartner BusinessPartner 1
FromPostingDate FromPostingDate 1
IsReturnsItem IsReturnsItem 1
ItemIsStatistical ItemIsStatistical 1
OriginalCurrency OriginalCurrency 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderNetAmount PurchaseOrderNetAmount 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 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.

-- Supplier and Material Group Spends with Display Currencies
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SUPPLIERMATERIALGROUPSPEND2 (
    MATERIALGROUP,
    SUPPLIER,
    BUSINESSPARTNER,
    FROMPOSTINGDATE,
    ISRETURNSITEM,
    ITEMISSTATISTICAL,
    ORIGINALCURRENCY,
    PURCHASEORDERDATE,
    PURCHASEORDERNETAMOUNT,
    PURCHASINGDOCUMENTDELETIONCODE,
    PRIMARY KEY (MATERIALGROUP, SUPPLIER)
);

Learn More