	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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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

228 COLUMNS | 6 INDEXES | ERP 6.0 | MMARA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components
1	ERP EHP7	6.0	MMARA	228	6	General material data	Cross-Application Components

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 MMARA

TOP ERP 6.0 | MMARA COLUMNS

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

TOP ERP 6.0 | MMARA INDEXES

Name	Primary	Unique	Type	Columns
MMARA~0	Yes	Yes	CLUSTERED	MATNR, MANDT
MMARA~A	No	No	NONCLUSTERED	BISMT, MANDT
MMARA~L	No	No	NONCLUSTERED	MATKL, MANDT
MMARA~O	No	No	NONCLUSTERED	SATNR, MANDT
MMARA~PMA	No	No	NONCLUSTERED	PMATA, MANDT
MMARA~T	No	No	NONCLUSTERED	MTART, 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 | 6 INDEXES | ERP 6.0 | MMARA TABLE

TOP ERP 6.0 | MMARA COLUMNS

TOP ERP 6.0 | MMARA 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 | 6 INDEXES | ERP 6.0 | MMARA TABLE

TOPERP 6.0 | MMARA COLUMNS

TOPERP 6.0 | MMARA INDEXES

TOP ERP 6.0 | MMARA COLUMNS

TOP ERP 6.0 | MMARA INDEXES