1. Home
  2. Resources
  3. SAP Tables
  4. MLIT - Material Ledger Document: Items

SAP Table MLIT

Material Ledger Document: Items

MLIT (Material Ledger Document: Items) 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 MLIT to other SAP tables.

MLIT 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
URZEILE Original item in material or invoice document CK_URZEILE NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
MEINS Unit of Measure for Material Valuation CKML_MEINS T006 UNIT 3 0
SPART Division SPART TSPA CHAR 2 0
GSBER Business Area GSBER CHAR 4 0
BWMOD Valuation Grouping Code BWMOD CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
PSART Item type in material ledger document CK_PSART CHAR 2 0
CL Material Ledger Settlement
UP Material Ledger Update
PC Price Change
DC Debit/Credit Material
ST Single-Level Price Determination
MS Multilevel Price Determination
MI Input Material (Multilevel Price Determination)
MO Output Material (Multilevel Price Determination)
MB Beginning Inventory (Multilevel Price Determination)
MC Input Material: Currency Types Of Outputs (Multilvl Pr.Det.)
RE Material Ledger Repair
AT ML Update - Activity Consumption
AC Input-Activity Type/ABC Process (Multilevel Pr. Determ.)
CC Alternatice Valuation Run Closing
RC Revaluation of Consumption
RO Revaluation of Consumption to Original Account Assignment
RS Revaluation of Consumption to Collective Account Assignment
MA Manual Change of Actual Cost Component Splits
OC New Valuation Logical Inventory (Only IS-Oil)
WC WIP: Input Material: Currency Type Output
WI WIP: Input Material (Multilevel Price Determination)
WL WIP: Input Activity Type/ABC Process (Multilevel)
WP WIP Revaluation
WQ WIP Quantity Document (WIP Determination)
W1 Material (Total WIP Revaluation)
W2 Material (Process WIP Revaluation)
W3 Activity Type (Total WIP Revaluation)
W4 Activity Type (Process WIP Revaluation)
AL Activity Type/ABC Process Closing
MY Delta Posting Balance Sheet Valuation
BELNR_EA Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_EA Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
BELNR_MA Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_MA Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
ASCHEMA Material Update Structure CKML_ASCHEMA CHAR 4 0
PTYP Original process category CK_PTYP_ORG CHAR 4 0
PTYP_KAT Process category for category determination CK_PTYP_KAT CHAR 4 0
PTYP_BVALT Process category for procurement alt. or consuption alt. CK_PTYP_BVALT CHAR 4 0
PTYP_PROC Process category of the process CK_PTYP_PROC CHAR 4 0
BEWARTGRP Movement Type Group for ML Update CKML_MLBWG CHAR 2 0
KATEGORIE Category in Material Update Structure CKML_KATEGORIE CHAR 2 0
ZU Receipts
VP Other Receipts/Consumption
VN Consumption
BVALT Procurement alternative/process CKML_ALPROCNR NUMC 12 0
PROCESS Production Process CKML_F_PROCNR NUMC 12 0
CSPLIT Apportionment Structure CSPLIT CHAR 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VBELP Item number of the SD document POSNR NUMC 6 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
XABRERR 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
BELNR_CONS Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_CONS Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
BELNR_WIP Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_WIP Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0

MLIT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MLIT BUKRS MLIT MANDT T001 Company Codes MANDT
MLIT BUKRS MLIT BUKRS T001 Company Codes BUKRS
MLIT BWKEY MLIT BWKEY T001K Valuation area BWKEY
MLIT BWKEY MLIT MANDT T001K Valuation area MANDT
MLIT BWTAR MLIT MANDT T149D Global Valuation Types MANDT
MLIT BWTAR MLIT BWTAR T149D Global Valuation Types BWTAR
MLIT KTOPL MLIT MANDT T004 Directory of Charts of Accounts MANDT
MLIT KTOPL MLIT KTOPL T004 Directory of Charts of Accounts KTOPL
MLIT MANDT MLIT MANDT T000 Clients MANDT
MLIT MATNR MLIT MANDT MARA General Material Data MANDT
MLIT MATNR MLIT MATNR MARA General Material Data MATNR
MLIT MEINS MLIT MANDT T006 Units of Measurement MANDT
MLIT MEINS MLIT MEINS T006 Units of Measurement MSEHI
MLIT SPART MLIT MANDT TSPA Organizational Unit: Sales Divisions MANDT
MLIT SPART MLIT SPART TSPA Organizational Unit: Sales Divisions SPART