SAP ABAP Table MGV_MVD_ALV_DATA (Data Transfer Structure: Material Versions Overview Screen)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGVERS_MVD (Package) Assignment Screen - Document Version to Material Version

Basic Data

Table Category	INTTAB	Structure
Structure	MGV_MVD_ALV_DATA	Table Relationship Diagram
Short Description	Data Transfer Structure: Material Versions Overview Screen

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	ZUORD	☐	MGV_MVD_DMS_LINK_TYPE	MGV_MVD_DMS_LINK_TYPE	CHAR	1	0	Assignment Type for Documents
2	ZUORD_ICON	☐	MGV_MVD_DMS_LINK_TYPE_ICON	CHAR30	CHAR	30	0	Icon for Document Assignment
3	MATNR_INT	☐	MATNR_INT	MATNR_INT	CHAR	18	0	Material Number
4	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
5	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number
6	MATNR_GUID	☐	MATNR_IGUID	SYSUUID	RAW	16	0	Material Number (Internal GUID)
7	MATNR_TYPE	☐	MATNR_TYPE	MATNR_TYPE	CHAR	1	0	Material Number Type
8	MATNR_HEAD	☐	MATNR_HEAD	MATNR_INT	CHAR	18	0	Header Material for Version
9	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
10	MATNR_TYPE_ICON	☐	MGV_MVD_MATNR_TYPE_ICON	CHAR30	CHAR	30	0	Icon for Document Assignment
11	MATNR_DISPLAY	☐	MATNR_HEAD	MATNR_INT	CHAR	18	0	Header Material for Version
12	.INCLUDE	☐				0	0	DMS: Document Key
13	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
14	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
15	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
16	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
17	DKTXT	☐	DKTXT	TEXT40	CHAR	40	0	Document description
18	AENNR	☐	DAENR	AENNR	CHAR	12	0	Change Number	*
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
23	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
24	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
25	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
26	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
27	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
28	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
29	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
30	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
31	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
32	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
33	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
34	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
35	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
36	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
37	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
38	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
39	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
40	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
41	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
42	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
43	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
44	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	T405
45	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
46	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
47	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
48	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
49	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
50	BEHVO	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
51	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
52	TEMPB	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
53	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
54	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
55	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
56	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
57	KUNNR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	V_KNA1WETT
58	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
59	WESCH	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
60	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	*
61	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
62	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
63	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	T6WP3
64	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	T6WP4
65	ENTAR	☐	DUMMYENTAR	CHAR1	CHAR	1	0	Deactivated
66	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
67	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
68	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
69	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
70	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
71	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
72	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
73	AEKLK	☐	CK_AEKLK	XFELD	CHAR	1	0	Stock transfer net change costing
74	CADKZ	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
75	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
76	ERGEW	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
77	ERGEI	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
78	ERVOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
79	ERVOE	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
80	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
81	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
82	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
83	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
84	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
85	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
86	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
87	FUELG	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
88	STFAK	☐	STFAK	INT2	INT2	5	0	Stacking factor
89	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
90	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
91	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
92	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
93	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
94	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
95	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
96	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
97	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
98	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
99	KZKUP	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
100	KZNFM	☐	KZNFM	XFELD	CHAR	1	0	Indicator: The material has a follow-up material
101	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
102	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
103	MSTAV	☐	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	TVMS
104	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
105	MSTDV	☐	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
106	TAKLV	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	TSKM
107	RBNRM	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
108	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
109	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
110	MHDLP	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
111	INHME	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
112	INHAL	☐	INHAL	MENG13	QUAN	13	3	Net contents
113	VPREH	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
114	ETIAG	☐	ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	*
115	INHBR	☐	INHBR	MENG13	QUAN	13	3	Gross contents
116	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
117	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
118	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
119	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	T190S
120	SPROF	☐	SPROF	SPROF	CHAR	1	0	Pricing profile for variants
121	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
122	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
123	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
124	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
125	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	TMPPF
126	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
127	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
128	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
129	IHIVI	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
130	ILOOS	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
131	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
132	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
133	XGCHP	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
134	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
135	COMPL	☐	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	TCSCP_COMP_LVL
136	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
137	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
138	PRZUS	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
139	MTPOS_MARA	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	TPTM
140	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
141	MATFI	☐	MATFI	XFELD	CHAR	1	0	Material Is Locked
142	CMREL	☐	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
143	OVLPN	☐	ADSPC_OPN	ADSPC_OPN	CHAR	32	0	Overlength Part Number
144	RMATP	☐	PL_RMATP	MATNR	CHAR	18	0	Reference material for materials packed in same way	MARA
145	ADSPC_SPC	☐	ADSPC_SPC	ADSPC_SPC	NUMC	1	0	Spare Part Class Code
146	VARID	☐	DI_VARID	SYSUUID	RAW	16	0	GUID Variable Object Identification
147	MSBOOKPARTNO	☐	/SAPHT/DRM_MSBOOKPARTNO	MATNR	CHAR	18	0	Manufacturer book part number	*
148	VTYPE	☐	VERSIONTYPE	VERSIONTYPE	CHAR	10	0	Version Category	MGVTYPE
149	VCHNR	☐	MGV_VCHNR	AENNR	CHAR	12	0	Change number material versions	AENR
150	EVVAL	☐	MGV_EVER_VALID	XFELD	CHAR	1	0	Material is Always Valid
151	DVERS	☐	MGV_MATNR_VALID_DEFAULT	MATNR	CHAR	18	0	Default Version	*
152	IMATN	☐	IMATN	MATNR	CHAR	18	0	FFF class	*
153	PICNUM	☐	PIC_PICNUM_SUS	PIC_PICNUM	CHAR	18	0	Supersession chain number
154	DWNAM	☐	DWNAM	DWNAM	CHAR	12	0	Name of person responsible
155	DOKST	☐	DOKST	DOKST	CHAR	2	0	Document Status	*
156	LABOR_DMS	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
157	WERKA	☐	WERKA	WERKS	CHAR	4	0	Plant	*
158	LOEDK	☐	LOEDK	XFELD	CHAR	1	0	Deletion indicator
159	CADKZ_DMS	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
160	PRENR	☐	PRENR	DOKNR	CHAR	25	0	Document number of superior document	*
161	PREVR	☐	PREVR	DOKVR	CHAR	2	0	Document version of superior document
162	PRETL	☐	PRETL	DOKTL	CHAR	3	0	Document Part of Superior Document
163	PREAR	☐	PREAR	DOKAR	CHAR	3	0	Document type of the superior document	*
164	BEGRU_DMS	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
165	FILEP	☐	FILEP	TEXT255	CHAR	255	0	Original of document
166	DTTRG	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
167	DAPPL	☐	DAPPL	DAPPL	CHAR	3	0	Application	*
168	FILEP1	☐	FILEP	TEXT255	CHAR	255	0	Original of document
169	DTTRG1	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
170	DAPPL1	☐	DAPPL	DAPPL	CHAR	3	0	Application	*
171	VRLDAT	☐	VRLDAT	DATUM	DATS	8	0	Due Date
172	VPRIOR	☐	VPRIOR	NUMC01	NUMC	1	0	Processing priority
173	RES1	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
174	RES2	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
175	RES3	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
176	RES4	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
177	MRK_FILEP	☐	FILEP	TEXT255	CHAR	255	0	Original of document
178	MRK_DTTRG	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
179	MRK_FILEP1	☐	FILEP	TEXT255	CHAR	255	0	Original of document
180	MRK_DTTRG1	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
181	ADATUM	☐	ADATUM	DATUM	DATS	8	0	Output date for document
182	DOKNR_VL	☐	DOKNR_VL	DOKNR	CHAR	25	0	Document Number of Source Document	*
183	FILELEN	☐	ORLN	NUM12	NUMC	12	0	File length of original
184	FILELEN1	☐	ORLN	NUM12	NUMC	12	0	File length of original
185	CM_RELEVANCE	☐	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
186	CM_FIXED	☐	DMS_CM_FIXED	XFELD	CHAR	1	0	Document fixed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_MVD_ALV_DATA	BEHVO	T144	BEHVO
2	MGV_MVD_ALV_DATA	BMATN	MARA	MATNR
3	MGV_MVD_ALV_DATA	BSTME	T006	MSEHI
4	MGV_MVD_ALV_DATA	BWSCL	TMBW1	BWSCL	REF	1	CN
5	MGV_MVD_ALV_DATA	COMPL	TCSCP_COMP_LVL	COMP_LEVEL
6	MGV_MVD_ALV_DATA	EKWSL	T405	EKWSL
7	MGV_MVD_ALV_DATA	ERGEI	T006	MSEHI
8	MGV_MVD_ALV_DATA	ERVOE	T006	MSEHI
9	MGV_MVD_ALV_DATA	ETIAR	T6WP3	ETIAR
10	MGV_MVD_ALV_DATA	ETIFO	T6WP4	ETIFO
11	MGV_MVD_ALV_DATA	EXTWG	TWEW	EXTWG
12	MGV_MVD_ALV_DATA	GEWEI	T006	MSEHI
13	MGV_MVD_ALV_DATA	INHME	T006	MSEHI
14	MGV_MVD_ALV_DATA	KOSCH	T190S	KOSCH
15	MGV_MVD_ALV_DATA	KUNNR	V_KNA1WETT	KUNNR
16	MGV_MVD_ALV_DATA	LABOR	T024L	LABOR
17	MGV_MVD_ALV_DATA	MAGRV	TVEGR	MAGRV
18	MGV_MVD_ALV_DATA	MATKL	T023	MATKL
19	MGV_MVD_ALV_DATA	MBRSH	T137	MBRSH
20	MGV_MVD_ALV_DATA	MEABM	T006	MSEHI
21	MGV_MVD_ALV_DATA	MEINS	T006	MSEHI
22	MGV_MVD_ALV_DATA	MFRNR	LFA1	LIFNR
23	MGV_MVD_ALV_DATA	MPROF	TMPPF	MPROF
24	MGV_MVD_ALV_DATA	MSTAE	T141	MMSTA
25	MGV_MVD_ALV_DATA	MSTAV	TVMS	VMSTA
26	MGV_MVD_ALV_DATA	MTART	T134	MTART
27	MGV_MVD_ALV_DATA	MTPOS_MARA	TPTM	MTPOS
28	MGV_MVD_ALV_DATA	NUMTP	TNTP	NUMTP
29	MGV_MVD_ALV_DATA	PLGTP	TWPT	PLGTP
30	MGV_MVD_ALV_DATA	PMATA	MARA	MATNR
31	MGV_MVD_ALV_DATA	PRDHA	T179	PRODH
32	MGV_MVD_ALV_DATA	PROFL	TDG41	PROFL
33	MGV_MVD_ALV_DATA	RAUBE	T142	RAUBE
34	MGV_MVD_ALV_DATA	RBNRM	T352B	RBNR
35	MGV_MVD_ALV_DATA	RMATP	MARA	MATNR
36	MGV_MVD_ALV_DATA	SAISO	T6WSP	SAISO
37	MGV_MVD_ALV_DATA	SAITY	T6WSA	SAITY
38	MGV_MVD_ALV_DATA	SATNR	MARA	MATNR
39	MGV_MVD_ALV_DATA	SPART	TSPA	SPART
40	MGV_MVD_ALV_DATA	STOFF	MGEF	STOFF
41	MGV_MVD_ALV_DATA	TAKLV	TSKM	TAXKM
42	MGV_MVD_ALV_DATA	TEMPB	T143	TEMPB
43	MGV_MVD_ALV_DATA	TRAGR	TTGR	TRAGR
44	MGV_MVD_ALV_DATA	VCHNR	AENR	AENNR
45	MGV_MVD_ALV_DATA	VHART	TVTY	TRATY
46	MGV_MVD_ALV_DATA	VOLEH	T006	MSEHI
47	MGV_MVD_ALV_DATA	VTYPE	MGVTYPE	VTYPE	REF	1	CN
48	MGV_MVD_ALV_DATA	WRKST	TWSPR	WRKST

History

Last changed by/on	SAP	20140121
SAP Release Created in	46C2