PRICECHANGE

18 Fields

PRICECHANGE is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ChangeDocument ChangeDocument 1
KEY PurchaseContract PurchaseContract 1
KEY PurchaseContractItem PurchaseContractItem 1
CompanyCode CompanyCode 1
CreationDate CreationDate 1
DocumentCurrency Currency 1
Material Material 1
MaterialGroup MaterialGroup 1
Plant Plant 1
ProductCollection ProductCollection 1
ProductSeason ProductSeason 1
ProductSeasonYear ProductSeasonYear 1
ProductTheme ProductTheme 1
PurchaseContractItemUniqueID PurchaseContractItemUniqueID 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
StockSegment StockSegment 1
Supplier Supplier 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRICECHANGE (
    CHANGEDOCUMENT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    COMPANYCODE,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PRODUCTCOLLECTION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PURCHASECONTRACTITEMUNIQUEID,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    STOCKSEGMENT,
    SUPPLIER,
    PRIMARY KEY (CHANGEDOCUMENT, PURCHASECONTRACT, PURCHASECONTRACTITEM)
);

Learn More