	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

228 COLUMNS | 1 INDEXES | ERP 6.0 | MVRA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Logistics Basic Data :: Material Master
1	ERP EHP7	6.0	MVRA	228	1	Cross-version fields for MARA	Material Master

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, MATNR, ERSDA, ERNAM, LAEDA, AENAM, VPSTA, PSTAT, LVORM, MTART, MBRSH, MATKL, BISMT, MEINS, BSTME, ZEINR, ZEIAR, ZEIVR, ZEIFO, AESZN, BLATT, BLANZ, FERTH, FORMT, GROES, WRKST, NORMT, LABOR, EKWSL, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, BEHVO, RAUBE, TEMPB, DISST, TRAGR, STOFF, SPART, KUNNR, EANNR, WESCH, BWVOR, BWSCL, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, XCHPF, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, KZKUP, KZNFM, PMATA, MSTAE, MSTAV, MSTDE, MSTDV, TAKLV, RBNRM, MHDRZ, MHDHB, MHDLP, INHME, INHAL, VPREH, ETIAG, INHBR, CMETH, CUOBF, KZUMW, KOSCH, SPROF, NRFHG, MFRPN, MFRNR, BMATN, MPROF, KZWSM, SAITY, PROFL, IHIVI, ILOOS, SERLV, KZGVH, XGCHP, KZEFF, COMPL, IPRKZ, RDMHD, PRZUS, MTPOS_MARA, BFLME, MATFI, CMREL, BBTYP, SLED_BBD, GTIN_VARIANT, GENNR, RMATP, GDS_RELEVANT, WEORA, HUTYP_DFLT, PILFERABLE, WHSTC, WHMATGR, HNDLCODE, HAZMAT, HUTYP, TARE_VAR, MAXC, MAXC_TOL, MAXL, MAXB, MAXH, MAXDIM_UOM, HERKL, MFRGR, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, ADPROF, IPMIPPRODUCT, ALLOW_PMAT_IGNO, MEDIUM, COMMODITY, ANIMAL_ORIGIN, TEXTILE_COMP_IND, SGT_CSGR, SGT_COVSA, SGT_STAT, SGT_SCOPE, SGT_REL, ANP, FSH_MG_AT1, FSH_MG_AT2, FSH_MG_AT3, FSH_SEALV, FSH_SEAIM, FSH_SC_MID, /BEV1/LULEINH, /BEV1/LULDEGRP, /BEV1/NESTRUCCAT, /DSD/SL_TOLTYP, /DSD/SV_CNT_GRP, /DSD/VC_GROUP, /VSO/R_TILT_IND, /VSO/R_STACK_IND, /VSO/R_BOT_IND, /VSO/R_TOP_IND, /VSO/R_STACK_NO, /VSO/R_PAL_IND, /VSO/R_PAL_OVR_D, /VSO/R_PAL_OVR_W, /VSO/R_PAL_B_HT, /VSO/R_PAL_MIN_H, /VSO/R_TOL_B_HT, /VSO/R_NO_P_GVH, /VSO/R_QUAN_UNIT, /VSO/R_KZGVH_IND, PACKCODE, DG_PACK_STATUS, MCOND, RETDELC, LOGLEV_RETO, NSNID, ADSPC_SPC, IMATN, PICNUM, BSTAT, COLOR_ATINN, SIZE1_ATINN, SIZE2_ATINN, COLOR, SIZE1, SIZE2, FREE_CHAR, CARE_CODE, BRAND_ID, FIBER_CODE1, FIBER_PART1, FIBER_CODE2, FIBER_PART2, FIBER_CODE3, FIBER_PART3, FIBER_CODE4, FIBER_PART4, FIBER_CODE5, FIBER_PART5, FASHGRD FROM MVRA

TOP ERP 6.0 | MVRA COLUMNS

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

TOP ERP 6.0 | MVRA INDEXES

Name	Primary	Unique	Type	Columns
MVRA~0	Yes	Yes	CLUSTERED	MATNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

228 COLUMNS | 1 INDEXES | ERP 6.0 | MVRA TABLE

TOP ERP 6.0 | MVRA COLUMNS

TOP ERP 6.0 | MVRA INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

228 COLUMNS | 1 INDEXES | ERP 6.0 | MVRA TABLE

TOPERP 6.0 | MVRA COLUMNS

TOPERP 6.0 | MVRA INDEXES

TOP ERP 6.0 | MVRA COLUMNS

TOP ERP 6.0 | MVRA INDEXES