CKMLPR

Transparent Table Application Table
35 Fields 9 CDS Views

Material Ledger: Prices

CKMLPR is an SAP database table in S/4HANA. Material Ledger: Prices. It contains 35 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
FMLV_CKMLPR_COMPAT_DB view union_all Compatibility View for CKMLPR
I_ProdValnMatlLdgrFutrPrcWD view from TRANSACTIONAL Product BO Valuation Material Ledger Future Prices (Draft)
P_CURMATLVALNPRICE_PR view from BASIC
P_CURRENTMATLVALNPRICE view left_outer BASIC
P_MaterialLedgerPriceCmptblty view from BASIC
P_MATVAL_MANAGE_CKML view from BASIC
P_Matval_Manage_Cost view from BASIC
P_Ml_Prices_Ckml view from BASIC
R_MatlPriceSpclStockValnStrgy view from COMPOSITE Mat Price Spec Stock Valuation Strategy

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CK_KALNR Cost EstimateNo
KEY curtp FINS_CURTYPE Curr./Val. Type
peinh PEINH Price unit
zprsdat CK_ZPRSDAT Fut. Price From
zkprs DZKPRS Future Price
kalkz KAXKZ Fut. cost est.
pprdz CK_PPRDZ Posting Period
pdatz CK_PDATZ Fut. FYyear
bwva1 CK_BWVA1 Valuation Var.
vers1 CK_TVERS1 Costing Version
zplpr DZPLPR Fut. Plnd Price
fplpx CK_ZPLPX Fut. PlanPrice, Fxd
zbwst CK_ZBWST Fut. Valn Strat.
kalkl KALKL CurrentCostEst.
pprdl CK_PPRDL Current Period
pdatl CK_PDATL Curr. Fiscal Yr
bwva2 CK_BWVA2 Valuatn Variant
vers2 CK_TVERS2 Costing Version
lplpr CK_LPLPR Curr.Plnd Price
lplpx CK_LPLPX Fix. Cur. Plnd Prc.
lbwst CK_LBWST Curr. Valn Strat.
kalkv KALKV PreviousCostEst
pprdv CK_PPRDV Previous Period
pdatv CK_PDATV Prev. Fiscal Yr
bwva3 CK_BWVA3 Valuation Var.
vers3 CK_TVERS3 Costing Version
vplpr VPLPR Prev. Plnd Prc.
vplpx CK_VPLPX Fixed Prev. PlndPrc.
cbwst CK_VBWST Prev. Valn Strat.
set_by_marking CK_SET_BY_MARKG Flagged
eibdatj CK_EIBDATJ Year End.Inven. Price
eipoper CK_EIPOPER Period End.Inventory Pr.
eiprice CK_EIPRICE Price for Ending Inv
sdm_version FINS_ML_SDM_VERSION SDM Versioning

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.

-- Material Ledger: Prices
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLPR (
    MANDT,           -- Client [MANDT]
    KALNR,           -- Cost EstimateNo [CK_KALNR]
    CURTP,           -- Curr./Val. Type [FINS_CURTYPE]
    PEINH,           -- Price unit [PEINH]
    ZPRSDAT,         -- Fut. Price From [CK_ZPRSDAT]
    ZKPRS,           -- Future Price [DZKPRS]
    KALKZ,           -- Fut. cost est. [KAXKZ]
    PPRDZ,           -- Posting Period [CK_PPRDZ]
    PDATZ,           -- Fut. FYyear [CK_PDATZ]
    BWVA1,           -- Valuation Var. [CK_BWVA1]
    VERS1,           -- Costing Version [CK_TVERS1]
    ZPLPR,           -- Fut. Plnd Price [DZPLPR]
    FPLPX,           -- Fut. PlanPrice, Fxd [CK_ZPLPX]
    ZBWST,           -- Fut. Valn Strat. [CK_ZBWST]
    KALKL,           -- CurrentCostEst. [KALKL]
    PPRDL,           -- Current Period [CK_PPRDL]
    PDATL,           -- Curr. Fiscal Yr [CK_PDATL]
    BWVA2,           -- Valuatn Variant [CK_BWVA2]
    VERS2,           -- Costing Version [CK_TVERS2]
    LPLPR,           -- Curr.Plnd Price [CK_LPLPR]
    LPLPX,           -- Fix. Cur. Plnd Prc. [CK_LPLPX]
    LBWST,           -- Curr. Valn Strat. [CK_LBWST]
    KALKV,           -- PreviousCostEst [KALKV]
    PPRDV,           -- Previous Period [CK_PPRDV]
    PDATV,           -- Prev. Fiscal Yr [CK_PDATV]
    BWVA3,           -- Valuation Var. [CK_BWVA3]
    VERS3,           -- Costing Version [CK_TVERS3]
    VPLPR,           -- Prev. Plnd Prc. [VPLPR]
    VPLPX,           -- Fixed Prev. PlndPrc. [CK_VPLPX]
    CBWST,           -- Prev. Valn Strat. [CK_VBWST]
    SET_BY_MARKING,  -- Flagged [CK_SET_BY_MARKG]
    EIBDATJ,         -- Year End.Inven. Price [CK_EIBDATJ]
    EIPOPER,         -- Period End.Inventory Pr. [CK_EIPOPER]
    EIPRICE,         -- Price for Ending Inv [CK_EIPRICE]
    SDM_VERSION,     -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, KALNR, CURTP)
);

Learn More