1. Home
  2. Resources
  3. SAP Tables
  4. MLPP - Material Ledger Document: Posting Periods and Quantities

SAP Table MLPP

Material Ledger Document: Posting Periods and Quantities

MLPP (Material Ledger Document: Posting Periods and Quantities) 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 MLPP to other SAP tables.

MLPP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
POSNR Item in Material Ledger Document CK_MLPOS NUMC 6 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
PERART Type of period CK_PER_ART CHAR 2 0
AJ Older Than Previous Year
VJ Previous Year
BO Previous Year = Previous Period
ZM Intermediate Month
VM Previous Month
LF Current Month
NM Future Month
LBKUM Quantity by which the total valuated inventory has changed CK_LBKUMD QUAN 15 3
LBKUM_OLD Total valuated stock CK_LBKUM QUAN 15 3
UNTPER Value Structure Type CK_UNTPER NUMC 3 0
BKLAS Valuation Class BKLAS T025 CHAR 4 0
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
MODIF Type of BOM item CK_MODIF CHAR 1 0
NULL Actual quantity
F Minimum from target and actual quantity
Z Quantity is not considered
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

MLPP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MLPP BKLAS MLPP MANDT T025 Valuation Classes MANDT
MLPP BKLAS MLPP BKLAS T025 Valuation Classes BKLAS
MLPP MANDT MLPP MANDT T000 Clients MANDT