SAP ABAP Table MGVMARA_ALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGVMARA_ALL	Table Relationship Diagram
Short Description	Generated Table for 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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number
3	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
6	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
8	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
9	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
10	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
11	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
12	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
13	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
14	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
15	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
16	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
17	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
18	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
19	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
20	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
21	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
22	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
23	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
24	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
25	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
26	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
27	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
28	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
29	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	T405
30	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
31	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
32	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
33	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
34	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
35	BEHVO	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
36	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
37	TEMPB	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
38	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
39	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
40	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
41	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
42	KUNNR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	V_KNA1WETT
43	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
44	WESCH	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
45	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
46	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
47	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
48	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	T6WP3
49	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	T6WP4
50	ENTAR	☐	DUMMYENTAR	CHAR1	CHAR	1	0	Deactivated
51	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
52	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
53	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
54	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
55	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
56	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
57	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
58	AEKLK	☐	CK_AEKLK	XFELD	CHAR	1	0	Stock transfer net change costing
59	CADKZ	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
60	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
61	ERGEW	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
62	ERGEI	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
63	ERVOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
64	ERVOE	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
65	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
66	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
67	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
68	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
69	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
70	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
71	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
72	FUELG	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
73	STFAK	☐	STFAK	INT2	INT2	5	0	Stacking factor
74	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
75	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
76	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
77	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
78	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
79	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
80	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
81	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
82	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
83	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
84	KZKUP	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
85	KZNFM	☐	KZNFM	XFELD	CHAR	1	0	Indicator: The material has a follow-up material
86	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
87	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
88	MSTAV	☐	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	TVMS
89	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
90	MSTDV	☐	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
91	TAKLV	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	TSKM
92	RBNRM	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
93	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
94	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
95	MHDLP	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
96	INHME	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
97	INHAL	☐	INHAL	MENG13	QUAN	13	3	Net contents
98	VPREH	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
99	ETIAG	☐	ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	TWEA
100	INHBR	☐	INHBR	MENG13	QUAN	13	3	Gross contents
101	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
102	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
103	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
104	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	T190S
105	SPROF	☐	SPROF	SPROF	CHAR	1	0	Pricing profile for variants
106	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
107	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
108	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
109	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
110	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	TMPPF
111	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
112	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
113	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
114	IHIVI	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
115	ILOOS	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
116	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
117	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
118	XGCHP	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
119	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
120	COMPL	☐	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	TCSCP_COMP_LVL
121	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
122	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
123	PRZUS	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
124	MTPOS_MARA	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	TPTM
125	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
126	MATFI	☐	MATFI	XFELD	CHAR	1	0	Material Is Locked
127	CMREL	☐	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
128	BBTYP	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type
129	SLED_BBD	☐	SLED_BBD	SLED_BBD	CHAR	1	0	Expiration Date
130	GTIN_VARIANT	☐	GTIN_VARIANT	GTIN_VARIANT	CHAR	2	0	Global Trade Item Number Variant
131	GENNR	☐	WSTR_SATNR_PP	MATNR	CHAR	18	0	Material Number of the Generic Material in Prepack Materials	MARA
132	RMATP	☐	PL_RMATP	MATNR	CHAR	18	0	Reference material for materials packed in same way	MARA
133	GDS_RELEVANT	☐	GDS_RELEVANT	XFELD	CHAR	1	0	Indicator: Global Data Synchronization-Relevant
134	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
135	HUTYP_DFLT	☐	CIFHUTYPDF	CHAR4	CHAR	4	0	Standard HU Type	THUTYP
136	PILFERABLE	☐	CIFPILFRBL	XFELD	CHAR	1	0	Pilferable
137	WHSTC	☐	CIFWHSTC	CHAR2	CHAR	2	0	Warehouse Storage Condition	TWHSTC
138	WHMATGR	☐	CIFWHMATGR	CHAR4	CHAR	4	0	Warehouse Material Group	TWHMATGR
139	HNDLCODE	☐	CIFHDLCODE	CHAR4	CHAR	4	0	Handling Indicator	THNDLCD
140	HAZMAT	☐	CIFHAZMAT	XFELD	CHAR	1	0	Relevant for Hazardous Substances
141	HUTYP	☐	CIFHUTYP	CHAR4	CHAR	4	0	Handling Unit Type	THUTYP
142	TARE_VAR	☐	CIFTAREVAR	XFELD	CHAR	1	0	Variable Tare Weight
143	MAXC	☐	CIFMAXC	DECV15_3	DEC	15	3	Maximum Allowed Capacity of Packaging Material
144	MAXC_TOL	☐	CIFMAXCTOL	DEC2_1	DEC	3	1	Overcapacity Tolerance of the Handling Unit
145	MAXL	☐	CIFMAXL	CIFQUAN15	QUAN	15	3	Maximum Packing Length of Packaging Material
146	MAXB	☐	CIFMAXB	CIFQUAN15	QUAN	15	3	Maximum Packing Width of Packaging Material
147	MAXH	☐	CIFMAXH	CIFQUAN15	QUAN	15	3	Maximum Packing Height of Packaging Material
148	MAXDIM_UOM	☐	CIFMAXDUOM	MEINS	UNIT	3	0	Unit of Measure for Maximum Packing Length/Width/Height	T006
149	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
150	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
151	QQTIME	☐	CIFQQTIME		QUAN	3	0	Quarantine Period
152	QQTIMEUOM	☐	CIFQQTIMEUOM	MEINS	UNIT	3	0	Time Unit for Quarantine Period	T006
153	QGRP	☐	CIFQGRP	CIFQGRP	CHAR	4	0	Quality Inspection Group	TQGRP
154	SERIAL	☐	CIFSERIAL	CIFSERIAL	CHAR	4	0	Serial Number Profile	TSERIAL
155	PS_SMARTFORM	☐	CIFPSSFNAME	TDSFNAME	CHAR	30	0	Form Name	STXFADM
156	LOGUNIT	☐	CIFLOGUNIT	MEINS	UNIT	3	0	EWM CW: Logistics Unit of Measure	MARM
157	CWQREL	☐	CIFCWQREL	XFELD	CHAR	1	0	EWM CW: Material Is a Catch Weight Material
158	CWQPROC	☐	CIFCWQPROC	CIFCWQPROC	CHAR	2	0	EWM CW: Catch Weight Profile for Entering CW Quantity	TCWQPROC
159	CWQTOLGR	☐	CIFCWQTOLGR	CIFCWQTOLGR	CHAR	9	0	EWM-CW: Catch Weight Tolerance Group for EWM	TCWQTOLGR
160	ADPROF	☐	CIFADPROF	CIFADPROF	CHAR	3	0	Adjustment Profile	TAPROF
161	IPMIPPRODUCT	☐	CRM_PRODUCT_ID_IP	CRM_PRODUCT_ID	CHAR	40	0	ID for an Intellectual Property (CRM Product)
162	ALLOW_PMAT_IGNO	☐	WPM_ALLOW_PMAT_IGNO_MAT	XFELD	CHAR	1	0	Variant Price Allowed (for Material Master)
163	MEDIUM	☐	MEDIU	MEDIU	CHAR	6	0	Medium	T372M
164	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	TBAC_PHYSCOMM
165	ANIMAL_ORIGIN	☐	WRF_ANIMAL_ORIGIN_FLAG	WRF_ANIMAL_ORIGIN_FLAG	CHAR	1	0	Indicator: Contains Non-Textile Parts of Animal Origin
166	TEXTILE_COMP_IND	☐	WRF_TEXTL_COMP_IND	WRF_TEXTL_COMP_IND	CHAR	1	0	Indicator: New Textile Composition Function
167	ANP	☐	J_1BANP	J_1BANP	NUMC	9	0	ANP Code	J_1BTANP
168	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
169	/BEV1/LULDEGRP	☐	/BEV1/LULDEGRP	/BEV1/LULDEGRP	CHAR	3	0	Loading Unit Group: IS Beverage	/BEV1/LUT906
170	/BEV1/NESTRUCCAT	☐	/BEV1/NESTRUC_CAT	/BEV1/NESTRUC_CAT	CHAR	1	0	Structure Category for Material Relationship
171	/DSD/SL_TOLTYP	☐	/DSD/SL_TOLTYP_ID	/DSD/SL_TOLTYP_ID	CHAR	4	0	Tolerance Type ID	/DSD/SL_TGTYP
172	/DSD/SV_CNT_GRP	☐	/DSD/SV_COUNT_GROUP	/DSD/SV_COUNT_GROUP	CHAR	10	0	Counting Group	/DSD/SV_CNTGR
173	/DSD/VC_GROUP	☐	/DSD/VC_GROUP	/DSD/VC_GROUP	CHAR	6	0	DSD Grouping	/DSD/VC_GRP
174	/VSO/R_TILT_IND	☐	/VSO/M_TILT_IND	/VSO/M_XFIELD	CHAR	1	0	Material may be Tilted (Vehicle Space Optimization)
175	/VSO/R_STACK_IND	☐	/VSO/M_STACK_IND	/VSO/M_XFIELD	CHAR	1	0	Stacking not Allowed (VSO)
176	/VSO/R_BOT_IND	☐	/VSO/M_BOTTOM_IND	/VSO/M_XFIELD	CHAR	1	0	Bottom Layer (Vehicle Space Optimization)
177	/VSO/R_TOP_IND	☐	/VSO/M_TOP_IND	/VSO/M_XFIELD	CHAR	1	0	Top Layer (VSO)
178	/VSO/R_STACK_NO	☐	/VSO/M_STACK_NO	/VSO/M_STACK_NO	NUMC	3	0	Stacking Factor (Vehicle Space Optimization)
179	/VSO/R_PAL_IND	☐	/VSO/M_PALLET_IND	/VSO/M_XFIELD	CHAR	1	0	Load without Packaging Material (VSO)
180	/VSO/R_PAL_OVR_D	☐	/VSO/R_PAL_OVR_D	MENG13	QUAN	13	3	Permissible Overhang (Depth) of Packaging Material (VSO)
181	/VSO/R_PAL_OVR_W	☐	/VSO/R_PAL_OVR_W	MENG13	QUAN	13	3	Permissible Overhang (Width) of Shipping Material (VSO)
182	/VSO/R_PAL_B_HT	☐	/VSO/R_PAL_BIN_HGT	MENG13	QUAN	13	3	Maximum Stacking Height of the Packaging Material (VSO)
183	/VSO/R_PAL_MIN_H	☐	/VSO/R_PAL_MIN_HT	MENG13	QUAN	13	3	Minimum Stacking Height of the Packaging Material (VSO)
184	/VSO/R_TOL_B_HT	☐	/VSO/R_TOL_BIN_HT	MENG13	QUAN	13	3	Tolerance to Exceed the Max. Stacking Height (VSO)
185	/VSO/R_NO_P_GVH	☐	/VSO/M_ANZ_PER_GVH	/VSO/M_ANZ_PER_GVH	NUMC	2	0	Number of Materials for each Closed PKM (VSO)
186	/VSO/R_QUAN_UNIT	☐	/VSO/R_QUAN_UNIT	/VSO/R_QUAN_UNIT	UNIT	3	0	Unit of Measure Vehicle Space Optimization
187	/VSO/R_KZGVH_IND	☐	/VSO/M_KZGVH_IND	/VSO/M_XFIELD	CHAR	1	0	Closed Packaging Material Required (VSO)
188	PACKCODE	☐	CBUNE_PACODE	CBUND_PACOD	CHAR	10	0	Packaging Code	CCUNC121
189	DG_PACK_STATUS	☐	ADGE_DG_PACK_STATUS	CHAR10	CHAR	10	0	Dangerous Goods Packaging Status	TDG101
190	MCOND	☐	DFPS_MCOND	DFPS_MCOND	CHAR	1	0	Material Condition Management
191	RETDELC	☐	DFPS_RETDELC	DFPS_RETDELC	CHAR	1	0	Return Code
192	LOGLEV_RETO	☐	DFPS_LOGLEV_RETO	DFPS_LOGLEV	CHAR	1	0	Return to Logistics Level
193	NSNID	☐	DFPS_NSNID	DFPS_NSNID	CHAR	9	0	NATO Stock Number
194	IMATN	☐	IMATN	MATNR	CHAR	18	0	FFF class
195	PICNUM	☐	PIC_PICNUM_SUS	PIC_PICNUM	CHAR	18	0	Supersession chain number
196	BSTAT	☐	WRFBSTAT	WRFBSTAT	CHAR	2	0	Creation Status - Seasonal Procurement	WRFMATBSTAT
197	COLOR_ATINN	☐	WRF_COLOR_ATINN	ATINN	NUMC	10	0	Internal Charactieristic Number for Color Characteristics
198	SIZE1_ATINN	☐	WRF_SIZE1_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Main Sizes
199	SIZE2_ATINN	☐	WRF_SIZE2_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Second Sizes
200	COLOR	☐	WRF_COLOR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Colors of Variants
201	SIZE1	☐	WRF_SIZE1	WRF_ATWRT	CHAR	18	0	Characteristic Value for Main Sizes of Variants
202	SIZE2	☐	WRF_SIZE2	WRF_ATWRT	CHAR	18	0	Characteristic Value for Second Size for Variants
203	FREE_CHAR	☐	WRF_FREE_CHAR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Evaluation Purposes
204	CARE_CODE	☐	WRF_CARE_CODE	WRF_CARE_CODE	CHAR	16	0	Care Codes (such as Washing Code, Ironing Code, etc.)
205	BRAND_ID	☐	WRF_BRAND_ID	WRF_BRAND_ID	CHAR	4	0	Brand	WRF_BRANDS
206	FIBER_CODE1	☐	WRF_FIBER_CODE_1	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 1)	WRF_FIBER_CODES
207	FIBER_PART1	☐	WRF_FIBER_PART_1	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 1)
208	FIBER_CODE2	☐	WRF_FIBER_CODE_2	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 2)	WRF_FIBER_CODES
209	FIBER_PART2	☐	WRF_FIBER_PART_2	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 2)
210	FIBER_CODE3	☐	WRF_FIBER_CODE_3	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 3)	WRF_FIBER_CODES
211	FIBER_PART3	☐	WRF_FIBER_PART_3	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 3)
212	FIBER_CODE4	☐	WRF_FIBER_CODE_4	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 4)	WRF_FIBER_CODES
213	FIBER_PART4	☐	WRF_FIBER_PART_4	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 4)
214	FIBER_CODE5	☐	WRF_FIBER_CODE_5	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 5)	WRF_FIBER_CODES
215	FIBER_PART5	☐	WRF_FIBER_PART_5	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 5)
216	FASHGRD	☐	FASHGRD	FASHGRD	CHAR	4	0	Fashion Grade	T6WFG
217	MATNR_INT	☐	MATNR_INT	MATNR_INT	CHAR	18	0	Material Number
218	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
219	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number
220	MATNR_GUID	☐	MATNR_IGUID	SYSUUID	RAW	16	0	Material Number (Internal GUID)
221	MATNR_TYPE	☐	MATNR_TYPE	MATNR_TYPE	CHAR	1	0	Material Number Type
222	MATNR_HEAD	☐	MATNR_HEAD	MATNR_INT	CHAR	18	0	Header Material for Version
223	SPTYP	☐	MGV_SPEC_TYPE	MGV_SPEC_TYPE	CHAR	10	0	Specialization Category
224	MATNR_SEL	☐	MATNR_SEL		CHAR	51	0	External Material Number Plus Version for Selection

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGVMARA_ALL	/BEV1/LULDEGRP	/BEV1/LUT906	/BEV1/LULDEGRP
2	MGVMARA_ALL	/DSD/SL_TOLTYP	/DSD/SL_TGTYP	TOLTYP_ID	KEY	1	CN
3	MGVMARA_ALL	/DSD/SV_CNT_GRP	/DSD/SV_CNTGR	COUNT_GROUP	KEY
4	MGVMARA_ALL	/DSD/VC_GROUP	/DSD/VC_GRP	GRP	KEY	1	CN
5	MGVMARA_ALL	ADPROF	TAPROF	ADPROF
6	MGVMARA_ALL	ANP	J_1BTANP	J_1BANP	KEY
7	MGVMARA_ALL	BEHVO	T144	BEHVO	REF	C	CN
8	MGVMARA_ALL	BMATN	MARA	MATNR
9	MGVMARA_ALL	BRAND_ID	WRF_BRANDS	BRAND_ID
10	MGVMARA_ALL	BSTAT	WRFMATBSTAT	BSTAT
11	MGVMARA_ALL	BSTME	T006	MSEHI	REF	C	CN
12	MGVMARA_ALL	BWSCL	TMBW1	BWSCL	REF	1	CN
13	MGVMARA_ALL	BWVOR	T6WP1	BWVOR	REF
14	MGVMARA_ALL	COMMODITY	TBAC_PHYSCOMM	COMMODITY	REF
15	MGVMARA_ALL	COMPL	TCSCP_COMP_LVL	COMP_LEVEL
16	MGVMARA_ALL	CWQPROC	TCWQPROC	CWQPROC	KEY	1	N
17	MGVMARA_ALL	CWQTOLGR	TCWQTOLGR	CWQTOLGR	KEY	1	N
18	MGVMARA_ALL	DG_PACK_STATUS	TDG101	DG_PACK_STATUS		1	CN
19	MGVMARA_ALL	EKWSL	T405	EKWSL	REF	C	CN
20	MGVMARA_ALL	ERGEI	T006	MSEHI	REF	C	CN
21	MGVMARA_ALL	ERVOE	T006	MSEHI	REF	C	CN
22	MGVMARA_ALL	ETIAG	TWEA	ARTGR
23	MGVMARA_ALL	ETIAR	T6WP3	ETIAR	REF	C	CN
24	MGVMARA_ALL	ETIFO	T6WP4	ETIFO	REF	C	CN
25	MGVMARA_ALL	EXTWG	TWEW	EXTWG
26	MGVMARA_ALL	FASHGRD	T6WFG	FASHGRD
27	MGVMARA_ALL	FIBER_CODE1	WRF_FIBER_CODES	FIBER_CODE
28	MGVMARA_ALL	FIBER_CODE2	WRF_FIBER_CODES	FIBER_CODE
29	MGVMARA_ALL	FIBER_CODE3	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
30	MGVMARA_ALL	FIBER_CODE4	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
31	MGVMARA_ALL	FIBER_CODE5	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
32	MGVMARA_ALL	GENNR	MARA	MATNR
33	MGVMARA_ALL	GEWEI	T006	MSEHI	REF	C	CN
34	MGVMARA_ALL	HERKL	T005	LAND1	REF
35	MGVMARA_ALL	HNDLCODE	THNDLCD	HNDLCODE	REF
36	MGVMARA_ALL	HUTYP	THUTYP	HUTYP	REF
37	MGVMARA_ALL	HUTYP_DFLT	THUTYP	HUTYP
38	MGVMARA_ALL	INHME	T006	MSEHI
39	MGVMARA_ALL	KOSCH	T190S	KOSCH
40	MGVMARA_ALL	KUNNR	V_KNA1WETT	KUNNR	REF	C	CN
41	MGVMARA_ALL	LABOR	T024L	LABOR	REF	C	CN
42	MGVMARA_ALL	LOGUNIT	MARM	MEINH	KEY	1	N
43	MGVMARA_ALL	MAGRV	TVEGR	MAGRV
44	MGVMARA_ALL	MANDT	T000	MANDT	KEY	1	CN
45	MGVMARA_ALL	MATKL	T023	MATKL	REF	C	CN
46	MGVMARA_ALL	MAXDIM_UOM	T006	MSEHI	REF
47	MGVMARA_ALL	MBRSH	T137	MBRSH	REF	C	CN
48	MGVMARA_ALL	MEABM	T006	MSEHI	REF	C	CN
49	MGVMARA_ALL	MEDIUM	T372M	MEDIU
50	MGVMARA_ALL	MEINS	T006	MSEHI	REF	1	CN
51	MGVMARA_ALL	MFRGR	TMFG	MFRGR	REF
52	MGVMARA_ALL	MFRNR	LFA1	LIFNR
53	MGVMARA_ALL	MPROF	TMPPF	MPROF
54	MGVMARA_ALL	MSTAE	T141	MMSTA
55	MGVMARA_ALL	MSTAV	TVMS	VMSTA
56	MGVMARA_ALL	MTART	T134	MTART	REF	1	CN
57	MGVMARA_ALL	MTPOS_MARA	TPTM	MTPOS
58	MGVMARA_ALL	NUMTP	TNTP	NUMTP	REF	C	CN
59	MGVMARA_ALL	PACKCODE	CCUNC121	PACKCODE		1	CN
60	MGVMARA_ALL	PLGTP	TWPT	PLGTP
61	MGVMARA_ALL	PMATA	MARA	MATNR
62	MGVMARA_ALL	PRDHA	T179	PRODH	REF	C	CN
63	MGVMARA_ALL	PROFL	TDG41	PROFL
64	MGVMARA_ALL	PS_SMARTFORM	STXFADM	FORMNAME	REF
65	MGVMARA_ALL	QGRP	TQGRP	QGRP	REF
66	MGVMARA_ALL	QQTIMEUOM	T006	MSEHI	REF
67	MGVMARA_ALL	RAUBE	T142	RAUBE	REF	C	CN
68	MGVMARA_ALL	RBNRM	T352B	RBNR
69	MGVMARA_ALL	RMATP	MARA	MATNR
70	MGVMARA_ALL	SAISO	T6WSP	SAISO	REF	C	CN
71	MGVMARA_ALL	SAITY	T6WSA	SAITY
72	MGVMARA_ALL	SATNR	MARA	MATNR
73	MGVMARA_ALL	SERIAL	TSERIAL	SERIAL	REF
74	MGVMARA_ALL	SPART	TSPA	SPART	REF	C	CN
75	MGVMARA_ALL	STOFF	MGEF	STOFF
76	MGVMARA_ALL	TAKLV	TSKM	TAXKM
77	MGVMARA_ALL	TEMPB	T143	TEMPB	REF	C	CN
78	MGVMARA_ALL	TRAGR	TTGR	TRAGR	REF	C	CN
79	MGVMARA_ALL	VHART	TVTY	TRATY
80	MGVMARA_ALL	VOLEH	T006	MSEHI	REF	C	CN
81	MGVMARA_ALL	WHMATGR	TWHMATGR	WHMATGR	REF
82	MGVMARA_ALL	WHSTC	TWHSTC	WHSTC	REF
83	MGVMARA_ALL	WRKST	TWSPR	WRKST

History

Last changed by/on	SAP	20140121
SAP Release Created in