CKMLCR

Transparent Table Application Table
57 Fields 20 CDS Views

Material Ledger: Period Totals Records Values

CKMLCR is an SAP database table in S/4HANA. Material Ledger: Period Totals Records Values. It contains 57 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
fmlv_ckmlcr_compat view union_all Compatibility View for CKMLCR
FMLV_CKMLCR_UNION view from CKMLCR Union FMLT_PRICE
FMLV_EBEWH_CKMLCR_SALKV view from CompatView for SALKV in EBEWH
FMLV_MBEWH_CKMLCR_SALKV view from CompatView for SALKV in MBEWH
FMLV_OBEWH_CKMLCR_SALKV view from CompatView for SALKV in OBEWH
FMLV_QBEWH_CKMLCR_SALKV view from CompatView for SALKV in QBEWH
FMLV_XBEW_CKMLCR_SALKV view from CompatView for XBEW Redirect Tables
I_MLInventoryPriceRawData view from BASIC select relevant data from CKMLCR
I_ProdValnMatlLdgrCurPerdWD view from TRANSACTIONAL Product BO Valuation Material Ledger Current Period (Draft)
P_CURMATLVALNPRICE_CR view from BASIC
P_InvPriceManageDataFromCR view from BASIC
P_MATVAL_MANAGE_CKML view left_outer BASIC
P_Matval_Manage_Val_Chart view left_outer BASIC
P_Ml_Prices_Ckml view left_outer BASIC
P_ML_Prices_Hdcr view from BASIC
P_MLPricePersistedPeriod view from BASIC
V_MaterialLedgerPriceBasic1 view inner Basic view 1 for material price
v_ml_bcf_ol_l1_view view inner LOCAL: Material Ledger BCF for other ledgers
v_ml_check1a_view view left_outer Material Ledger check migrated data vs. CKMCLCR
v_ml_total_l1_view view inner LOCAL: Material Ledger Totals

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CK_KALNR Cost EstimateNo
KEY bdatj BDATJ Year
KEY poper POPER Posting Period
KEY untper CK_UNTPER Value Type
KEY curtp FINS_CURTYPE Curr./Val. Type
peinh CK_PEINH_1 Price Unit
vprsv VPRSV Price control
stprs CK_STPRS_1 Standard Price
pvprs CK_PVPRS_1 Per. Unit Price
waers WAERS Currency
salk3 CK_SALK3_1 Inventory Value
salkv CK_SALKV_1 Val./Per.Unit Prc
zuumb_o CK_ZUUMB_1 Reval. Amount
abprd_o CK_ABPRD BI:1-Lvl PrcDif
abkdm_o CK_ABKDM BI:1-Lvl ExRtDi
zuprd_o CK_ZUABW_1 Rc:1-Lvl Pr.Dif
zukdm_o CK_ZUKDM Rec:1-Lvl ExRtD
vpprd_o CK_VPPRD Cons:1-Lvl PrD
vpkdm_o CK_VPKDM C:1-Lvl ExRtDif
vppbprd_o CK_VPPBPRD PrDiff Sub.Adj.
vppbkdm_o CK_VPPBKDM SubAdj.ExRtDiff
vnprd_o CK_VNPRD C:1-Lvl Pr.Diff
vnkdm_o CK_VNKDM Cons.1-lvl ERD
ekprd_o CK_EKPRD Pr.Diff.from PO
ekkdm_o CK_EKKDM ExchRateDiff-PO
pbprd_o CK_PBPRD PrDiff Sub.Adj.
pbkdm_o CK_PBKDM SubAdj.ExRtDiff
vnprd_ea CK_VNPRDEA C:1-Lvl Pr.Diff
vnkdm_ea CK_VNKDMEA Cons.1-Lvl ERD
ebprd_ea CK_EBPRDEA EI:1-Lvl Pr.Dif
ebkdm_ea CK_EBKDMEA EI:1-Lvl ERDiff
zuumb_a CK_ZUUMB_A Reval. Amount NA
zuprd_a CK_ZUABW_A Rec: 1Lvl PrD NA
zukdm_a CK_ZUKDM_A R:1-Lvl ERD (NA)
ekprd_a CK_EKPRD_A PrDiff Stld- PO
ekkdm_a CK_EKKDM_A PO ExchRateDiff
pbprd_a CK_PBPRD_A PrDiff - Sub.Ad
pbkdm_a CK_PBKDM_A SubAdj ExRtDif
abprd_mo CK_ABPRDMO BI:Multilvl PrD
abkdm_mo CK_ABKDMMO BI:Multilvl ERD
zuprd_mo CK_ZUPRDMO Rcpt:M-LvlPrDif
zukdm_mo CK_ZUKDMMO Rec:M-Lvl ExRtD
vnprd_ma CK_VNPRDMA C:M-Lvl Pr.Diff
vnkdm_ma CK_VNKDMMA C:M-Lvl Adj.ERD
ebprd_ma CK_EBPRDMA EI:M-Lvl Pr.Dif
ebkdm_ma CK_EBKDMMA EI:M-Lvl ExRtDf
absalk3 CKML_ABSALK3 Begin.Inv.Value
zukdm_ost CK_ZUKDM_OST Nrel ERD Receipts
ekkdm_ost CK_EKKDM_OST N. Rel. ERDs Orders
pbkdm_ost CK_PBKDM_OST N. Rel. ERD Adjust.
vpkdm_ost CK_VPKDM_OST N Rel ERDs
vppbkdm_ost CK_VPPBKDM_OST N Rel ERD Sub Adjust
vnkdm_ost CK_VNKDM_OST N. Rel. ERD
markup_o CKML_MARKUP Interco. Profit
vksal CK_VKSAL Total SP value
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: Period Totals Records Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLCR (
    MANDT,        -- Client [MANDT]
    KALNR,        -- Cost EstimateNo [CK_KALNR]
    BDATJ,        -- Year [BDATJ]
    POPER,        -- Posting Period [POPER]
    UNTPER,       -- Value Type [CK_UNTPER]
    CURTP,        -- Curr./Val. Type [FINS_CURTYPE]
    PEINH,        -- Price Unit [CK_PEINH_1]
    VPRSV,        -- Price control [VPRSV]
    STPRS,        -- Standard Price [CK_STPRS_1]
    PVPRS,        -- Per. Unit Price [CK_PVPRS_1]
    WAERS,        -- Currency [WAERS]
    SALK3,        -- Inventory Value [CK_SALK3_1]
    SALKV,        -- Val./Per.Unit Prc [CK_SALKV_1]
    ZUUMB_O,      -- Reval. Amount [CK_ZUUMB_1]
    ABPRD_O,      -- BI:1-Lvl PrcDif [CK_ABPRD]
    ABKDM_O,      -- BI:1-Lvl ExRtDi [CK_ABKDM]
    ZUPRD_O,      -- Rc:1-Lvl Pr.Dif [CK_ZUABW_1]
    ZUKDM_O,      -- Rec:1-Lvl ExRtD [CK_ZUKDM]
    VPPRD_O,      -- Cons:1-Lvl PrD [CK_VPPRD]
    VPKDM_O,      -- C:1-Lvl ExRtDif [CK_VPKDM]
    VPPBPRD_O,    -- PrDiff Sub.Adj. [CK_VPPBPRD]
    VPPBKDM_O,    -- SubAdj.ExRtDiff [CK_VPPBKDM]
    VNPRD_O,      -- C:1-Lvl Pr.Diff [CK_VNPRD]
    VNKDM_O,      -- Cons.1-lvl ERD [CK_VNKDM]
    EKPRD_O,      -- Pr.Diff.from PO [CK_EKPRD]
    EKKDM_O,      -- ExchRateDiff-PO [CK_EKKDM]
    PBPRD_O,      -- PrDiff Sub.Adj. [CK_PBPRD]
    PBKDM_O,      -- SubAdj.ExRtDiff [CK_PBKDM]
    VNPRD_EA,     -- C:1-Lvl Pr.Diff [CK_VNPRDEA]
    VNKDM_EA,     -- Cons.1-Lvl ERD [CK_VNKDMEA]
    EBPRD_EA,     -- EI:1-Lvl Pr.Dif [CK_EBPRDEA]
    EBKDM_EA,     -- EI:1-Lvl ERDiff [CK_EBKDMEA]
    ZUUMB_A,      -- Reval. Amount NA [CK_ZUUMB_A]
    ZUPRD_A,      -- Rec: 1Lvl PrD NA [CK_ZUABW_A]
    ZUKDM_A,      -- R:1-Lvl ERD (NA) [CK_ZUKDM_A]
    EKPRD_A,      -- PrDiff Stld- PO [CK_EKPRD_A]
    EKKDM_A,      -- PO ExchRateDiff [CK_EKKDM_A]
    PBPRD_A,      -- PrDiff - Sub.Ad [CK_PBPRD_A]
    PBKDM_A,      -- SubAdj ExRtDif [CK_PBKDM_A]
    ABPRD_MO,     -- BI:Multilvl PrD [CK_ABPRDMO]
    ABKDM_MO,     -- BI:Multilvl ERD [CK_ABKDMMO]
    ZUPRD_MO,     -- Rcpt:M-LvlPrDif [CK_ZUPRDMO]
    ZUKDM_MO,     -- Rec:M-Lvl ExRtD [CK_ZUKDMMO]
    VNPRD_MA,     -- C:M-Lvl Pr.Diff [CK_VNPRDMA]
    VNKDM_MA,     -- C:M-Lvl Adj.ERD [CK_VNKDMMA]
    EBPRD_MA,     -- EI:M-Lvl Pr.Dif [CK_EBPRDMA]
    EBKDM_MA,     -- EI:M-Lvl ExRtDf [CK_EBKDMMA]
    ABSALK3,      -- Begin.Inv.Value [CKML_ABSALK3]
    ZUKDM_OST,    -- Nrel ERD Receipts [CK_ZUKDM_OST]
    EKKDM_OST,    -- N. Rel. ERDs Orders [CK_EKKDM_OST]
    PBKDM_OST,    -- N. Rel. ERD Adjust. [CK_PBKDM_OST]
    VPKDM_OST,    -- N Rel ERDs [CK_VPKDM_OST]
    VPPBKDM_OST,  -- N Rel ERD Sub Adjust [CK_VPPBKDM_OST]
    VNKDM_OST,    -- N. Rel. ERD [CK_VNKDM_OST]
    MARKUP_O,     -- Interco. Profit [CKML_MARKUP]
    VKSAL,        -- Total SP value [CK_VKSAL]
    SDM_VERSION,  -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, KALNR, BDATJ, POPER, UNTPER, CURTP)
);

Learn More