CHMP_PR_CHG_ITM

Transparent Table Application Table
26 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 26 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 (26)

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
batchuuid crmt_targetgrp_guid Target Grp GUID

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]
    BATCHUUID,                       -- Target Grp GUID [crmt_targetgrp_guid]
    PRIMARY KEY (MANDT, BATCHITEMUUID, CHANGEDOCTABLEKEYUUID)
);

Learn More