CKMLPP

Transparent Table Application Table
38 Fields 6 CDS Views

Material Ledger Period Totals Records Quantity

CKMLPP is an SAP database table in S/4HANA. Material Ledger Period Totals Records Quantity. It contains 38 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
Ml4h_Cds_pp_Jahrper view from CKMLPP extended by JAHRPER
P_InvPrice_Manage_Max_Fiscal view from BASIC
P_Matval_Manage_Max_Hdpp view inner BASIC
v_ml_bcf_ol_l1_view view inner LOCAL: Material Ledger BCF for other ledgers
v_ml_check2a_view view left_outer Material Ledger check migrated data vs. CKMCLPP
v_ml_total_l1_view view inner LOCAL: Material Ledger Totals

Fields (38)

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
kz_abger XABGER Don't Determine
xkonchk CK_XKONCHK Constncy Check
status CK_MLSTAT Status
meins CKML_MEINS Unit of Measure
saprl SYSAPRL SAP Release
xerror CK_XABRERR Error w/ PrDeterm
cd_ok CKML_CD_OK MLCD OK
xnewccsnextmon MLCCS_D_XNEWCCSNEXTMON Create CCS
xmymp CKML_MYMP Det. Receipt Vals
lbkum CK_LBKUM Total Stock
umkumo CK_UMKUM Qty.PstdToPrPer
abkumo CK_ABKUM Beginning Inv.
zukumo CK_ZUKUM GR Quantity
szkumo CK_SZKUM Qty Received
vpkumo CK_VPKUM Cons: Total Qty
vnkumo CK_VNKUM Consumption Qty
ekkumo CK_EKKUM Quantity frm PO
pbkumo CK_PBKUM Qty Sub. Adjust
pbpopo CK_PBPOPO Qty Sub. Adjust
vppopo CK_VPPOPO Qty Sub. Adjust
umkuma CK_UMKUM_A Amt Pstd Pr.Per
zukuma CK_ZUKUM_A Rec:Qty Settled
ekkuma CK_EKKUM_A Qty Stld - PO
pbkuma CK_PBKUM_A Qty Sub. Adjust
xvnb CKML_XVNB RoC Completed
xwip CKML_XWIP WIP Completed
xobjwip CKML_XOBJWIP WIP Calculated
xnopl CK_NO_PBPOPO No Stock Check
xmstuf CKML_XMSTUF ML Price Det. Compl.
xckmm CKML_XCKMM CKMM Completed
xclean CKML_XCLEAN Period Empty
xavrsim CKML_XAVRSIM AVRSIM Set
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 Quantity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLPP (
    MANDT,           -- Client [MANDT]
    KALNR,           -- Cost EstimateNo [CK_KALNR]
    BDATJ,           -- Year [BDATJ]
    POPER,           -- Posting Period [POPER]
    UNTPER,          -- Value Type [CK_UNTPER]
    KZ_ABGER,        -- Don't Determine [XABGER]
    XKONCHK,         -- Constncy Check [CK_XKONCHK]
    STATUS,          -- Status [CK_MLSTAT]
    MEINS,           -- Unit of Measure [CKML_MEINS]
    SAPRL,           -- SAP Release [SYSAPRL]
    XERROR,          -- Error w/ PrDeterm [CK_XABRERR]
    CD_OK,           -- MLCD OK [CKML_CD_OK]
    XNEWCCSNEXTMON,  -- Create CCS [MLCCS_D_XNEWCCSNEXTMON]
    XMYMP,           -- Det. Receipt Vals [CKML_MYMP]
    LBKUM,           -- Total Stock [CK_LBKUM]
    UMKUMO,          -- Qty.PstdToPrPer [CK_UMKUM]
    ABKUMO,          -- Beginning Inv. [CK_ABKUM]
    ZUKUMO,          -- GR Quantity [CK_ZUKUM]
    SZKUMO,          -- Qty Received [CK_SZKUM]
    VPKUMO,          -- Cons: Total Qty [CK_VPKUM]
    VNKUMO,          -- Consumption Qty [CK_VNKUM]
    EKKUMO,          -- Quantity frm PO [CK_EKKUM]
    PBKUMO,          -- Qty Sub. Adjust [CK_PBKUM]
    PBPOPO,          -- Qty Sub. Adjust [CK_PBPOPO]
    VPPOPO,          -- Qty Sub. Adjust [CK_VPPOPO]
    UMKUMA,          -- Amt Pstd Pr.Per [CK_UMKUM_A]
    ZUKUMA,          -- Rec:Qty Settled [CK_ZUKUM_A]
    EKKUMA,          -- Qty Stld - PO [CK_EKKUM_A]
    PBKUMA,          -- Qty Sub. Adjust [CK_PBKUM_A]
    XVNB,            -- RoC Completed [CKML_XVNB]
    XWIP,            -- WIP Completed [CKML_XWIP]
    XOBJWIP,         -- WIP Calculated [CKML_XOBJWIP]
    XNOPL,           -- No Stock Check [CK_NO_PBPOPO]
    XMSTUF,          -- ML Price Det. Compl. [CKML_XMSTUF]
    XCKMM,           -- CKMM Completed [CKML_XCKMM]
    XCLEAN,          -- Period Empty [CKML_XCLEAN]
    XAVRSIM,         -- AVRSIM Set [CKML_XAVRSIM]
    SDM_VERSION,     -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, KALNR, BDATJ, POPER, UNTPER)
);

Learn More