1. Home
  2. Resources
  3. SAP Tables
  4. CKMLPP - Material Ledger Period Totals Records Quantity

SAP Table CKMLPP

Material Ledger Period Totals Records Quantity

CKMLPP (Material Ledger Period Totals Records Quantity) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMLPP to other SAP tables.

CKMLPP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
UNTPER Value Structure Type CK_UNTPER NUMC 3 0
KZ_ABGER Material price will no longer be determined in this period XABGER CHAR 1 0
X Closed
NULL Not Closed
XKONCHK Switch off consistency check CK_XKONCHK CHAR 1 0
NULL Always Check
1 Never Check
5 Invoices and Goods Movements Possible
STATUS Material ledger period status CK_MLSTAT NUMC 2 0
00 Undefined
01 New Objects
10 Period Opened
20 Price Change Completed
30 Quantities and Values Entered
31 Values Entered
40 Price Determined (Single-Level)
50 Price Determined (Multilevel)
60 Closing Entry Reversed
70 Closing Entry Completed
05 Period Without Stock Opened
MEINS Unit of Measure for Material Valuation CKML_MEINS UNIT 3 0
SAPRL Release of SAP System SYSAPRL CHAR 4 0
XERROR Indicates that error(s) occurred during last price determ. CK_XABRERR CHAR 1 0
NULL No error
B Valuation inconsistent
I Error in RW interface
K Account not found
M Material not found
N Price will be negative
P Price change not allowed: too high
S Material is blocked
Z Other error
CD_OK Summarization Record MLCD Created Correctly CKML_CD_OK CHAR 1 0
XNEWCCSNEXTMON Regenerate Cost Component Split for Next Period MLCCS_D_XNEWCCSNEXTMON CHAR 1 0
X TRUE
NULL FALSE
XMYMP Determine Receipt Values Status CKML_MYMP CHAR 1 0
X Yes
NULL No
LBKUM Total valuated stock CK_LBKUM QUAN 15 3
UMKUMO Quantity posted to previous period CK_UMKUM QUAN 15 3
ABKUMO Beginning Inventory: Quantity at Start of Period CK_ABKUM QUAN 15 3
ZUKUMO Total quantity of goods received in period CK_ZUKUM QUAN 15 3
SZKUMO Other receipts: quantity (from-value from VPKUMO) CK_SZKUM QUAN 15 3
VPKUMO Other Receipts/Issues: Quantity CK_VPKUM QUAN 15 3
VNKUMO Issues not affecting the price: quantity CK_VNKUM QUAN 15 3
EKKUMO Receipts: Quantity from Purchase Orders (From-Value) CK_EKKUM QUAN 15 3
PBKUMO Receipts: Quantity from Subsequent Adjustments (from value) CK_PBKUM QUAN 15 3
PBPOPO Receipts: Quantity from Sub.Adjustments in period CK_PBPOPO QUAN 15 3
VPPOPO Inputs: Quantity from Subsequent Adjustments (from Value) CK_VPPOPO QUAN 15 3
UMKUMA Amount in the period - posted to a prior period - settled CK_UMKUM_A QUAN 15 3
ZUKUMA Quantity of Goods Recieved in the Period (settled) CK_ZUKUM_A QUAN 15 3
EKKUMA Receipts: Quantity Settled from Purchase Orders (From-Value) CK_EKKUM_A QUAN 15 3
PBKUMA Receipts: Amount settled from subseq. adjustments (frm val.) CK_PBKUM_A QUAN 15 3
XVNB Revaluation of Consumption Completed CKML_XVNB CHAR 1 0
X Yes/ Successful
NULL No / Not Successful
E Error
XWIP WIP Price Determination Completed CKML_XWIP CHAR 1 0
X Yes/ Successful
NULL No / Not Successful
E Error
XOBJWIP WIP Calculated in Cost Object Controlling CKML_XOBJWIP CHAR 1 0
X Yes/ Successful
NULL No / Not Successful
E Error
XNOPL Price Determination Without Stock Coverage Check CK_NO_PBPOPO CHAR 1 0
X Yes
NULL No
XCKMM ML- Price Determination Control was Changed: (CKMM) CKML_XCKMM CHAR 1 0
X Yes
NULL No
XCLEAN ALL ML-Relevant Postings for the Period Were Reversed CKML_XCLEAN CHAR 1 0
X Yes
NULL No

CKMLPP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLPP MANDT CKMLPP MANDT T000 Clients MANDT