SAP ABAP View MGV_MSEG (Selection MSEG with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_MSEG
Short Description	Selection MSEG with material version, see: http://material
Root table	MSEG	Document Segment: Material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MSEG	MSEG
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MSEG	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	MSEG	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	MSEG	*		☐		☐
2	MANDT	MSEG	MANDT		☐	MANDT	☐	Client
3	MBLNR	MSEG	MBLNR		☐	MBLNR	☐	Number of Material Document
4	MJAHR	MSEG	MJAHR		☐	MJAHR	☐	Year of material document
5	ZEILE	MSEG	ZEILE		☐	MBLPO	☐	Item in material document
6	LINE_ID	MSEG	LINE_ID		☐	MB_LINE_ID	☐	Unique identification of document line
7	PARENT_ID	MSEG	PARENT_ID		☐	MB_PARENT_ID	☐	Identifier of immediately superior line
8	LINE_DEPTH	MSEG	LINE_DEPTH		☐	MB_LINE_DEPTH	☐	Hierarchy level of line in document
9	MAA_URZEI	MSEG	MAA_URZEI		☐	MAA_URZEI	☐	Original Line for Account Assignment Item in Material Doc.
10	BWART	MSEG	BWART		☐	BWART	☐	Movement type (inventory management)
11	XAUTO	MSEG	XAUTO		☐	MB_XAUTO	☐	Item automatically created
12	MATNR	MSEG	MATNR		☐	MATNR	☐	Material Number
13	WERKS	MSEG	WERKS		☐	WERKS_D	☐	Plant
14	LGORT	MSEG	LGORT		☐	LGORT_D	☐	Storage location
15	CHARG	MSEG	CHARG		☐	CHARG_D	☐	Batch Number
16	INSMK	MSEG	INSMK		☐	MB_INSMK	☐	Stock Type
17	ZUSCH	MSEG	ZUSCH		☐	DZUSCH	☐	Batch status key
18	ZUSTD	MSEG	ZUSTD		☐	DZUSTD	☐	Batch in Restricted-Use Stock
19	SOBKZ	MSEG	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
20	LIFNR	MSEG	LIFNR		☐	ELIFN	☐	Vendor's account number
21	KUNNR	MSEG	KUNNR		☐	EKUNN	☐	Account number of customer
22	KDAUF	MSEG	KDAUF		☐	KDAUF	☐	Sales Order Number
23	KDPOS	MSEG	KDPOS		☐	KDPOS	☐	Item number in Sales Order
24	KDEIN	MSEG	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
25	PLPLA	MSEG	PLPLA		☐	PLPLA	☐	Distribution of Differences
26	SHKZG	MSEG	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
27	WAERS	MSEG	WAERS		☐	WAERS	☐	Currency Key
28	DMBTR	MSEG	DMBTR		☐	DMBTR	☐	Amount in local currency
29	BNBTR	MSEG	BNBTR		☐	BNBTR	☐	Delivery costs in local currency
30	BUALT	MSEG	BUALT		☐	BUALT	☐	Amount posted in alternative price control
31	SHKUM	MSEG	SHKUM		☐	SHKUM	☐	Debit/credit indicator in revaluation
32	DMBUM	MSEG	DMBUM		☐	DMBUM	☐	Revaluation amount on back-posting to a previous period
33	BWTAR	MSEG	BWTAR		☐	BWTAR_D	☐	Valuation type
34	MENGE	MSEG	MENGE		☐	MENGE_D	☐	Quantity
35	MEINS	MSEG	MEINS		☐	MEINS	☐	Base Unit of Measure
36	ERFMG	MSEG	ERFMG		☐	ERFMG	☐	Quantity in unit of entry
37	ERFME	MSEG	ERFME		☐	ERFME	☐	Unit of entry
38	BPMNG	MSEG	BPMNG		☐	BPMNG	☐	Quantity in order price quantity unit
39	BPRME	MSEG	BPRME		☐	BBPRM	☐	Order Price Unit (purchasing)
40	EBELN	MSEG	EBELN		☐	BSTNR	☐	Purchase order number
41	EBELP	MSEG	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
42	LFBJA	MSEG	LFBJA		☐	LFBJA	☐	Fiscal Year of a Reference Document
43	LFBNR	MSEG	LFBNR		☐	LFBNR	☐	Document number of a reference document
44	LFPOS	MSEG	LFPOS		☐	LFPOS	☐	Item of a reference document
45	SJAHR	MSEG	SJAHR		☐	MJAHR	☐	Year of material document
46	SMBLN	MSEG	SMBLN		☐	MBLNR	☐	Number of Material Document
47	SMBLP	MSEG	SMBLP		☐	MBLPO	☐	Item in material document
48	ELIKZ	MSEG	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
49	SGTXT	MSEG	SGTXT		☐	SGTXT	☐	Item Text
50	EQUNR	MSEG	EQUNR		☐	EQUNR	☐	Equipment Number
51	WEMPF	MSEG	WEMPF		☐	WEMPF	☐	Goods recipient
52	ABLAD	MSEG	ABLAD		☐	ABLAD	☐	Unloading Point
53	GSBER	MSEG	GSBER		☐	GSBER	☐	Business Area
54	KOKRS	MSEG	KOKRS		☐	KOKRS	☐	Controlling Area
55	PARGB	MSEG	PARGB		☐	PARGB	☐	Trading partner's business area
56	PARBU	MSEG	PARBU		☐	PARBU	☐	Clearing company code
57	KOSTL	MSEG	KOSTL		☐	KOSTL	☐	Cost Center
58	PROJN	MSEG	PROJN		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
59	AUFNR	MSEG	AUFNR		☐	AUFNR	☐	Order Number
60	ANLN1	MSEG	ANLN1		☐	ANLN1	☐	Main Asset Number
61	ANLN2	MSEG	ANLN2		☐	ANLN2	☐	Asset Subnumber
62	XSKST	MSEG	XSKST		☐	XSKST	☐	Indicator: Statistical Posting to Cost Center
63	XSAUF	MSEG	XSAUF		☐	XSAUF	☐	Indicator: Posting to Order Is Statistical
64	XSPRO	MSEG	XSPRO		☐	XSPRO	☐	Indicator: Posting to Project Is Statistical
65	XSERG	MSEG	XSERG		☐	XSERG	☐	Indicator: Posting to Profitability Analysis Is Statistical
66	GJAHR	MSEG	GJAHR		☐	GJAHR	☐	Fiscal Year
67	XRUEM	MSEG	XRUEM		☐	XRUEM	☐	Allow Posting to Previous Period (Backposting)
68	XRUEJ	MSEG	XRUEJ		☐	XRUEJ	☐	Indicator: post to previous year
69	BUKRS	MSEG	BUKRS		☐	BUKRS	☐	Company Code
70	BELNR	MSEG	BELNR		☐	BELNR_D	☐	Accounting Document Number
71	BUZEI	MSEG	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
72	BELUM	MSEG	BELUM		☐	BELNR_D	☐	Accounting Document Number
73	BUZUM	MSEG	BUZUM		☐	BUZEI	☐	Number of Line Item Within Accounting Document
74	RSNUM	MSEG	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
75	RSPOS	MSEG	RSPOS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
76	KZEAR	MSEG	KZEAR		☐	KZEAR	☐	Final issue for this reservation
77	PBAMG	MSEG	PBAMG		☐	MENGE_D	☐	Quantity
78	KZSTR	MSEG	KZSTR		☐	KZSTR	☐	Transaction/event is relevant to statistics
79	UMMAT	MSEG	UMMAT		☐	UMMAT	☐	Receiving/issuing material
80	UMWRK	MSEG	UMWRK		☐	UMWRK	☐	Receiving plant/issuing plant
81	UMLGO	MSEG	UMLGO		☐	UMLGO	☐	Receiving/issuing storage location
82	UMCHA	MSEG	UMCHA		☐	UMCHA	☐	Receiving/issuing batch
83	UMZST	MSEG	UMZST		☐	UMZST	☐	Status of receiving batch
84	UMZUS	MSEG	UMZUS		☐	UMZUS	☐	Status key of transfer batch
85	UMBAR	MSEG	UMBAR		☐	UMBAR	☐	Valuation type of transfer batch
86	UMSOK	MSEG	UMSOK		☐	UMSOK	☐	Special stock indicator for physical stock transfer
87	KZBEW	MSEG	KZBEW		☐	KZBEW	☐	Movement Indicator
88	KZVBR	MSEG	KZVBR		☐	KZVBR	☐	Consumption posting
89	KZZUG	MSEG	KZZUG		☐	KZZUG	☐	Receipt indicator
90	WEUNB	MSEG	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
91	PALAN	MSEG	PALAN		☐	PALAN	☐	WMS Number of pallets
92	LGNUM	MSEG	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
93	LGTYP	MSEG	LGTYP		☐	LGTYP	☐	Storage Type
94	LGPLA	MSEG	LGPLA		☐	LGPLA	☐	Storage Bin
95	BESTQ	MSEG	BESTQ		☐	BESTQ	☐	Stock Category in the Warehouse Management System
96	BWLVS	MSEG	BWLVS		☐	BWLVS	☐	Movement Type for Warehouse Management
97	TBNUM	MSEG	TBNUM		☐	TBNUM	☐	Transfer Requirement Number
98	TBPOS	MSEG	TBPOS		☐	TBPOS	☐	Transfer Requirement Item
99	XBLVS	MSEG	XBLVS		☐	XBLVS	☐	Indicator: posting in warehouse management system
100	VSCHN	MSEG	VSCHN		☐	T333_VSCHN	☐	Ind: interim storage posting for source stor.type and bin
101	NSCHN	MSEG	NSCHN		☐	T333_NSCHN	☐	Ind.: interim storage posting for dest.stor.type and bin
102	DYPLA	MSEG	DYPLA		☐	DYPLA	☐	Indicator: dynamic storage bin
103	UBNUM	MSEG	UBNUM		☐	UBNUM	☐	Posting Change Number
104	TBPRI	MSEG	TBPRI		☐	TBPRI	☐	Transfer Priority
105	TANUM	MSEG	TANUM		☐	TANUM	☐	Transfer Order Number
106	WEANZ	MSEG	WEANZ		☐	WEANZ	☐	Number of GR/GI slips to be printed
107	GRUND	MSEG	GRUND		☐	MB_GRBEW	☐	Reason for movement
108	EVERS	MSEG	EVERS		☐	EVERS	☐	Shipping Instructions
109	EVERE	MSEG	EVERE		☐	EVERE	☐	Compliance with Shipping Instructions
110	IMKEY	MSEG	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
111	KSTRG	MSEG	KSTRG		☐	KSTRG	☐	Cost Object
112	PAOBJNR	MSEG	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
113	PRCTR	MSEG	PRCTR		☐	PRCTR	☐	Profit Center
114	PS_PSP_PNR	MSEG	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
115	NPLNR	MSEG	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
116	AUFPL	MSEG	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
117	APLZL	MSEG	APLZL		☐	CIM_COUNT	☐	Internal counter
118	AUFPS	MSEG	AUFPS		☐	CO_POSNR	☐	Order item number
119	VPTNR	MSEG	VPTNR		☐	JV_PART	☐	Partner account number
120	FIPOS	MSEG	FIPOS		☐	FIPOS	☐	Commitment Item
121	SAKTO	MSEG	SAKTO		☐	SAKNR	☐	G/L Account Number
122	BSTMG	MSEG	BSTMG		☐	MB_BSTMG	☐	Goods receipt quantity in order unit
123	BSTME	MSEG	BSTME		☐	BSTME	☐	Order unit
124	XWSBR	MSEG	XWSBR		☐	XWSBR	☐	Reversal of GR allowed for GR-based IV despite invoice
125	EMLIF	MSEG	EMLIF		☐	EMLIF	☐	Vendor to be supplied/who is to receive delivery
126	EXBWR	MSEG	EXBWR		☐	EXBWR	☐	Externally Entered Posting Amount in Local Currency
127	VKWRT	MSEG	VKWRT		☐	VKWRT	☐	Value at sales prices including value-added tax
128	AKTNR	MSEG	AKTNR		☐	WAKTION	☐	Promotion
129	ZEKKN	MSEG	ZEKKN		☐	DZEKKN	☐	Sequential Number of Account Assignment
130	VFDAT	MSEG	VFDAT		☐	VFDAT	☐	Shelf Life Expiration or Best-Before Date
131	CUOBJ_CH	MSEG	CUOBJ_CH		☐	CUOBJ_CH	☐	Internal object number of the batch classification
132	EXVKW	MSEG	EXVKW		☐	EXVKW	☐	Externally Entered Sales Value in Local Currency
133	PPRCTR	MSEG	PPRCTR		☐	PPRCTR	☐	Partner Profit Center
134	RSART	MSEG	RSART		☐	RSART	☐	Record type
135	GEBER	MSEG	GEBER		☐	BP_GEBER	☐	Fund
136	FISTL	MSEG	FISTL		☐	FISTL	☐	Funds Center
137	MATBF	MSEG	MATBF		☐	MATBF	☐	Material in Respect of Which Stock is Managed
138	UMMAB	MSEG	UMMAB		☐	UMMAT	☐	Receiving/issuing material
139	BUSTM	MSEG	BUSTM		☐	BUSTM	☐	Posting string for quantities
140	BUSTW	MSEG	BUSTW		☐	BUSTW	☐	Posting string for values
141	MENGU	MSEG	MENGU		☐	MENGU	☐	Quantity Updating in Material Master Record
142	WERTU	MSEG	WERTU		☐	WERTU	☐	Value Updating in Material Master Record
143	LBKUM	MSEG	LBKUM		☐	LBKUM_MSEG	☐	Total valuated stock before the posting
144	SALK3	MSEG	SALK3		☐	SALK3_MSEG	☐	Value of total valuated stock before the posting
145	VPRSV	MSEG	VPRSV		☐	VPRSV	☐	Price control indicator
146	FKBER	MSEG	FKBER		☐	FKBER	☐	Functional Area
147	DABRBZ	MSEG	DABRBZ		☐	DABRBEZ	☐	Reference date for settlement
148	VKWRA	MSEG	VKWRA		☐	VKWRA	☐	Value at sales prices excluding value-added tax
149	DABRZ	MSEG	DABRZ		☐	DABRBEZ	☐	Reference date for settlement
150	XBEAU	MSEG	XBEAU		☐	XBEAU	☐	Purchase order created at time of goods receipt
151	LSMNG	MSEG	LSMNG		☐	LSMNG	☐	Quantity in Unit of Measure from Delivery Note
152	LSMEH	MSEG	LSMEH		☐	LSMEH	☐	Unit of Measure From Delivery Note
153	KZBWS	MSEG	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
154	QINSPST	MSEG	QINSPST		☐	QINSPST	☐	Status of Goods Receipt Inspection
155	URZEI	MSEG	URZEI		☐	URZEI	☐	Original line in material document
156	J_1BEXBASE	MSEG	J_1BEXBASE		☐	J_1BEXBASE	☐	Alternate base amount in document currency
157	MWSKZ	MSEG	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
158	TXJCD	MSEG	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
159	EMATN	MSEG	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
160	J_1AGIRUPD	MSEG	J_1AGIRUPD		☐	J_1AGIRUPD	☐	Goods issue revaluation performed
161	VKMWS	MSEG	VKMWS		☐	MWSKZ	☐	Tax on sales/purchases code
162	HSDAT	MSEG	HSDAT		☐	HSDAT	☐	Date of Manufacture
163	BERKZ	MSEG	BERKZ		☐	BERKZ	☐	Material Staging Indicator for Production Supply
164	MAT_KDAUF	MSEG	MAT_KDAUF		☐	MAT_KDAUF	☐	Sales order number of valuated sales order stock
165	MAT_KDPOS	MSEG	MAT_KDPOS		☐	MAT_KDPOS	☐	Sales Order Item of Valuated Sales Order Stock
166	MAT_PSPNR	MSEG	MAT_PSPNR		☐	MAT_PSPNR	☐	Valuated customer stock WBS element
167	XWOFF	MSEG	XWOFF		☐	XWOFF	☐	Calculation of val. open
168	BEMOT	MSEG	BEMOT		☐	BEMOT	☐	Accounting Indicator
169	PRZNR	MSEG	PRZNR		☐	CO_PRZNR	☐	Business Process
170	LLIEF	MSEG	LLIEF		☐	LLIEF	☐	Supplying Vendor
171	LSTAR	MSEG	LSTAR		☐	LSTAR	☐	Activity Type
172	XOBEW	MSEG	XOBEW		☐	XOBEW	☐	Vendor Stock Valuation Indicator
173	GRANT_NBR	MSEG	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
174	ZUSTD_T156M	MSEG	ZUSTD_T156M		☐	BAMOK_MSEG	☐	Stock Type Modification (Read from Table T156M)
175	SPE_GTS_STOCK_TY	MSEG	SPE_GTS_STOCK_TY		☐	/SPE/GTS_STOCK_TYPE	☐	GTS Stock Type
176	KBLNR	MSEG	KBLNR		☐	KBLNR_FI	☐	Document number for earmarked funds
177	KBLPOS	MSEG	KBLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
178	XMACC	MSEG	XMACC		☐	XMACC	☐	Multiple Account Assignment
179	VGART_MKPF	MSEG	VGART_MKPF		☐	VGART	☐	Transaction/Event Type
180	BUDAT_MKPF	MSEG	BUDAT_MKPF		☐	BUDAT	☐	Posting Date in the Document
181	CPUDT_MKPF	MSEG	CPUDT_MKPF		☐	CPUDT	☐	Accounting document entry date
182	CPUTM_MKPF	MSEG	CPUTM_MKPF		☐	CPUTM	☐	Time of data entry
183	USNAM_MKPF	MSEG	USNAM_MKPF		☐	USNAM	☐	User name
184	XBLNR_MKPF	MSEG	XBLNR_MKPF		☐	XBLNR	☐	Reference Document Number
185	TCODE2_MKPF	MSEG	TCODE2_MKPF		☐	TCODE	☐	Transaction Code
186	VBELN_IM	MSEG	VBELN_IM		☐	VBELN_VL	☐	Delivery
187	VBELP_IM	MSEG	VBELP_IM		☐	POSNR_VL	☐	Delivery Item
188	/BEV2/ED_KZ_VER	MSEG	/BEV2/ED_KZ_VER		☐	/BEV2/EDKZ_VER	☐	Processing Status of Material Document for Excise Duties
189	/BEV2/ED_USER	MSEG	/BEV2/ED_USER		☐	USNAM	☐	User name
190	/BEV2/ED_AEDAT	MSEG	/BEV2/ED_AEDAT		☐	AEDAT	☐	Last Changed On
191	/BEV2/ED_AETIM	MSEG	/BEV2/ED_AETIM		☐	SYUZEIT	☐	System Time
192	OINAVNW	MSEG	OINAVNW		☐	NAVNW	☐	Non-deductible input tax
193	OICONDCOD	MSEG	OICONDCOD		☐	JV_CONDCOD	☐	Joint Venture Indicator (Condition Key)
194	CONDI	MSEG	CONDI		☐	JV_CONDCOD	☐	Joint Venture Indicator (Condition Key)
195	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
196	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☐	Material Version Number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in