SAP table MLIT (Material Ledger Document: Items)

SAP table MLIT has 4 primary key fields being MANDT,BELNR,KJAHR,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
POSNR Item in Material Ledger Document NUMC 6 0 CK_MLPOS
URZEILE Original Item in Material or Invoice Document NUMC 6 0 CK_URZEILE
MATNR Material Number CHAR 40 0 MARA MATNR
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BWKEY Valuation area CHAR 4 0 T001K BWKEY
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CK_KALNR
MEINS Unit of Measure for Material Valuation UNIT 3 0 T006 CKML_MEINS
SPART Division CHAR 2 0 TSPA SPART
GSBER Business Area CHAR 4 0 GSBER
BWMOD Valuation Grouping Code CHAR 4 0 BWMOD
BUKRS Company Code CHAR 4 0 T001 BUKRS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
MLAST Material Price Determination: Control CHAR 1 0 CK_ML_ABST
2 Transaction-Based
3 Single-/Multilevel
PSART Item Type in Material Ledger Document CHAR 2 0 CK_PSART
BELNR_EA Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_EA Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
BELNR_MA Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_MA Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
ASCHEMA Material Update Structure CHAR 4 0 CKML_ASCHEMA
PTYP Original Process Category CHAR 4 0 CK_PTYP_ORG
PTYP_KAT Process Category for Category Determination CHAR 4 0 CK_PTYP_KAT
PTYP_BVALT Process Category for Procurement Alt. or Consuption Alt. CHAR 4 0 CK_PTYP_BVALT
PTYP_PROC Process Category of the Process CHAR 4 0 CK_PTYP_PROC
BEWARTGRP Movement Type Group for ML Update CHAR 2 0 CKML_MLBWG
KATEGORIE Category in Material Update Structure CHAR 2 0 CKML_KATEGORIE
VN Consumption
VP Other Receipts/Consumption
ZU Receipts
BVALT Procurement Alternative/Process NUMC 12 0 CKML_ALPROCNR
PROCESS Production Process NUMC 12 0 CKML_F_PROCNR
CSPLIT Apportionment Structure CHAR 4 0 CSPLIT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
VBELP Item number of the SD document NUMC 6 0 POSNR
PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
XOBEW Vendor Stock Valuation Indicator CHAR 1 0 XOBEW
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
XABRERR Indicates that Error(s) Occurred During Last Price Determ. CHAR 1 0 CK_XABRERR
BELNR_CONS Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_CONS Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
BELNR_WIP Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_WIP Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
PRCTR Profit Center CHAR 10 0 PRCTR

MLIT foreign key relationships

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