SAP ABAP Table GOITEM_TV (Fields of GOITEM, which are in table view)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	GOITEM_TV	Table Relationship Diagram
Short Description	Fields of GOITEM, which are in table view

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	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
2	LOGLEVEL	☐	MIGO_LOGLEVEL	TEXT50	CHAR	50	0	Error status
3	MAKTX	☐	MAKTX_D	TEXT40	CHAR	40	0	Material Short Text with Field Label 'Material'
4	TAKE_IT	☐	MB_TAKE_IT	XFELD	CHAR	1	0	Item is Adopted in Document
5	ERFMG	☐	MB_ERFMG	MENG13	QUAN	13	3	Quantity in Unit of Entry
6	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
7	LGOBE	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
8	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
11	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
12	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
13	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
14	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
15	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
16	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
17	BPRME	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
18	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
19	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
20	EAN11_BME	☐	EAN11_BME	EAN11	CHAR	18	0	International Article Number (EAN/UPC) in Order Unit
21	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
22	EAN11_KON	☐	EAN11_KON	EAN11	CHAR	18	0	International Article Number (EAN/UPC) Check
23	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
24	EANME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
26	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
27	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
28	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
29	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
30	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
31	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
32	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
33	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	*
34	ANZGEB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
35	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
36	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
37	VENDORNAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
38	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
39	MEINS	☐	MB_MEINS	MEINS	UNIT	3	0	Quantity in Stockkeeping Unit	*
40	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
41	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	*
42	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
43	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
44	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
45	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
46	SC_ADJUST	☐	MIGO_SC_ADJUST	MIGO_SC_ADJUST	CHAR	1	0	Consumption Type: Subsequent Adjustment
47	ELIKZ_PO	☐	ELIKZ_PO	XFELD	CHAR	1	0	"Delivery Completed" Indicator in Purchase Order Item
48	ELIKZ_MATDOC	☐	ELIKZ_MATDOC	XFELD	CHAR	1	0	"Delivery Completed" Indicator for Material Document Item
49	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
50	GRTXT	☐	GRTXT	TEXT20	CHAR	20	0	Reason for Goods Movement
51	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
52	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
53	SHKZG_MIGO	☐	SHKZG_MIGO	SHKZG_MIGO	CHAR	1	0	Direction of Goods Movement
54	MIGO_INSMK	☐	MIGO_INSMK	MIGO_INSMK	CHAR	1	0	Stock Type
55	MIGO_ELIKZ	☐	MIGO_ELIKZ	MIGO_ELIKZ	NUMC	1	0	"Delivery Completed" Indicator
56	EXPAND	☐	MIGO_EXPANDER	CHAR4	CHAR	4	0	Expand/collapse item
57	EXBWR	☐	EXBWR	WERT7	CURR	13	2	Externally Entered Posting Amount in Local Currency
58	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
59	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
60	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
61	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
62	CUSTNAME	☐	MIGO_CUSTNAME	NAME	CHAR	35	0	Name of Customer
63	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
64	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
65	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
66	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
67	MEINS_RES	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
68	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
69	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
70	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
71	PPS_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
72	PPS_POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
73	ELIKZ_ORD	☐	MIGO_ELIKZ_ORD	XFELD	CHAR	1	0	"Delivery Completed" Indicator in Production Order
74	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
75	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
76	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
77	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
78	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
79	MAT_KDAUF	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	*
80	MAT_KDPOS	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
81	MAT_PSPNR	☐	MAT_PSPNR	PS_POSNR	NUMC	8	0	Valuated customer stock WBS element	*
82	MAT_CUSTNAME	☐	MIGO_MAT_CUSTNAME	NAME	CHAR	35	0	Name of Customer to Whom the Special Stock is Assigned
83	MAT_KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
84	MAT_VENDORNAME	☐	MIGO_MAT_VENDORNAME	NAME	CHAR	35	0	Name of Vendor to Whom the Special Stock is Assigned
85	MAT_LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
86	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
87	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
88	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
89	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
90	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
91	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
92	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
93	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
94	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
95	WEANZ	☐	WEANZ	NUM3	NUMC	3	0	Number of GR/GI slips to be printed
96	UMMAKTX	☐	MAKTX_D	TEXT40	CHAR	40	0	Material Short Text with Field Label 'Material'
97	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	*
98	UMNAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
99	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	*
100	UMLGOBE	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
101	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	*
102	UMLGPBE	☐	UMLGPBE	CHAR10	CHAR	10	0	Storage Bin (Transfer Posting)
103	UMCHA	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	*
104	UMZST	☐	UMZST	ZUSTD	CHAR	1	0	Status of receiving batch
105	UMBAR	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch	*
106	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
107	UMMAT_KDAUF	☐	UMMAT_KDAUF	VBELN	CHAR	10	0	Number of Valuated Sales Order Stock (Transfer Posting)	*
108	UMMAT_KDPOS	☐	UMMAT_KDPOS	NUM06	NUMC	6	0	Item of Valuated Sales Order Stock (Transfer Posting)
109	UMMAT_PSPNR	☐	UMMAT_PSPNR	PS_POSNR	NUMC	8	0	WBS Element of Valuated Sales Order Stock (Transfer Posting)	*
110	UMMAT_VENDORNAME	☐	UMMAT_VENDORNAME	NAME	CHAR	35	0	Name of Vendor for Special Stock (Transfer Posting)
111	UMMAT_LIFNR	☐	UMMAT_LIFNR	LIFNR	CHAR	10	0	Vendor Account Number (Transfer Posting)	*
112	UMMAT_CUSTNAME	☐	UMMAT_CUSTNAME	NAME	CHAR	35	0	Name of Customer for Special Stock (Transfer Posting)
113	UMMAT_KUNNR	☐	UMMAT_KUNNR	KUNNR	CHAR	10	0	Customer Account Number (Transfer Posting)	*
114	UMMAT_HSDAT	☐	UMHSDAT	DATUM	DATS	8	0	Date on Which Batch Was Manufactured (Transfer Posting)
115	UMMAT_VFDAT	☐	UMVFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best Before Date (Transfer Posting)
116	LEINDT	☐	BBEIN	DATUM	DATS	8	0	Delivery Date of Vendor Confirmation
117	DOCUBATCH_CHARG	☐	DOCUBATCH_CHARG	DOCUBATCH_CHARG	CHAR	10	0	Documentary Batch - Batch Number
118	LONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GOITEM_TV	BWART	T156	BWART
2	GOITEM_TV	GRUND	T157D	GRUND

History

Last changed by/on	SAP	20130529
SAP Release Created in