MLIT SAP (Material Ledger Document: Items) Table details

Dictionary Type: Table
Description: Material Ledger Document: Items




ABAP Code to SELECT data from MLIT
Related tables to MLIT
Access table MLIT




Table field list including key, data, relationships and ABAP select examples

MLIT is a standard SAP Table which is used to store Material Ledger Document: Items data and is available within R/3 SAP systems depending on the version and release level.

The MLIT table consists of various fields, each holding specific information or linking keys about Material Ledger Document: Items data available in SAP. These include BELNR (Number of a Material Ledger Document/Price Change Document), KJAHR (Material Ledger Document/Price Change Document: Storage Year), POSNR (Item in Material Ledger Document), URZEILE (Original item in material or invoice document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MLIT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BELNRNumber of a Material Ledger Document/Price Change Document CK_BELNRCHAR10ALPHABELNRMLNML_BELNR
KJAHRMaterial Ledger Document/Price Change Document: Storage Year CK_KJAHRNUMC4GJAHRGJAHRMLJ
POSNRItem in Material Ledger Document CK_MLPOSNUMC6NUMC6
URZEILEOriginal item in material or invoice document CK_URZEILENUMC6NUMC6
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
BWKEYValuation Area BWKEYCHAR4T001KBWKEYBWK
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
MEINSUnit of Measure for Material Valuation CKML_MEINSUNIT3T006CUNITMEINS
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
BWMODValuation Grouping Code BWMODCHAR4CHAR4
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
KTOPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
MLASTMaterial Price Determination: Control CK_ML_ABSTCHAR1CK_ML_ABST
PSARTItem type in material ledger document CK_PSARTCHAR2CK_VGART
BELNR_EANumber of a Material Ledger Document/Price Change Document CK_BELNRCHAR10ALPHABELNRMLNML_BELNR
KJAHR_EAMaterial Ledger Document/Price Change Document: Storage Year CK_KJAHRNUMC4GJAHRGJAHRMLJ
BELNR_MANumber of a Material Ledger Document/Price Change Document CK_BELNRCHAR10ALPHABELNRMLNML_BELNR
KJAHR_MAMaterial Ledger Document/Price Change Document: Storage Year CK_KJAHRNUMC4GJAHRGJAHRMLJ
ASCHEMAMaterial Update Structure CKML_ASCHEMACHAR4Assigned to domainCKML_ASCHEMA
PTYPOriginal process category CK_PTYP_ORGCHAR4Assigned to domainCKML_PROZESS_TYP
PTYP_KATProcess category for category determination CK_PTYP_KATCHAR4Assigned to domainCKML_PROZESS_TYP
PTYP_BVALTProcess category for procurement alt. or consuption alt. CK_PTYP_BVALTCHAR4Assigned to domainCKML_PROZESS_TYP
PTYP_PROCProcess category of the process CK_PTYP_PROCCHAR4Assigned to domainCKML_PROZESS_TYP
BEWARTGRPMovement Type Group for ML Update CKML_MLBWGCHAR2Assigned to domainCKML_MLBWG
KATEGORIECategory in Material Update Structure CKML_KATEGORIECHAR2CKML_KATEGORIE
BVALTProcurement alternative/process CKML_ALPROCNRNUMC12Assigned to domainCK_KALNR
PROCESSProduction Process CKML_F_PROCNRNUMC12Assigned to domainCK_KALNRCKML_PROCNR
CSPLITApportionment Structure CSPLITCHAR4Assigned to domainCSPLIT
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
VBELPItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
XOBEWVendor Stock Valuation Indicator XOBEWCHAR1XFELD
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
XABRERRIndicates that error(s) occurred during last price determ. CK_XABRERRCHAR1CK_XERROR
BELNR_CONSNumber of a Material Ledger Document/Price Change Document CK_BELNRCHAR10ALPHABELNRMLNML_BELNR
KJAHR_CONSMaterial Ledger Document/Price Change Document: Storage Year CK_KJAHRNUMC4GJAHRGJAHRMLJ
BELNR_WIPNumber of a Material Ledger Document/Price Change Document CK_BELNRCHAR10ALPHABELNRMLNML_BELNR
KJAHR_WIPMaterial Ledger Document/Price Change Document: Storage Year CK_KJAHRNUMC4GJAHRGJAHRMLJ

Key field Non-key field



How do I retrieve data from SAP table MLIT using ABAP code

The following ABAP code Example will allow you to do a basic selection on MLIT to SELECT all data from the table
DATA: WA_MLIT TYPE MLIT.

SELECT SINGLE *
FROM MLIT
INTO CORRESPONDING FIELDS OF WA_MLIT
WHERE...

How to access SAP table MLIT

Within an ECC or HANA version of SAP you can also view further information about MLIT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!