MLIT SAP (Material Ledger Document: Items) Table details
Description: Material Ledger Document: Items
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Number of a Material Ledger Document/Price Change Document | CK_BELNR | CHAR | 10 | ALPHA | BELNR | MLN | ML_BELNR | |
KJAHR | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4 | GJAHR | GJAHR | MLJ | ||
POSNR | Item in Material Ledger Document | CK_MLPOS | NUMC | 6 | NUMC6 | ||||
URZEILE | Original item in material or invoice document | CK_URZEILE | NUMC | 6 | NUMC6 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | T001K | BWKEY | BWK | ||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
MEINS | Unit of Measure for Material Valuation | CKML_MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
BWMOD | Valuation Grouping Code | BWMOD | CHAR | 4 | CHAR4 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | T004 | KTOPL | KPL | C_KTOPL | |
MLAST | Material Price Determination: Control | CK_ML_ABST | CHAR | 1 | CK_ML_ABST | ||||
PSART | Item type in material ledger document | CK_PSART | CHAR | 2 | CK_VGART | ||||
BELNR_EA | Number of a Material Ledger Document/Price Change Document | CK_BELNR | CHAR | 10 | ALPHA | BELNR | MLN | ML_BELNR | |
KJAHR_EA | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4 | GJAHR | GJAHR | MLJ | ||
BELNR_MA | Number of a Material Ledger Document/Price Change Document | CK_BELNR | CHAR | 10 | ALPHA | BELNR | MLN | ML_BELNR | |
KJAHR_MA | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4 | GJAHR | GJAHR | MLJ | ||
ASCHEMA | Material Update Structure | CKML_ASCHEMA | CHAR | 4 | Assigned to domain | CKML_ASCHEMA | |||
PTYP | Original process category | CK_PTYP_ORG | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
PTYP_KAT | Process category for category determination | CK_PTYP_KAT | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
PTYP_BVALT | Process category for procurement alt. or consuption alt. | CK_PTYP_BVALT | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
PTYP_PROC | Process category of the process | CK_PTYP_PROC | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
BEWARTGRP | Movement Type Group for ML Update | CKML_MLBWG | CHAR | 2 | Assigned to domain | CKML_MLBWG | |||
KATEGORIE | Category in Material Update Structure | CKML_KATEGORIE | CHAR | 2 | CKML_KATEGORIE | ||||
BVALT | Procurement alternative/process | CKML_ALPROCNR | NUMC | 12 | Assigned to domain | CK_KALNR | |||
PROCESS | Production Process | CKML_F_PROCNR | NUMC | 12 | Assigned to domain | CK_KALNR | CKML_PROCNR | ||
CSPLIT | Apportionment Structure | CSPLIT | CHAR | 4 | Assigned to domain | CSPLIT | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBELP | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
XOBEW | Vendor Stock Valuation Indicator | XOBEW | CHAR | 1 | XFELD | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
XABRERR | Indicates that error(s) occurred during last price determ. | CK_XABRERR | CHAR | 1 | CK_XERROR | ||||
BELNR_CONS | Number of a Material Ledger Document/Price Change Document | CK_BELNR | CHAR | 10 | ALPHA | BELNR | MLN | ML_BELNR | |
KJAHR_CONS | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4 | GJAHR | GJAHR | MLJ | ||
BELNR_WIP | Number of a Material Ledger Document/Price Change Document | CK_BELNR | CHAR | 10 | ALPHA | BELNR | MLN | ML_BELNR | |
KJAHR_WIP | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4 | GJAHR | GJAHR | MLJ |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects