CHMP_PR_CHG_ITM

Transparent Table Application Table
25 Fields 1 CDS Views

Item table for Inventory Price (Price Change)

CHMP_PR_CHG_ITM is an SAP database table in S/4HANA. Item table for Inventory Price (Price Change). It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InventoryPriceChangeItem view_entity from BASIC CHMP Price Change Item

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY batchitemuuid SDRAFT_UUID Draft Document ID
KEY changedoctablekeyuuid CHANGEDOCTABLEKEYUUID Change Document Table Key Universally Unique Identifier
costestimate CK_KALNR Cost EstimateNo
currencyrole FINS_CURTYPE Curr./Val. Type
inventoryvaluationtype BWTAR_D Valuation Type
ledgervalncrcyroleisusedinlogs FML_IS_LOGISTIC_CURTYPE Is Log. Curr. Type
material MATNR Material
materialpricetype FML_PRICE_TYPE Price Type
materialprice FML_INVENTORY_PRICE Inventory Price
statisticalmaterialprice FML_INVENTORY_PRICE Inventory Price
materialpriceunitqty PEINH Price unit
newmaterialprice FML_INVENTORY_PRICE Inventory Price
newstatisticalmaterialprice FML_INVENTORY_PRICE Inventory Price
newmaterialpriceunitqty PEINH Price unit
materialpricecontrol INVENTORYVALUATIONPROCEDURE Price Control
currency WAERS Currency
materialbaseunit VALUM Valuation Unit
ledger FINS_LEDGER Ledger
salesdocument VBELN SD Document
salesdocumentitem POSNR Item
wbselementexternalid PS_POSID_EDIT WBS Element
changerequestnote STRING40 *
companycode BUKRS Company Code
plant WERKS_D Plant

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.

-- Item table for Inventory Price (Price Change)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CHMP_PR_CHG_ITM (
    MANDT,                           -- Client [MANDT]
    BATCHITEMUUID,                   -- Draft Document ID [SDRAFT_UUID]
    CHANGEDOCTABLEKEYUUID,           -- Change Document Table Key Universally Unique Identifier [CHANGEDOCTABLEKEYUUID]
    COSTESTIMATE,                    -- Cost EstimateNo [CK_KALNR]
    CURRENCYROLE,                    -- Curr./Val. Type [FINS_CURTYPE]
    INVENTORYVALUATIONTYPE,          -- Valuation Type [BWTAR_D]
    LEDGERVALNCRCYROLEISUSEDINLOGS,  -- Is Log. Curr. Type [FML_IS_LOGISTIC_CURTYPE]
    MATERIAL,                        -- Material [MATNR]
    MATERIALPRICETYPE,               -- Price Type [FML_PRICE_TYPE]
    MATERIALPRICE,                   -- Inventory Price [FML_INVENTORY_PRICE]
    STATISTICALMATERIALPRICE,        -- Inventory Price [FML_INVENTORY_PRICE]
    MATERIALPRICEUNITQTY,            -- Price unit [PEINH]
    NEWMATERIALPRICE,                -- Inventory Price [FML_INVENTORY_PRICE]
    NEWSTATISTICALMATERIALPRICE,     -- Inventory Price [FML_INVENTORY_PRICE]
    NEWMATERIALPRICEUNITQTY,         -- Price unit [PEINH]
    MATERIALPRICECONTROL,            -- Price Control [INVENTORYVALUATIONPROCEDURE]
    CURRENCY,                        -- Currency [WAERS]
    MATERIALBASEUNIT,                -- Valuation Unit [VALUM]
    LEDGER,                          -- Ledger [FINS_LEDGER]
    SALESDOCUMENT,                   -- SD Document [VBELN]
    SALESDOCUMENTITEM,               -- Item [POSNR]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID_EDIT]
    CHANGEREQUESTNOTE,               -- * [STRING40]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PLANT,                           -- Plant [WERKS_D]
    PRIMARY KEY (MANDT, BATCHITEMUUID, CHANGEDOCTABLEKEYUUID)
);

Learn More