SAP ABAP Table ADPIC_S_GOITEM (ADCI MPN: MIGO GOITEM + BADI's internal counter)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD-MPN (Application Component) Manufacturer Part Number
     ⤷ ADPIC (Package) A&D Parts Interchangeability Enhancements

Basic Data

Table Category	INTTAB	Structure
Structure	ADPIC_S_GOITEM	Table Relationship Diagram
Short Description	ADCI MPN: MIGO GOITEM + BADI's internal counter

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	INT_COUNTER	☐	MIGO_GLOBAL_COUNTER	NUMC6	NUMC	6	0	Unique number for one line
2	ACTIVITY	☐	M_STATUS	M_STATUS	CHAR	1	0	Maintenance status (Insert/Update/Delete)
3	.INCLUDE	☐				0	0	MMIM Enjoy: Item Data
4	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
5	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
6	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
7	UZEIL	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
8	DEPTH	☐	MIGO_LINE_LEVEL	NUMC2	NUMC	2	0	Hierarchy level of line
9	PARENT	☐	MIGO_PARENT_GLC	NUMC6	NUMC	6	0	Link to superordinate line
10	EXPAND	☐	MIGO_EXPANDER	CHAR4	CHAR	4	0	Expand/collapse item
11	INVISIBLE	☐	MIGO_LINE_INVISIBLE	XFELD	CHAR	1	0	Line is invisible
12	TAKE_IT	☐	MB_TAKE_IT	XFELD	CHAR	1	0	Item is Adopted in Document
13	XPOITEM	☐	MIGO_POITEM	XFELD	CHAR	1	0	Purchase order exists for this item
14	XORDITEM	☐	MIGO_ORDITEM	XFELD	CHAR	1	0	Order exists for this item (for GR items only)
15	XDELIVITEM	☐	MIGO_DELIVITEM	XFELD	CHAR	1	0	Delivery exists for this item
16	XLBTYPE	☐	MIGO_LBITEM	XFELD	CHAR	1	0	Subcontracting item (PO item or component)
17	XCO_ORDER	☐	MB_SC_CO_ORDER	XFELD	CHAR	1	0	Subcontracting with Reference to Production Order in CO
18	XVGTYPE	☐	XVGTYPE	XUPTYPE	CHAR	1	0	Main item or sub-item for full product
19	XGATYPE	☐	XGATYPE	XUPTYPE	CHAR	1	0	Main or Subitem in Case of Generic Article
20	XCDTYPE	☐	XCDTYPE	XUPTYPE	CHAR	1	0	Main or Subitem in Case of Cross-Docking & Flow-Through
21	XVASTYPE	☐	XVASTYPE	XUPTYPE	CHAR	1	0	Main or Subitem Value Added Services
22	XSTTYPE	☐	XSTTYPE		CHAR	2	0	Main and Subitem in Case of Structured Article
23	XBOMTYPE	☐	MIGO_BOMITEM	XFELD	CHAR	1	0	BOM item (main item or component)
24	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
25	.INCLUDE	☐				0	0	MMIM Enjoy: Fields From Table T156 Movement Types
26	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
27	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
28	KZWES	☐	KZWES	KZWES	CHAR	1	0	GR blocked stock
29	CHNEU	☐	CHNEU	CHNEU	CHAR	1	0	Control: create batch (automatically/manually)
30	KZZDE	☐	KZZDE	XFELD	CHAR	1	0	Maintain status data of a batch
31	KZGRU	☐	KZGRU	FAUSW	CHAR	1	0	Control: Reason for movement
32	KZMHD	☐	KZMHD	KZMHD	CHAR	1	0	Check shelf life expiration date/production date
33	KZCLA	☐	KZCLA	KZCLA	CHAR	1	0	Option to classify batches
34	XKCFC	☐	XKCFC	XFELD	CHAR	1	0	Extended classification via CFC
35	XNEBE	☐	XNEBE	XFELD	CHAR	1	0	Create purchase order automatically
36	J_1BNFREL	☐	J_1BNFREL	J_1BIMNFREL	CHAR	1	0	Nota Fiscal Relevance
37	KZDRU	☐	KZDRU	KZDRU	CHAR	1	0	Printing of document item	*
38	KZBWA	☐	KZBWA	CHAR2	CHAR	2	0	Movement type category
39	KZKON	☐	KZKON	FAUSW	CHAR	1	0	Display or suppress account field/manual account assignment
40	XOARC	☐	XOARC	XFELD	CHAR	1	0	Storage upon goods movements active
41	RULES	☐	BF_RULES	BF_RULES	CHAR	4	0	Stock determination rule	*
42	XSTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
43	BUSTR	☐	BUSTR	BUSTR	CHAR	3	0	Posting string reference (Inventory Management)
44	.INCLUDE	☐				0	0	MMIM Enjoy: Fields From Tables T001W, T159L, T001K, T001
45	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
46	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
47	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
48	CHAZV	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
49	XEINK	☐	XEINK	XFELD	CHAR	1	0	Indicator: Purchase Account Processing is Active
50	XBKNG	☐	XBKNG	XFELD	CHAR	1	0	Negative stocks in valuation area allowed
51	XVKBW	☐	XVKBW	XFELD	CHAR	1	0	Sales price valuation active
52	BUKRS_FOR_STOCK	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
53	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
54	KZXAB	☐	KZXAB	XFELD	CHAR	1	0	GR/GI slip number is active
55	XWMHD	☐	XWMHD	XFELD	CHAR	1	0	Check Best Before Date/Production Date
56	XCAUT	☐	XCAUT	XFELD	CHAR	1	0	Automatic btch no. assignment permitted for GR w. acct assgt
57	IMPDA	☐	IMPDATEN	IMPDATEN	CHAR	1	0	Foreign Trade: Import Data Control in MM Purchase Orders
58	KOPIM	☐	KOPIM	KOPIM	CHAR	1	0	Foreign trade: Import data copying control for GR
59	DKWEG	☐	DKWEG	DKWEG	CHAR	1	0	Foreign Trade: Screen ctrl of imp.data f. MM-goods rececipt
60	KZGEB	☐	QKZGEB	QKZGEB	CHAR	1	0	Recording of the No. of Containers for Inspection Lot
61	BRAZIL	☐			CHAR	1	0
62	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
63	CAPID	☐	CAPID	CAPID	CHAR	4	0	Application	*
64	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
65	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
66	.INCLUDE	☐				0	0	MMIM Enjoy: Fields From Table T001L Storage Locaton
67	LGOBE	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
68	XLONG	☐	XLONG	XFELD	CHAR	1	0	Negative stocks allowed in storage location
69	XHUPF	☐	XHUPF	XFELD	CHAR	1	0	Indicator: handling unit requirement
70	.INCLUDE	☐				0	0	MMIM Enjoy: Vendor Data Common to goitem and gohead (Filter)
71	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
72	VENDORNAME	☐	MIGO_VENDORNAME	NAME	CHAR	35	0	Name of Vendor
73	VENDORZIP	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
74	VENDORADD	☐	AD_CITY1	TEXT40	CHAR	40	0	City
75	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
76	RECVENDNAME	☐	MIGO_RECVENDNAME	NAME	CHAR	35	0	Name of receiving vendor
77	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
78	SUPVENDNAME	☐	MIGO_SUPVENDNAME	NAME	CHAR	35	0	Name of supplying vendor
79	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
80	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
81	POUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
82	TELPOUSER	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
83	POUSERNAME	☐	MIGO_POUSERNAME	SO_STRI035	CHAR	35	0	PO entered by
84	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
85	BUYER	☐	MIGO_BUYER	SO_STRI035	CHAR	35	0	Purchasing group
86	TELNR1	☐	XUTELNR	XUTELNR	CHAR	16	0	Telephone number (work)
87	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
88	RESWKNAME	☐	MIGO_RESWKNAME	TEXT30	CHAR	30	0	Supplying plant in stock transport order
89	.INCLUDE	☐				0	0	MMIM: Input Structure for FM to Post Goods Mvmt: Data
90	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
91	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
92	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
93	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
94	INSMK	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
95	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
96	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
97	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
98	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
99	ERFMG	☐	MB_ERFMG	MENG13	QUAN	13	3	Quantity in Unit of Entry
100	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
101	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
102	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
103	BPMNG	☐	BPMNG_INPUT	MENG13	QUAN	13	3	Quantity in Purchase Order Price Unit
104	BPRME	☐	MB_BPRME	MEINS	UNIT	3	0	Quantity in Purchase Order Price Unit	T006
105	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
106	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
107	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
108	MIGO_ELIKZ	☐	MIGO_ELIKZ	MIGO_ELIKZ	NUMC	1	0	"Delivery Completed" Indicator
109	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
110	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
111	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
112	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
113	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
114	RSART	☐	RSART	RSART	CHAR	1	0	Record type
115	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
116	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
117	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
118	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
119	UMCHA	☐	MIGO_UMCHA	CHARG	CHAR	10	0	Batch Trfr Pstg	MCHA
120	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
121	ERFMG_ABD	☐	ERFMG_ABD	FLTP	FLTP	16	16	Quantity in Unit of Entry for Amount-Based Distribution
122	BPMNG_ABD	☐	BPMNG_ABD	FLTP	FLTP	16	16	Qty in Order Price Unit for Amount-Based Distribution
123	BSTMG_ABD	☐	BSTMG_ABD	FLTP	FLTP	16	16	Quantity in Order Unit for Amount-Based Distribution
124	XHISTMA	☐	XHISTMA	CHAR1	CHAR	1	0	Update Multiple Account Assignment EKBE_MA, EKBZ_MA
125	MULKO	☐	MULKO	XFELD	CHAR	1	0	Indicator: Multiple account assignment
126	.INCLUDE	☐				0	0	MMIM Enjoy: WM Data (in GOITEM and IMSEG)
127	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
128	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
129	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
130	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
131	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
132	EVERE	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
133	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
134	UMZST	☐	UMZST	ZUSTD	CHAR	1	0	Status of receiving batch
135	UMZUS	☐	UMZUS	ZUSCH	CHAR	1	0	Status key of transfer batch
136	UMBAR	☐	MIGO_UMBAR	BWTAR	CHAR	10	0	Valuation Type of Transfer Posting Batch	T149D
137	LFBJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
138	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
139	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
140	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
141	CLASS	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
142	UMCLA	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
143	XCLAS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
144	UMXCL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
145	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
146	BSTMG	☐	MB_BSTMG	MENG13	QUAN	13	3	Goods receipt quantity in order unit
147	BSSKZ	☐	LVS_BSSKZ	LVS_BSSKZ	CHAR	1	0	Special movement indicator for warehouse management	*
148	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	*
149	ANZGEB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
150	MAT_KDAUF	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	*
151	MAT_KDPOS	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
152	MAT_PSPNR	☐	MAT_PSPNR	PS_POSNR	NUMC	8	0	Valuated customer stock WBS element	*
153	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
154	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
155	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
156	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
157	VLIEF_AVIS	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
158	VBELP_AVIS	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
159	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
160	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
161	ETENS	☐	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
162	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
163	GLOBAL_COUNTER	☐	MIGO_GLOBAL_COUNTER	NUMC6	NUMC	6	0	Unique number for one line
164	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
165	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	*
166	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
167	ANZSN	☐	ANZSER	CK_INT4	INT4	10	0	Number of Serial Numbers/Pieces of Equipment to be Created
168	XSAUT	☐	XSAUT	XFELD	CHAR	1	0	Serial number to be created automatically via method
169	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
170	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
171	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
172	UMCUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
173	.INCLUDE	☐				0	0	MMIM Enjoy: CO Data
174	.INCLUDE	☐				0	0	MMIM Enjoy: CO Data Entered on Screen
175	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
176	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
177	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
178	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
179	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
180	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
181	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
182	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
183	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
184	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
185	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
186	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
187	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
188	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
189	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
190	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
191	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
192	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
193	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
194	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
195	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
196	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
197	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
198	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
199	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
200	.INCLUDE	☐				0	0
201	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
202	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
203	.INCLUDE	☐				0	0	MMIM Enjoy: CO Data Derived / No Field Selection
204	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
205	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
206	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
207	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
208	EAN11_BME	☐	EAN11_BME	EAN11	CHAR	18	0	International Article Number (EAN/UPC) in Order Unit
209	EAN11_KON	☐	EAN11_KON	EAN11	CHAR	18	0	International Article Number (EAN/UPC) Check
210	EANME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
211	WEANZ	☐	WEANZ	NUM3	NUMC	3	0	Number of GR/GI slips to be printed
212	WEANZX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
213	R_MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
214	R_MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
215	.INCLUDE	☐				0	0	Enhancement Fields for Goods Receipt (Data)
216	DUMMY3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
217	BATCH_TYPE	☐	BATCH_TYPE	BATCH_TYPE	CHAR	1	0	Type of Batch
218	MAKTX	☐	MAKTX_D	TEXT40	CHAR	40	0	Material Short Text with Field Label 'Material'
219	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
220	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
221	UMMATKL	☐	UMMATKL	MATKL	CHAR	9	0	Material Group (Transfer Posting)	*
222	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	*
223	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
224	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
225	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
226	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
227	WAMME	☐	MIGO_WAMME	MEINS	UNIT	3	0	Unit of Measure of Outputted Quantity	*
228	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
229	SC_ADJUST	☐	MIGO_SC_ADJUST	MIGO_SC_ADJUST	CHAR	1	0	Consumption Type: Subsequent Adjustment
230	ELIKZ_PO	☐	ELIKZ_PO	XFELD	CHAR	1	0	"Delivery Completed" Indicator in Purchase Order Item
231	ELIKZ_MATDOC	☐	ELIKZ_MATDOC	XFELD	CHAR	1	0	"Delivery Completed" Indicator for Material Document Item
232	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
233	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
234	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
235	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
236	BTEXT	☐	BWTXT	BTEXT	CHAR	20	0	Movement type text (inventory management)
237	GRTXT	☐	GRTXT	TEXT20	CHAR	20	0	Reason for Goods Movement
238	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
239	QINSPST	☐	QINSPST	QINSPST	CHAR	1	0	Status of Goods Receipt Inspection
240	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
241	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
242	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
243	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
244	KZBAA	☐	KZBAA	XFELD	CHAR	1	0	Indicator: valuation type is set automatically
245	BWTOR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
246	BATCH_FROM_REFDOC	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
247	VENDORBATCH_FROM_REFDOC	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
248	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
249	XLORT	☐	XLORT	XFELD	CHAR	1	0	Storage location necessary
250	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
251	WESCH	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
252	UMXWMHD	☐	UMXWMHD	XFELD	CHAR	1	0	Check Best Before Date/Date of Manufacture (Transfer Pstng)
253	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
254	UMMHDRZ	☐	UMMHDRZ	DEC4	DEC	4	0	Remaining Shelf Life (Transfer Posting)
255	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
256	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
257	UMKZWSM	☐	UMKZWSO	KZWSO	CHAR	1	0	Usage/Types of Units of Measure (Transfer Posting)
258	XPARALLEL	☐	MB_XFELD	XFELD	CHAR	1	0	Checkbox
259	UMXPARALLEL	☐	MB_XFELD	XFELD	CHAR	1	0	Checkbox
260	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
261	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
262	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
263	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
264	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
265	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
266	BUMRZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
267	BUMRN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
268	BPBMG	☐	BPBMG	MENGE	QUAN	13	3	Purchase order quantity in order price unit
269	KZZUG	☐	KZZUG	KZZUG	CHAR	1	0	Receipt indicator
270	XCANCEL_DONE	☐	MIGO_CANCEL_DONE	XFELD	CHAR	1	0	Item already cancelled
271	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
272	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
273	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
274	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
275	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
276	WERTU	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
277	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
278	LOGLEVEL	☐	MIGO_LOGLEVEL	TEXT50	CHAR	50	0	Error status
279	PTEXT	☐	PTEXT_D	TEXT20	CHAR	20	0	Text for Item Category
280	MIGO_INSMK	☐	MIGO_INSMK	MIGO_INSMK	CHAR	1	0	Stock Type
281	PRFRQ	☐	PRFRQ	DEC5	DEC	5	0	Interval until next recurring inspection
282	UMPRFRQ	☐	UMPRFRQ	DEC5	DEC	5	0	Time Interval Until Next Recurring Check (Transfer Posting)
283	SSQSS	☐	SSQSS	SSQSS	CHAR	8	0	QA Control Key
284	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
285	AFNAM_TEL	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
286	WEMPF_TEL	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
287	FREIGHT	☐	FRERF	XFELD	CHAR	1	0	Vendor for delivery costs enterable at time of GR
288	NAST	☐	MIGO_NAST	XFELD	CHAR	1	0	Outputs exist for this item
289	SMBLN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
290	SJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
291	SMBLP	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
292	IMPORT	☐	MIGO_IMPORT	XFELD	CHAR	1	0	Import data exists for this item
293	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
294	MFRNAME	☐	MIGO_MFRNAME	NAME	CHAR	35	0	Name of manufacturer
295	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
296	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
297	ELIKZ_ORD	☐	MIGO_ELIKZ_ORD	XFELD	CHAR	1	0	"Delivery Completed" Indicator in Production Order
298	SHKZG_MIGO	☐	SHKZG_MIGO	SHKZG_MIGO	CHAR	1	0	Direction of Goods Movement
299	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
300	UMMAKTX	☐	UMMAKTX	TEXT40	CHAR	40	0	Material Description Transfer Posting
301	UMNAME1	☐	UMNAME1	TEXT30	CHAR	30	0	Plant Description Transfer Posting
302	UMLGOBE	☐	UMLGOBE	TEXT16	CHAR	16	0	Storage Location Description: Transfer Posting
303	UMBWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
304	UMXCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
305	UMXCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
306	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
307	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
308	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
309	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
310	XRESITEM	☐	MIGO_RESITEM	XFELD	CHAR	1	0	Reservation exists for this item
311	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
312	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
313	MEINS_RES	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
314	.INCLUDE	☐				0	0	MMIM Enjoy: WM Data (in GOITEM, not in IMSEG3)
315	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
316	BWLVS	☐	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management	*
317	TBNUM	☐	TBNUM	TBNUM	NUMC	10	0	Transfer Requirement Number	*
318	TBPOS	☐	TBPOS	TBPOS	NUMC	4	0	Transfer Requirement Item
319	UBNUM	☐	UBNUM	UBNUM	NUMC	10	0	Posting Change Number
320	TBPRI	☐	TBPRI	TBPRI	CHAR	1	0	Transfer Priority
321	XLINKS	☐			CHAR	1	0
322	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
323	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
324	EXBWR	☐	EXBWR	WERT7	CURR	13	2	Externally Entered Posting Amount in Local Currency
325	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
326	MAT_LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
327	MAT_VENDORNAME	☐	MIGO_MAT_VENDORNAME	NAME	CHAR	35	0	Name of Vendor to Whom the Special Stock is Assigned
328	MAT_KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
329	MAT_CUSTNAME	☐	MIGO_MAT_CUSTNAME	NAME	CHAR	35	0	Name of Customer to Whom the Special Stock is Assigned
330	CUSTNAME	☐	MIGO_CUSTNAME	NAME	CHAR	35	0	Name of Customer
331	HPOS_WWS	☐	HPOS_WWS	CHAR1	CHAR	1	0	Retail: Subitems exist
332	KTOMA	☐	KTOMA	CHAR1	CHAR	1	0	Acct entered manually
333	TAX_RELEVANT	☐			CHAR	1	0
334	WM_RELEVANT	☐			CHAR	1	0
335	XACCOUNT	☐			CHAR	1	0
336	XACCOUNT_DISP	☐			CHAR	1	0
337	XDETERMINATION	☐			CHAR	1	0
338	XUMDETERMINATION	☐			CHAR	1	0
339	XPARTNERS	☐			CHAR	1	0
340	XMANU	☐			CHAR	1	0
341	PPS_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
342	PPS_POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
343	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	*
344	XQM_CERT	☐	MIGO_QM_CERTIFICATE	XFELD	CHAR	1	0	Item is relevant for QM certificate
345	RES_ADRNAME	☐	MIGO_USERNAME	SO_STRI035	CHAR	35	0	Search for a user name
346	RES_TELUSERNAME	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
347	BOLNR_REFDOC	☐	BOLNR	CHAR35	CHAR	35	0	Bill of lading
348	VERUR_REFDOC	☐	VERUR_LA	CHAR35	CHAR	35	0	Identification of delivery at vendor's site
349	EPRIO	☐	EPRIO	EPRIO	CHAR	4	0	Withdrawal sequence group for stocks	*
350	J_1BEXBASE	☐	J_1BEXBASE	WERT7	CURR	13	2	Alternate base amount in document currency
351	XAUTO	☐	XAUTO	XFELD	CHAR	1	0	Indicator: Line item automatically created
352	RES_SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
353	BWART_RETPO	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
354	UMLGPBE	☐	UMLGPBE	CHAR10	CHAR	10	0	Storage Bin (Transfer Posting)
355	UMMATBF	☐	UMMATBF	MATNR	CHAR	18	0	Material with Stock Records (Transfer Posting)	*
356	UMMAT_KDAUF	☐	UMMAT_KDAUF	VBELN	CHAR	10	0	Number of Valuated Sales Order Stock (Transfer Posting)	*
357	UMMAT_KDPOS	☐	UMMAT_KDPOS	NUM06	NUMC	6	0	Item of Valuated Sales Order Stock (Transfer Posting)
358	UMMAT_PSPNR	☐	UMMAT_PSPNR	PS_POSNR	NUMC	8	0	WBS Element of Valuated Sales Order Stock (Transfer Posting)	*
359	UMMAT_LIFNR	☐	UMMAT_LIFNR	LIFNR	CHAR	10	0	Vendor Account Number (Transfer Posting)	*
360	UMMAT_VENDORNAME	☐	UMMAT_VENDORNAME	NAME	CHAR	35	0	Name of Vendor for Special Stock (Transfer Posting)
361	UMMAT_KUNNR	☐	UMMAT_KUNNR	KUNNR	CHAR	10	0	Customer Account Number (Transfer Posting)	*
362	UMMAT_CUSTNAME	☐	UMMAT_CUSTNAME	NAME	CHAR	35	0	Name of Customer for Special Stock (Transfer Posting)
363	UMKZBAA	☐	UMKZBAA	XFELD	CHAR	1	0	Valuation Type Automatically Defined (Transfer Posting)
364	UMEPRIO	☐	UMEPRIO	EPRIO	CHAR	4	0	Withdrawal Sequence Group of Stocks (Transfer Posting)	*
365	SOTXT	☐	SOTXT_D	TEXT20	CHAR	20	0	Description of special stock
366	UMSOTXT	☐	UMSOTXT_D	TEXT20	CHAR	20	0	Special Stock Description (Transfer Posting)
367	.INCLUDE	☐				0	0	Manually Entered Fields
368	XUMMAKTX_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
369	XUMNAME1_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
370	XUMLGOBE_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
371	XUMCHA_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
372	XUMBAR_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
373	XBWTAR_MANUAL	☐	MIGO_FIELD_MANUAL	XFELD	CHAR	1	0	The field concerned was entered manually
374	UMLGNUM	☐	UMLGNUM	UMLGNUM	CHAR	3	0	Stock Transfer Number
375	UMHSDAT	☐	UMHSDAT	DATUM	DATS	8	0	Date on Which Batch Was Manufactured (Transfer Posting)
376	UMVFDAT	☐	UMVFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best Before Date (Transfer Posting)
377	XTRANSFER_MVT	☐	XTRANSFER_MVT	XFELD	CHAR	1	0	Transfer Posting Movement Type
378	XSTOCK_TYPE_MVT	☐	XSTOCK_TYPE_MVT	XFELD	CHAR	1	0	Movement Types that Contain Implied Stock Type (INSMK)
379	XREMOVE_FROM_MVT	☐	XREMOVE_FROM_MVT	XFELD	CHAR	1	0	Remove-from-Storage Movement Type (2-Step Transfer Posting)
380	XPLACE_IN_MVT	☐	XPLACE_IN_MVT	XFELD	CHAR	1	0	Place in Storage Movement Type (Two-Step Transfer Posting)
381	RES_UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
382	RES_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
383	RES_KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
384	RES_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
385	RES_KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
386	RES_PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
387	LEINDT	☐	BBEIN	DATUM	DATS	8	0	Delivery Date of Vendor Confirmation
388	XAUTOPO	☐	MB_XFELD	XFELD	CHAR	1	0	Checkbox
389	KZECH	☐	KZECH	KZECH	CHAR	1	0	Determination of batch entry in the production/process order
390	FRM_SERVICE_DATA	☐	FRM_SERVICE_DATA		CHAR	35	0	SLS-related data
391	LONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number
392	.INCLUDE	☐				0	0	MMIM Enjoy: Documentary Batch Fields in GOITEM
393	DOCUBATCH_CONTROL	☐	DOCUBATCH_CONTROL	DOCUBATCH_CONTROL	CHAR	1	0	Define Documentary Batches per Material Type
394	DOCUBATCH_CHARG	☐	DOCUBATCH_CHARG	DOCUBATCH_CHARG	CHAR	10	0	Documentary Batch - Batch Number
395	DOCUBATCH_MULT_ENTRIES	☐	XFELD	XFELD	CHAR	1	0	Checkbox
396	WABWE	☐	WABWE	XFELD	CHAR	1	0	Indicator for GI-based goods receipt
397	.INCLUDE	☐				0	0	SRM Fields in Purchase Order Item
398	EXLIN	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
399	EXSNR	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
400	EHTYP	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	TMSRM_EHTYP
401	SPE_SCRAP_IND	☐	/SPE/DELIVERY_SCRAP_IND	/SPE/DELIVERY_SCRAP_IND	CHAR	1	0	Scrap Indicator for EWM Processing
402	SPE_KEEP_QTY	☐	/SPE/KEEP_QTY	MENG13	QUAN	13	3	Keep Quantity
403	MAA_URZEI	☐	MAA_URZEI	MBLPO	NUMC	4	0	Original Line for Account Assignment Item in Material Doc.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADPIC_S_GOITEM	AUFNR	AUFK	AUFNR
2	ADPIC_S_GOITEM	BPRME	T006	MSEHI
3	ADPIC_S_GOITEM	BWTAR	T149D	BWTAR
4	ADPIC_S_GOITEM	CHARG	MCHA	CHARG
5	ADPIC_S_GOITEM	EBELN	EKKO	EBELN
6	ADPIC_S_GOITEM	EBELP	EKPO	EBELP
7	ADPIC_S_GOITEM	EHTYP	TMSRM_EHTYP	EHTYP
8	ADPIC_S_GOITEM	ERFME	T006	MSEHI
9	ADPIC_S_GOITEM	EVERE	T027C	EVERE
10	ADPIC_S_GOITEM	EVERS	T027A	EVERS
11	ADPIC_S_GOITEM	GRUND	T157D	GRUND	REF	C	CN
12	ADPIC_S_GOITEM	KDAUF	VBUK	VBELN
13	ADPIC_S_GOITEM	KNTTP	T163K	KNTTP
14	ADPIC_S_GOITEM	KUNNR	KNA1	KUNNR
15	ADPIC_S_GOITEM	LGNUM	T300	LGNUM
16	ADPIC_S_GOITEM	LGORT	T001L	LGORT
17	ADPIC_S_GOITEM	LGPLA	LAGP	LGPLA
18	ADPIC_S_GOITEM	LGTYP	T301	LGTYP
19	ADPIC_S_GOITEM	MATNR	MARA	MATNR
20	ADPIC_S_GOITEM	MWSKZ	T007A	MWSKZ
21	ADPIC_S_GOITEM	NPLNR	AUFK	AUFNR
22	ADPIC_S_GOITEM	PS_PSP_PNR	PRPS	PSPNR
23	ADPIC_S_GOITEM	SOBKZ	T148	SOBKZ
24	ADPIC_S_GOITEM	TXJCD	TTXJ	TXJCD
25	ADPIC_S_GOITEM	UMBAR	T149D	BWTAR
26	ADPIC_S_GOITEM	UMCHA	MCHA	CHARG
27	ADPIC_S_GOITEM	UMLGO	T001L	LGORT
28	ADPIC_S_GOITEM	UMMAT	MARA	MATNR
29	ADPIC_S_GOITEM	UMWRK	T001W	WERKS
30	ADPIC_S_GOITEM	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	500