SAP ABAP Table SAPI_MD_ITEM (Step API: Item Data For Material Document)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TEW (Application Component) Trading Execution Workbench
     ⤷ WB2B_METHODS (Package) Methods Calls for BAPIs in Trading Execution Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	SAPI_MD_ITEM	Table Relationship Diagram
Short Description	Step API: Item Data For Material Document

Delivery and Maintenance

Pool/cluster
Delivery Class
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	DOC_KEY	☐	WB2_DOC_KEY		CHAR	20	0	Document Key
2	ITEM_KEY	☐	WB2_ITEM_KEY		CHAR	16	0	Item Key
3	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
4	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
5	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
6	MKPF	☐	WB2_MKPF		STRU	0	0
7	.INCLUDE	☐				0	0	Header: Material Document
8	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
9	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
10	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
11	VGART	☐	VGART	VGART	CHAR	2	0	Transaction/Event Type
12	BLART	☐	BLART	BLART	CHAR	2	0	Document type
13	BLAUM	☐	BLAUM	BLART	CHAR	2	0	Document type of revaluation document
14	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
17	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
18	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
19	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name
20	TCODE	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
21	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
22	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
23	FRATH	☐	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
24	FRBNR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
25	WEVER	☐	WEVER	WEVER	CHAR	1	0	Version for Printing GR/GI Slip
26	XABLN	☐	XABLN	BELNR	CHAR	10	0	Goods receipt/issue slip number
27	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
28	BLA2D	☐	BLA2D	BLART	CHAR	2	0	Doc. type for additional doc. in purchase account management
29	TCODE2	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
30	BFWMS	☐	BFWMS	BFWMS	CHAR	1	0	Control posting for external WMS
31	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents
32	SPE_BUDAT_UHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
33	SPE_BUDAT_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone
34	LE_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
35	SPE_LOGSYS	☐	/SPE/_LOGSYS_MD	LOGSYS	CHAR	10	0	Logical System of EWM Material Document
36	SPE_MDNUM_EWM	☐	/SPE/MDNUM_EWM	/SPE/MDNUM_EWM	CHAR	16	0	Number of Material Document in EWM
37	GTS_CUSREF_NO	☐	/SAPSLL/SCREF_SPI	CHAR35	CHAR	35	0	Customs Reference Number for Scrapping
38	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
39	MSR_ACTIVE	☐	MSR_ACTIVE	MSR_ACTIVE	CHAR	1	0	Advanced Returns Management Active
40	.INCLU--AP	☐				0	0	JV Fields for MKPF
41	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
42	.INCLU-_GT	☐				0	0	Material Document Header: Dynamic Part
43	SCENARIO_GT	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
44	FILTERED_OUT_GT	☐	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
45	EXTERNAL_NO_GT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
46	GUID_GT	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
47	T001_WAERS_GT	☐	WAERS	WAERS	CUKY	5	0	Currency Key
48	MSEG	☐	WB2_MSEG		STRU	0	0
49	.INCLUDE	☐				0	0	Document Segment: Material
50	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
51	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
52	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
53	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
54	.INCLUDE	☐				0	0	Docmt Structure
55	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
56	PARENT_ID	☐	MB_PARENT_ID	MB_LINE_ID	NUMC	6	0	Identifier of immediately superior line
57	LINE_DEPTH	☐	MB_LINE_DEPTH	MB_LINE_DEPTH	NUMC	2	0	Hierarchy level of line in document
58	MAA_URZEI	☐	MAA_URZEI	MBLPO	NUMC	4	0	Original Line for Account Assignment Item in Material Doc.
59	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)
60	XAUTO	☐	MB_XAUTO	MB_XAUTO	CHAR	1	0	Item automatically created
61	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
62	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
63	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
64	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
65	INSMK	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
66	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
67	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
68	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator
69	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
70	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer
71	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number
72	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
73	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
74	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
75	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
76	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
77	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
78	BNBTR	☐	BNBTR	WERT13N	CURR	13	2	Delivery costs in local currency
79	BUALT	☐	BUALT	WERTV7	CURR	13	2	Amount posted in alternative price control
80	SHKUM	☐	SHKUM	SHKZG	CHAR	1	0	Debit/credit indicator in revaluation
81	DMBUM	☐	DMBUM	WERT7	CURR	13	2	Revaluation amount on back-posting to a previous period
82	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
83	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
84	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
85	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
86	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry
87	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
88	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)
89	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number
90	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
91	LFBJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
92	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
93	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
94	SJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
95	SMBLN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
96	SMBLP	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
97	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
98	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
99	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number
100	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
101	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
102	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
103	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area
104	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area
105	PARBU	☐	PARBU	BUKRS	CHAR	4	0	Clearing company code
106	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
107	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
108	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
109	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number
110	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber
111	XSKST	☐	XSKST	XFELD	CHAR	1	0	Indicator: Statistical Posting to Cost Center
112	XSAUF	☐	XSAUF	XFELD	CHAR	1	0	Indicator: Posting to Order Is Statistical
113	XSPRO	☐	XSPRO	XFELD	CHAR	1	0	Indicator: Posting to Project Is Statistical
114	XSERG	☐	XSERG	XFELD	CHAR	1	0	Indicator: Posting to Profitability Analysis Is Statistical
115	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
116	XRUEM	☐	XRUEM	XFELD	CHAR	1	0	Allow Posting to Previous Period (Backposting)
117	XRUEJ	☐	XRUEJ	XFELD	CHAR	1	0	Indicator: post to previous year
118	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
119	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
120	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
121	BELUM	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
122	BUZUM	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
123	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
124	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
125	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
126	PBAMG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
127	KZSTR	☐	KZSTR	KZSTR	CHAR	1	0	Transaction/event is relevant to statistics
128	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material
129	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant
130	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location
131	UMCHA	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch
132	UMZST	☐	UMZST	ZUSTD	CHAR	1	0	Status of receiving batch
133	UMZUS	☐	UMZUS	ZUSCH	CHAR	1	0	Status key of transfer batch
134	UMBAR	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch
135	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer
136	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
137	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
138	KZZUG	☐	KZZUG	KZZUG	CHAR	1	0	Receipt indicator
139	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
140	PALAN	☐	PALAN	PALAN	DEC	11	0	WMS Number of pallets
141	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex
142	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type
143	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin
144	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
145	BWLVS	☐	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management
146	TBNUM	☐	TBNUM	TBNUM	NUMC	10	0	Transfer Requirement Number
147	TBPOS	☐	TBPOS	TBPOS	NUMC	4	0	Transfer Requirement Item
148	XBLVS	☐	XBLVS	XFELD	CHAR	1	0	Indicator: posting in warehouse management system
149	VSCHN	☐	T333_VSCHN	XFELD	CHAR	1	0	Ind: interim storage posting for source stor.type and bin
150	NSCHN	☐	T333_NSCHN	XFELD	CHAR	1	0	Ind.: interim storage posting for dest.stor.type and bin
151	DYPLA	☐	DYPLA	XFELD	CHAR	1	0	Indicator: dynamic storage bin
152	UBNUM	☐	UBNUM	UBNUM	NUMC	10	0	Posting Change Number
153	TBPRI	☐	TBPRI	TBPRI	CHAR	1	0	Transfer Priority
154	TANUM	☐	TANUM	TANUM	NUMC	10	0	Transfer Order Number
155	WEANZ	☐	WEANZ	NUM3	NUMC	3	0	Number of GR/GI slips to be printed
156	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement
157	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions
158	EVERE	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions
159	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
160	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object
161	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
162	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
163	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
164	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment
165	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
166	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
167	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
168	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number
169	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item
170	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
171	BSTMG	☐	MB_BSTMG	MENG13	QUAN	13	3	Goods receipt quantity in order unit
172	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit
173	XWSBR	☐	XWSBR	XFELD	CHAR	1	0	Reversal of GR allowed for GR-based IV despite invoice
174	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery
175	.INCLUDE	☐				0	0
176	EXBWR	☐	EXBWR	WERT7	CURR	13	2	Externally Entered Posting Amount in Local Currency
177	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
178	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion
179	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
180	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
181	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
182	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
183	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
184	RSART	☐	RSART	RSART	CHAR	1	0	Record type
185	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
186	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
187	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed
188	UMMAB	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material
189	BUSTM	☐	BUSTM	BUSTM	CHAR	4	0	Posting string for quantities
190	BUSTW	☐	BUSTW	BUSTW	CHAR	4	0	Posting string for values
191	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
192	WERTU	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
193	LBKUM	☐	LBKUM_MSEG	MENGV13	QUAN	13	3	Total valuated stock before the posting
194	SALK3	☐	SALK3_MSEG	WERT13N	CURR	13	2	Value of total valuated stock before the posting
195	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
196	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
197	DABRBZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
198	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
199	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
200	XBEAU	☐	XBEAU	XFELD	CHAR	1	0	Purchase order created at time of goods receipt
201	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
202	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note
203	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
204	QINSPST	☐	QINSPST	QINSPST	CHAR	1	0	Status of Goods Receipt Inspection
205	URZEI	☐	URZEI	MBLPO	NUMC	4	0	Original line in material document
206	J_1BEXBASE	☐	J_1BEXBASE	WERT7	CURR	13	2	Alternate base amount in document currency
207	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
208	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
209	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number
210	J_1AGIRUPD	☐	J_1AGIRUPD	J_1AGIRUPD	CHAR	1	0	Goods issue revaluation performed
211	VKMWS	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
212	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
213	BERKZ	☐	BERKZ	LVS_BERKZ	CHAR	1	0	Material Staging Indicator for Production Supply
214	MAT_KDAUF	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock
215	MAT_KDPOS	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
216	MAT_PSPNR	☐	MAT_PSPNR	PS_POSNR	NUMC	8	0	Valuated customer stock WBS element
217	XWOFF	☐	XWOFF	XFELD	CHAR	1	0	Calculation of val. open
218	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator
219	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process
220	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor
221	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
222	XOBEW	☐	XOBEW	XFELD	CHAR	1	0	Vendor Stock Valuation Indicator
223	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
224	ZUSTD_T156M	☐	BAMOK_MSEG	BAMOK_MSEG	CHAR	1	0	Stock Type Modification (Read from Table T156M)
225	SPE_GTS_STOCK_TY	☐	/SPE/GTS_STOCK_TYPE	/SPE/GTS_STOCK_TYPE	CHAR	1	0	GTS Stock Type
226	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds
227	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
228	XMACC	☐	XMACC	CHAR1	CHAR	1	0	Multiple Account Assignment
229	VGART_MKPF	☐	VGART	VGART	CHAR	2	0	Transaction/Event Type
230	BUDAT_MKPF	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
231	CPUDT_MKPF	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
232	CPUTM_MKPF	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
233	USNAM_MKPF	☐	USNAM	XUBNAME	CHAR	12	0	User name
234	XBLNR_MKPF	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
235	TCODE2_MKPF	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
236	VBELN_IM	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
237	VBELP_IM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item
238	.INCLU--AP	☐				0	0	Fields for Excise Duties in Material Document (MSEG)
239	/BEV2/ED_KZ_VER	☐	/BEV2/EDKZ_VER	/BEV2/EDKZ_VER	CHAR	1	0	Processing Status of Material Document for Excise Duties
240	/BEV2/ED_USER	☐	USNAM	XUBNAME	CHAR	12	0	User name
241	/BEV2/ED_AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
242	/BEV2/ED_AETIM	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
243	.INCLU--AP	☐				0	0	Joint Venture Fields
244	OINAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
245	OICONDCOD	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)
246	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)
247	.INCLU-_GT	☐				0	0	Material Document Segment: Dynamic Part
248	SCENARIO_GT	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
249	FILTERED_OUT_GT	☐	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
250	NOT_REF_QUAN_GT	☐	WB2_NOT_REF_QUAN	MENG15	QUAN	15	3	Open Quantity
251	NOT_REF_QUAN_UNIT_GT	☐	WB2_NOT_REF_QUAN_UNIT	MEINS	UNIT	3	0	Open Quantity Unit
252	EXTERNAL_NO_GT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
253	BSEG_MEINS_GT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
254	.INCLUDE	☐				0	0	Dynamic Part of Data for Subsequent Action
255	ASSOC_QUAN_B	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
256	UNIT_OF_QUAN_B	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
257	ASSOC_QUAN_S	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
258	UNIT_OF_QUAN_S	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
259	ASSOC_QUAN_P	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
260	UNIT_OF_QUAN_P	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
261	PORTFOLIO	☐	WB2_PORTFOLIO	KNUMB	CHAR	10	0	Global Trade: (Internal) Portfolio Number
262	.INCLUDE	☐				0	0	BAPI Communication Structure: Create Material Document Item
263	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
264	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
265	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
266	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
267	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
268	STCK_TYPE	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
269	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
270	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
271	CUSTOMER	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
272	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
273	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
274	SCHED_LINE	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
275	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
276	ENTRY_QNT	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
277	ENTRY_UOM	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
278	ENTRY_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
279	PO_PR_QNT	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
280	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
281	ORDERPR_UN_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
282	PO_NUMBER	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
283	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
284	SHIPPING	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
285	COMP_SHIP	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
286	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
287	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
288	GR_RCPT	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
289	UNLOAD_PT	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
290	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
291	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
292	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
293	CALC_MOTIVE	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
294	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
295	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
296	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
297	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
298	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
299	WITHDRAWN	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
300	MOVE_MAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
301	MOVE_PLANT	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
302	MOVE_STLOC	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
303	MOVE_BATCH	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	MCHA
304	MOVE_VAL_TYPE	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch	T149D
305	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
306	MOVE_REAS	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
307	RL_EST_KEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
308	REF_DATE	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
309	COST_OBJ	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
310	PROFIT_SEGM_NO	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
311	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
312	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
313	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
314	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
315	PART_ACCT	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
316	AMOUNT_LC	☐	BAPI_EXBWR	BAPICURR	DEC	23	4	Externally entered posting amount in local currency (BAPI)
317	AMOUNT_SV	☐	BAPI_EXVKW	BAPICURR	DEC	23	4	Externally entered sales value in local currency (for Bapi)
318	REF_DOC_YR	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
319	REF_DOC	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
320	REF_DOC_IT	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
321	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
322	PROD_DATE	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
323	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
324	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
325	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
326	VAL_SALES_ORD	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	VBUK
327	VAL_S_ORD_ITEM	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
328	VAL_WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
329	GL_ACCOUNT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
330	IND_PROPOSE_QUANX	☐	XMEVO	XFELD	CHAR	1	0	Propose quantities
331	XSTOB	☐	XSTOB	XFELD	CHAR	1	0	Use Reversal Movement Type Indicator
332	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
333	DELIV_NUMB_TO_SEARCH	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
334	DELIV_ITEM_TO_SEARCH	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
335	SERIALNO_AUTO_NUMBERASSIGNMENT	☐	XSAUT	XFELD	CHAR	1	0	Serial number to be created automatically via method
336	VENDRBATCH	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
337	STGE_TYPE	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
338	STGE_BIN	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
339	SU_PL_STCK_1	☐	LVS_ANZLE	LVS_ANZLE	DEC	3	0	Number of Storage Units to be Placed Into Storage
340	ST_UN_QTYY_1	☐	LVS_LEMEN	MENG13	QUAN	13	3	Quantity per Storage Unit to be Placed into Stock in Alt.UoM
341	ST_UN_QTYY_1_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
342	UNITTYPE_1	☐	LVS_LETYP	LVS_LETYP	CHAR	3	0	Storage Unit Type	T307
343	SU_PL_STCK_2	☐	LVS_ANZLE	LVS_ANZLE	DEC	3	0	Number of Storage Units to be Placed Into Storage
344	ST_UN_QTYY_2	☐	LVS_LEMEN	MENG13	QUAN	13	3	Quantity per Storage Unit to be Placed into Stock in Alt.UoM
345	ST_UN_QTYY_2_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
346	UNITTYPE_2	☐	LVS_LETYP	LVS_LETYP	CHAR	3	0	Storage Unit Type	T307
347	STGE_TYPE_PC	☐	UBTYP	LGTYP	CHAR	3	0	Storage type for transfer posting	T301
348	STGE_BIN_PC	☐	UBPLA	LGPLA	CHAR	10	0	Storage bin for transfer posting	LAGP
349	NO_PST_CHGNT	☐	LVS_KZKUB	XFELD	CHAR	1	0	Indicator: Do not create posting change notice
350	GR_NUMBER	☐	LVS_WENUM	BELNR	CHAR	10	0	Goods Receipt Number
351	STGE_TYPE_ST	☐	UMLGT	LGTYP	CHAR	3	0	Storage type for stock transfer	T301
352	STGE_BIN_ST	☐	UMLGP	LGPLA	CHAR	10	0	Storage bin for stock transfer	LAGP
353	MATDOC_TR_CANCEL	☐	LVS_TBBEL	BELNR	CHAR	10	0	Material doc. no. of transfer requirement to be cancelled
354	MATITEM_TR_CANCEL	☐	LVS_TBBPO	MBLPO	NUMC	4	0	Material doc. item of transf.reqmnt item to be cancelled
355	MATYEAR_TR_CANCEL	☐	LVS_TBBJR	GJAHR	NUMC	4	0	Material doc. year of transfer requirement to be cancelled
356	NO_TRANSFER_REQ	☐	LVS_TBFKZ	XFELD	CHAR	1	0	Indicator: No Transfer Requirement Created
357	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
358	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
359	SUPPL_VEND	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
360	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
361	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
362	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
363	MOVE_MAT_EXTERNAL	☐	MGV_MOVE_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MOVE_MAT Field
364	MOVE_MAT_GUID	☐	MGV_MOVE_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MOVE_MAT Field
365	MOVE_MAT_VERSION	☐	MGV_MOVE_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MOVE_MAT Field
366	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
367	TR_PART_BA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
368	PAR_COMPCO	☐	PARBU	BUKRS	CHAR	4	0	Clearing company code	*
369	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
370	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
371	NB_SLIPS	☐	WEANZ	NUM3	NUMC	3	0	Number of GR/GI slips to be printed
372	NB_SLIPSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
373	GR_RCPTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
374	UNLOAD_PTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
375	SPEC_MVMT	☐	LVS_BSSKZ	LVS_BSSKZ	CHAR	1	0	Special movement indicator for warehouse management	*
376	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
377	CMMT_ITEM_LONG	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
378	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
379	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
380	PARENT_ID	☐	MB_PARENT_ID	MB_LINE_ID	NUMC	6	0	Identifier of immediately superior line
381	LINE_DEPTH	☐	MB_LINE_DEPTH	MB_LINE_DEPTH	NUMC	2	0	Hierarchy level of line in document
382	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
383	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
384	LONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number
385	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
386	EARMARKED_NUMBER	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
387	EARMARKED_ITEM	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SAPI_MD_ITEM	ASSET_NO	ANLH	ANLN1
2	SAPI_MD_ITEM	BATCH	MCHA	CHARG
3	SAPI_MD_ITEM	CALC_MOTIVE	TBMOT	BEMOT
4	SAPI_MD_ITEM	CMMT_ITEM	FMFPO	FIPOS
5	SAPI_MD_ITEM	COMP_SHIP	T027C	EVERE
6	SAPI_MD_ITEM	COSTCENTER	CSKS	KOSTL
7	SAPI_MD_ITEM	COST_OBJ	CKPH	KSTRG
8	SAPI_MD_ITEM	CUSTOMER	KNA1	KUNNR
9	SAPI_MD_ITEM	DELIV_ITEM_TO_SEARCH	VBUP	POSNR
10	SAPI_MD_ITEM	DELIV_NUMB_TO_SEARCH	VBUK	VBELN
11	SAPI_MD_ITEM	ENTRY_UOM	T006	MSEHI
12	SAPI_MD_ITEM	ENTRY_UOM_ISO	T006I	ISOCODE
13	SAPI_MD_ITEM	FUND	FMFINCODE	FINCODE
14	SAPI_MD_ITEM	FUNDS_CTR	FMFCTR	FICTR
15	SAPI_MD_ITEM	GL_ACCOUNT	SKA1	SAKNR
16	SAPI_MD_ITEM	MATERIAL	MARA	MATNR
17	SAPI_MD_ITEM	MOVE_BATCH	MCHA	CHARG
18	SAPI_MD_ITEM	MOVE_MAT	MARA	MATNR
19	SAPI_MD_ITEM	MOVE_PLANT	T001W	WERKS
20	SAPI_MD_ITEM	MOVE_REAS	T157D	GRUND
21	SAPI_MD_ITEM	MOVE_STLOC	T001L	LGORT
22	SAPI_MD_ITEM	MOVE_TYPE	T156	BWART
23	SAPI_MD_ITEM	MOVE_VAL_TYPE	T149D	BWTAR
24	SAPI_MD_ITEM	NETWORK	AUFK	AUFNR
25	SAPI_MD_ITEM	ORDERID	AUFK	AUFNR
26	SAPI_MD_ITEM	ORDERPR_UN	T006	MSEHI
27	SAPI_MD_ITEM	ORDERPR_UN_ISO	T006I	ISOCODE
28	SAPI_MD_ITEM	PART_ACCT	KNA1	KUNNR
29	SAPI_MD_ITEM	PLANT	T001W	WERKS
30	SAPI_MD_ITEM	PO_ITEM	EKPO	EBELP
31	SAPI_MD_ITEM	PO_NUMBER	EKKO	EBELN
32	SAPI_MD_ITEM	PROFIT_CTR	CEPC	PRCTR
33	SAPI_MD_ITEM	RESERV_NO	RESB	RSNUM
34	SAPI_MD_ITEM	SALES_ORD	VBUK	VBELN
35	SAPI_MD_ITEM	SHIPPING	T027A	EVERS
36	SAPI_MD_ITEM	SPEC_STOCK	T148	SOBKZ
37	SAPI_MD_ITEM	STGE_BIN	LAGP	LGPLA
38	SAPI_MD_ITEM	STGE_BIN_PC	LAGP	LGPLA
39	SAPI_MD_ITEM	STGE_BIN_ST	LAGP	LGPLA
40	SAPI_MD_ITEM	STGE_LOC	T001L	LGORT
41	SAPI_MD_ITEM	STGE_TYPE	T301	LGTYP
42	SAPI_MD_ITEM	STGE_TYPE_PC	T301	LGTYP
43	SAPI_MD_ITEM	STGE_TYPE_ST	T301	LGTYP
44	SAPI_MD_ITEM	ST_UN_QTYY_1_ISO	T006I	ISOCODE
45	SAPI_MD_ITEM	ST_UN_QTYY_2_ISO	T006I	ISOCODE
46	SAPI_MD_ITEM	SUB_NUMBER	ANLA	ANLN2
47	SAPI_MD_ITEM	UNITTYPE_1	T307	LETYP
48	SAPI_MD_ITEM	UNITTYPE_2	T307	LETYP
49	SAPI_MD_ITEM	VAL_SALES_ORD	VBUK	VBELN
50	SAPI_MD_ITEM	VAL_TYPE	T149D	BWTAR
51	SAPI_MD_ITEM	VENDOR	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C