SAP ABAP Table MLIT (Material Ledger Document: Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CKML (Package) Material ledger

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MLIT	Table Relationship Diagram
Short Description	Material Ledger Document: Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BELNR	☑	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
3	KJAHR	☑	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
4	POSNR	☑	CK_MLPOS	NUMC6	NUMC	6	0	Item in Material Ledger Document
5	URZEILE	☐	CK_URZEILE	NUMC6	NUMC	6	0	Original item in material or invoice document
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
8	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
9	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
10	MEINS	☐	CKML_MEINS	MEINS	UNIT	3	0	Unit of Measure for Material Valuation	T006
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
12	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
13	BWMOD	☐	BWMOD	CHAR4	CHAR	4	0	Valuation grouping code
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
16	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
17	PSART	☐	CK_PSART	CK_VGART	CHAR	2	0	Item type in material ledger document
18	BELNR_EA	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
19	KJAHR_EA	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
20	BELNR_MA	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
21	KJAHR_MA	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
22	ASCHEMA	☐	CKML_ASCHEMA	CKML_ASCHEMA	CHAR	4	0	Material Update Structure	*
23	PTYP	☐	CK_PTYP_ORG	CKML_PROZESS_TYP	CHAR	4	0	Original process category	*
24	PTYP_KAT	☐	CK_PTYP_KAT	CKML_PROZESS_TYP	CHAR	4	0	Process category for category determination	*
25	PTYP_BVALT	☐	CK_PTYP_BVALT	CKML_PROZESS_TYP	CHAR	4	0	Process category for procurement alt. or consuption alt.	*
26	PTYP_PROC	☐	CK_PTYP_PROC	CKML_PROZESS_TYP	CHAR	4	0	Process category of the process	*
27	BEWARTGRP	☐	CKML_MLBWG	CKML_MLBWG	CHAR	2	0	Movement Type Group for ML Update	*
28	KATEGORIE	☐	CKML_KATEGORIE	CKML_KATEGORIE	CHAR	2	0	Category in Material Update Structure
29	BVALT	☐	CKML_ALPROCNR	CK_KALNR	NUMC	12	0	Procurement alternative/process	*
30	PROCESS	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process	*
31	CSPLIT	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	*
32	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
33	VBELP	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
34	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
35	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
36	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
37	XOBEW	☐	XOBEW	XFELD	CHAR	1	0	Vendor Stock Valuation Indicator
38	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
39	XABRERR	☐	CK_XABRERR	CK_XERROR	CHAR	1	0	Indicates that error(s) occurred during last price determ.
40	BELNR_CONS	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
41	KJAHR_CONS	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
42	BELNR_WIP	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
43	KJAHR_WIP	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MLIT	BUKRS	T001	BUKRS	REF	1	CN
2	MLIT	BWKEY	T001K	BWKEY	REF	1	CN
3	MLIT	BWTAR	T149D	BWTAR	REF	C	CN
4	MLIT	KTOPL	T004	KTOPL	REF	1	CN
5	MLIT	MANDT	T000	MANDT	KEY	1	CN
6	MLIT	MATNR	MARA	MATNR	REF	1	CN
7	MLIT	MEINS	T006	MSEHI	REF	C	CN
8	MLIT	SPART	TSPA	SPART	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in