	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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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

233 COLUMNS | 6 INDEXES | ERP 6.0 | MMARC TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components
1	ERP EHP7	6.0	MMARC	233	6	Plant Data for Material	Cross-Application Components

SQL: selectupdate insert create

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

SELECT MANDT, MATNR, WERKS, PSTAT, LVORM, BWTTY, XCHAR, MMSTA, MMSTD, MAABC, KZKRI, EKGRP, AUSME, DISPR, DISMM, DISPO, KZDIE, PLIFZ, WEBAZ, PERKZ, AUSSS, DISLS, BESKZ, SOBSL, MINBE, EISBE, BSTMI, BSTMA, BSTFE, BSTRF, MABST, LOSFX, SBDKZ, LAGPR, ALTSL, KZAUS, AUSDT, NFMAT, KZBED, MISKZ, FHORI, PFREI, FFREI, RGEKZ, FEVOR, BEARZ, RUEZT, TRANZ, BASMG, DZEIT, MAXLZ, LZEIH, KZPRO, GPMKZ, UEETO, UEETK, UNETO, WZEIT, ATPKZ, VZUSL, HERBL, INSMK, SPROZ, QUAZT, SSQSS, MPDAU, KZPPV, KZDKZ, WSTGH, PRFRQ, NKMPR, UMLMC, LADGR, XCHPF, USEQU, LGRAD, AUFTL, PLVAR, OTYPE, OBJID, MTVFP, PERIV, KZKFK, VRVEZ, VBAMG, VBEAZ, LIZYK, BWSCL, KAUTB, KORDB, STAWN, HERKL, HERKR, EXPME, MTVER, PRCTR, TRAME, MRPPP, SAUFT, FXHOR, VRMOD, VINT1, VINT2, VERKZ, STLAL, STLAN, PLNNR, APLAL, LOSGR, SOBSK, FRTME, LGPRO, DISGR, KAUSF, QZGTP, QMATV, TAKZT, RWPRO, COPAM, ABCIN, AWSLS, SERNP, CUOBJ, STDPD, SFEPR, XMCNG, QSSYS, LFRHY, RDPRF, VRBMT, VRBWK, VRBDT, VRBFK, AUTRU, PREFE, PRENC, PRENO, PREND, PRENE, PRENG, ITARK, SERVG, KZKUP, STRGR, CUOBV, LGFSB, SCHGT, CCFIX, EPRIO, QMATA, RESVP, PLNTY, UOMGR, UMRSL, ABFAC, SFCPF, SHFLG, SHZET, MDACH, KZECH, MEGRU, MFRGR, VKUMC, VKTRW, KZAGL, FVIDK, FXPRU, LOGGR, FPRFM, GLGMG, VKGLG, INDUS, MOWNR, MOGRU, CASNR, GPNUM, STEUC, FABKZ, MATGR, VSPVB, DPLFS, DPLPU, DPLHO, MINLS, MAXLS, FIXLS, LTINC, COMPL, CONVT, SHPRO, AHDIS, DIBER, KZPSP, OCMPF, APOKZ, MCRUE, LFMON, LFGJA, EISLO, NCOST, ROTATION_DATE, UCHKZ, UCMAT, BWESB, SGT_COVS, SGT_STATC, SGT_SCOPE, SGT_MRPSI, SGT_PRCM, SGT_CHINT, SGT_STK_PRT, SGT_DEFSC, FSH_MG_ARUN_REQ, FSH_SEAIM, /MRSS/PROF_GUID, /MRSS/PROF_KEY, /MRSS/DATACHANGE, /SAPMP/TOLPRPL, /SAPMP/TOLPRMI, /VSO/R_PKGRP, /VSO/R_LANE_NUM, /VSO/R_PAL_VEND, /VSO/R_FORK_DIR, IUID_RELEVANT, IUID_TYPE, UID_IEA, CONS_PROCG, GI_PR_TIME, MULTIPLE_EKGRP, REF_SCHEMA, MIN_TROC, MAX_TROC, TARGET_STOCK FROM MMARC

TOP ERP 6.0 | MMARC 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	WERKS	Plant	nvarchar	4	0	Allow NULL?
4	PSTAT	Maintenance status	nvarchar	15	0	Allow NULL?
5	LVORM	Flag Material for Deletion at Plant Level	char	1	0	Allow NULL?
6	BWTTY	Valuation Category	char	1	0	Allow NULL?
7	XCHAR	Batch management indicator (internal)	char	1	0	Allow NULL?
8	MMSTA	Plant-Specific Material Status	nvarchar	2	0	Allow NULL?
9	MMSTD	Date from which the plant-specific material status is valid	nvarchar	8	0	Allow NULL?
10	MAABC	ABC Indicator	char	1	0	Allow NULL?
11	KZKRI	Indicator: Critical part	char	1	0	Allow NULL?
12	EKGRP	Purchasing Group	nvarchar	3	0	Allow NULL?
13	AUSME	Unit of issue	nvarchar	3	0	Allow NULL?
14	DISPR	Material: MRP profile	nvarchar	4	0	Allow NULL?
15	DISMM	MRP Type	nvarchar	2	0	Allow NULL?
16	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	Allow NULL?
17	KZDIE	Indicator: MRP controller is buyer (deactivated)	char	1	0	Allow NULL?
18	PLIFZ	Planned Delivery Time in Days	decimal	3	0
19	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0
20	PERKZ	Period Indicator	char	1	0	Allow NULL?
21	AUSSS	Assembly scrap in percent	decimal	5	2
22	DISLS	Lot size (materials planning)	nvarchar	2	0	Allow NULL?
23	BESKZ	Procurement Type	char	1	0	Allow NULL?
24	SOBSL	Special procurement type	nvarchar	2	0	Allow NULL?
25	MINBE	Reorder Point	decimal	13	3
26	EISBE	Safety Stock	decimal	13	3
27	BSTMI	Minimum Lot Size	decimal	13	3
28	BSTMA	Maximum Lot Size	decimal	13	3
29	BSTFE	Fixed lot size	decimal	13	3
30	BSTRF	Rounding value for purchase order quantity	decimal	13	3
31	MABST	Maximum stock level	decimal	13	3
32	LOSFX	Ordering costs	decimal	11	2
33	SBDKZ	Dependent requirements ind. for individual and coll. reqmts	char	1	0	Allow NULL?
34	LAGPR	Storage costs indicator	char	1	0	Allow NULL?
35	ALTSL	Method for Selecting Alternative Bills of Material	char	1	0	Allow NULL?
36	KZAUS	Discontinuation indicator	char	1	0	Allow NULL?
37	AUSDT	Effective-Out Date	nvarchar	8	0	Allow NULL?
38	NFMAT	Follow-Up Material	nvarchar	18	0	Allow NULL?
39	KZBED	Indicator for Requirements Grouping	char	1	0	Allow NULL?
40	MISKZ	Mixed MRP indicator	char	1	0	Allow NULL?
41	FHORI	Scheduling Margin Key for Floats	nvarchar	3	0	Allow NULL?
42	PFREI	Indicator: automatic fixing of planned orders	char	1	0	Allow NULL?
43	FFREI	Release indicator for production orders	char	1	0	Allow NULL?
44	RGEKZ	Indicator: Backflush	char	1	0	Allow NULL?
45	FEVOR	Production Supervisor	nvarchar	3	0	Allow NULL?
46	BEARZ	Processing time	decimal	5	2
47	RUEZT	Setup and teardown time	decimal	5	2
48	TRANZ	Interoperation time	decimal	5	2
49	BASMG	Base quantity	decimal	13	3
50	DZEIT	In-house production time	decimal	3	0
51	MAXLZ	Maximum Storage Period	decimal	5	0
52	LZEIH	Unit for maximum storage period	nvarchar	3	0	Allow NULL?
53	KZPRO	Indicator: withdrawal of stock from production bin	char	1	0	Allow NULL?
54	GPMKZ	Indicator: Material Included in Rough-Cut Planning	char	1	0	Allow NULL?
55	UEETO	Overdelivery tolerance limit	decimal	3	1
56	UEETK	Indicator: Unlimited Overdelivery Allowed	char	1	0	Allow NULL?
57	UNETO	Underdelivery tolerance limit	decimal	3	1
58	WZEIT	Total replenishment lead time (in workdays)	decimal	3	0
59	ATPKZ	Replacement part	char	1	0	Allow NULL?
60	VZUSL	Surcharge factor for cost in percent	decimal	5	2
61	HERBL	State of manufacture	nvarchar	2	0	Allow NULL?
62	INSMK	Post to Inspection Stock	char	1	0	Allow NULL?
63	SPROZ	Sample for quality inspection (in %) (deactivated)	decimal	3	1
64	QUAZT	Quarantine period (deactivated)	decimal	3	0
65	SSQSS	Control Key for Quality Management in Procurement	nvarchar	8	0	Allow NULL?
66	MPDAU	Mean inspection duration (deactivated)	decimal	5	0
67	KZPPV	Indicator for inspection plan (deactivated)	char	1	0	Allow NULL?
68	KZDKZ	Documentation required indicator	char	1	0	Allow NULL?
69	WSTGH	Active substance content (deactivated)	decimal	9	0
70	PRFRQ	Interval until next recurring inspection	decimal	5	0
71	NKMPR	Date according to check sampling inspection (deactivated)	nvarchar	8	0	Allow NULL?
72	UMLMC	Stock in Transfer (Plant to Plant)	decimal	13	3
73	LADGR	Loading Group	nvarchar	4	0	Allow NULL?
74	XCHPF	Batch management requirement indicator	char	1	0	Allow NULL?
75	USEQU	Quota arrangement usage	char	1	0	Allow NULL?
76	LGRAD	Service level	decimal	3	1
77	AUFTL	Splitting Indicator	char	1	0	Allow NULL?
78	PLVAR	Plan Version	nvarchar	2	0	Allow NULL?
79	OTYPE	Object Type	nvarchar	2	0	Allow NULL?
80	OBJID	Object ID	nvarchar	8	0	Allow NULL?
81	MTVFP	Checking Group for Availability Check	nvarchar	2	0	Allow NULL?
82	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
83	KZKFK	Indicator: take correction factors into account	char	1	0	Allow NULL?
84	VRVEZ	Shipping setup time	decimal	5	2
85	VBAMG	Base quantity for capacity planning in shipping	decimal	13	3
86	VBEAZ	Shipping processing time	decimal	5	2
87	LIZYK	Deactivated	nvarchar	4	0	Allow NULL?
88	BWSCL	Source of Supply	char	1	0	Allow NULL?
89	KAUTB	Indicator: "automatic purchase order allowed"	char	1	0	Allow NULL?
90	KORDB	Indicator: Source list requirement	char	1	0	Allow NULL?
91	STAWN	Commodity Code/Import Code Number for Foreign Trade	nvarchar	17	0	Allow NULL?
92	HERKL	Country of origin of the material	nvarchar	3	0	Allow NULL?
93	HERKR	Region of origin of material (non-preferential origin)	nvarchar	3	0	Allow NULL?
94	EXPME	Unit of measure for commodity code (foreign trade)	nvarchar	3	0	Allow NULL?
95	MTVER	Export/import material group	nvarchar	4	0	Allow NULL?
96	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
97	TRAME	Stock in Transit	decimal	13	3
98	MRPPP	PPC planning calendar	nvarchar	3	0	Allow NULL?
99	SAUFT	Ind.: Repetitive mfg allowed	char	1	0	Allow NULL?
100	FXHOR	Planning time fence	nvarchar	3	0	Allow NULL?
101	VRMOD	Consumption mode	char	1	0	Allow NULL?
102	VINT1	Consumption period: backward	nvarchar	3	0	Allow NULL?
103	VINT2	Consumption period: forward	nvarchar	3	0	Allow NULL?
104	VERKZ	Version Indicator	char	1	0	Allow NULL?
105	STLAL	Alternative BOM	nvarchar	2	0	Allow NULL?
106	STLAN	BOM Usage	char	1	0	Allow NULL?
107	PLNNR	Key for Task List Group	nvarchar	8	0	Allow NULL?
108	APLAL	Group Counter	nvarchar	2	0	Allow NULL?
109	LOSGR	Lot Size for Product Costing	decimal	13	3
110	SOBSK	Special Procurement Type for Costing	nvarchar	2	0	Allow NULL?
111	FRTME	Production unit	nvarchar	3	0	Allow NULL?
112	LGPRO	Issue Storage Location	nvarchar	4	0	Allow NULL?
113	DISGR	MRP Group	nvarchar	4	0	Allow NULL?
114	KAUSF	Component scrap in percent	decimal	5	2
115	QZGTP	Certificate Type	nvarchar	4	0	Allow NULL?
116	QMATV	Inspection Setup Exists for Material/Plant	char	1	0	Allow NULL?
117	TAKZT	Takt time	decimal	3	0
118	RWPRO	Range of coverage profile	nvarchar	3	0	Allow NULL?
119	COPAM	Local field name for CO/PA link to SOP	nvarchar	10	0	Allow NULL?
120	ABCIN	Physical inventory indicator for cycle counting	char	1	0	Allow NULL?
121	AWSLS	Variance Key	nvarchar	6	0	Allow NULL?
122	SERNP	Serial Number Profile	nvarchar	4	0	Allow NULL?
123	CUOBJ	Internal object number	nvarchar	18	0	Allow NULL?
124	STDPD	Configurable material	nvarchar	18	0	Allow NULL?
125	SFEPR	Repetitive manufacturing profile	nvarchar	4	0	Allow NULL?
126	XMCNG	Negative stocks allowed in plant	char	1	0	Allow NULL?
127	QSSYS	Required QM System for Vendor	nvarchar	4	0	Allow NULL?
128	LFRHY	Planning cycle	nvarchar	3	0	Allow NULL?
129	RDPRF	Rounding Profile	nvarchar	4	0	Allow NULL?
130	VRBMT	Reference material for consumption	nvarchar	18	0	Allow NULL?
131	VRBWK	Reference plant for consumption	nvarchar	4	0	Allow NULL?
132	VRBDT	To date of the material to be copied for consumption	nvarchar	8	0	Allow NULL?
133	VRBFK	Multiplier for reference material for consumption	decimal	4	2
134	AUTRU	Reset Forecast Model Automatically	char	1	0	Allow NULL?
135	PREFE	Preference indicator in export/import	char	1	0	Allow NULL?
136	PRENC	Exemption certificate: Indicator for legal control	char	1	0	Allow NULL?
137	PRENO	Exemption certificate number for legal control	nvarchar	8	0	Allow NULL?
138	PREND	Exemption certificate: Issue date of exemption certificate	nvarchar	8	0	Allow NULL?
139	PRENE	Indicator: Vendor declaration exists	char	1	0	Allow NULL?
140	PRENG	Validity date of vendor declaration	nvarchar	8	0	Allow NULL?
141	ITARK	Indicator: Military goods	char	1	0	Allow NULL?
142	SERVG	IS-R service level	char	1	0	Allow NULL?
143	KZKUP	Indicator: Material can be co-product	char	1	0	Allow NULL?
144	STRGR	Planning strategy group	nvarchar	2	0	Allow NULL?
145	CUOBV	Internal object number of configurable material for planning	nvarchar	18	0	Allow NULL?
146	LGFSB	Default storage location for external procurement	nvarchar	4	0	Allow NULL?
147	SCHGT	Indicator: Bulk Material	char	1	0	Allow NULL?
148	CCFIX	CC indicator is fixed	char	1	0	Allow NULL?
149	EPRIO	Stock determination group	nvarchar	4	0	Allow NULL?
150	QMATA	Material Authorization Group for Activities in QM	nvarchar	6	0	Allow NULL?
151	RESVP	Period of adjustment for planned independent requirements	decimal	3	0
152	PLNTY	Task List Type	char	1	0	Allow NULL?
153	UOMGR	Unit of Mearsure Group (Oil, Natural Gas,...)	nvarchar	3	0	Allow NULL?
154	UMRSL	Conversion Group (Oil, Natural Gas,..)	nvarchar	4	0	Allow NULL?
155	ABFAC	Air Bouyancy Factor	decimal	2	1
156	SFCPF	Production Scheduling Profile	nvarchar	6	0	Allow NULL?
157	SHFLG	Safety time indicator (with or without safety time)	char	1	0	Allow NULL?
158	SHZET	Safety time (in workdays)	nvarchar	2	0	Allow NULL?
159	MDACH	Action control: planned order processing	nvarchar	2	0	Allow NULL?
160	KZECH	Determination of batch entry in the production/process order	char	1	0	Allow NULL?
161	MEGRU	Unit of Measure Group	nvarchar	4	0	Allow NULL?
162	MFRGR	Material freight group	nvarchar	8	0	Allow NULL?
163	VKUMC	Stock transfer sales value (plant to plant) for VO material	decimal	13	2
164	VKTRW	Transit value at sales price for value-only material	decimal	13	2
165	KZAGL	Indicator: smooth promotion consumption	char	1	0	Allow NULL?
166	FVIDK	Production Version To Be Costed	nvarchar	4	0	Allow NULL?
167	FXPRU	Fixed-Price Co-Product	char	1	0	Allow NULL?
168	LOGGR	Logistics handling group for workload calculation	nvarchar	4	0	Allow NULL?
169	FPRFM	Distribution profile of material in plant	nvarchar	3	0	Allow NULL?
170	GLGMG	Tied Empties Stock	decimal	13	3
171	VKGLG	Sales value of tied empties stock	decimal	13	2
172	INDUS	Material CFOP category	nvarchar	2	0	Allow NULL?
173	MOWNR	CAP: Number of CAP products list	nvarchar	12	0	Allow NULL?
174	MOGRU	Common Agricultural Policy: CAP products group-Foreign Trade	nvarchar	6	0	Allow NULL?
175	CASNR	CAS number for pharmaceutical products in foreign trade	nvarchar	15	0	Allow NULL?
176	GPNUM	Production statistics: PRODCOM number for foreign trade	nvarchar	9	0	Allow NULL?
177	STEUC	Control code for consumption taxes in foreign trade	nvarchar	16	0	Allow NULL?
178	FABKZ	Indicator: Item Relevant to JIT Delivery Schedules	char	1	0	Allow NULL?
179	MATGR	Group of Materials for Transition Matrix	nvarchar	20	0	Allow NULL?
180	VSPVB	Proposed Supply Area in Material Master Record	nvarchar	10	0	Allow NULL?
181	DPLFS	Fair share rule	nvarchar	2	0	Allow NULL?
182	DPLPU	Indicator: push distribution	char	1	0	Allow NULL?
183	DPLHO	Deployment horizon in days	decimal	3	0
184	MINLS	Minimum lot size for Supply Demand Match	decimal	13	3
185	MAXLS	Maximum lot size for Supply Demand Match	decimal	13	3
186	FIXLS	Fixed lot size for Supply Demand Match	decimal	13	3
187	LTINC	Lot size increment for Supply Demand Match	decimal	13	3
188	COMPL	This field is no longer used	nvarchar	2	0	Allow NULL?
189	CONVT	Conversion types for production figures	nvarchar	2	0	Allow NULL?
190	SHPRO	Period Profile for Safety Time	nvarchar	3	0	Allow NULL?
191	AHDIS	MRP relevancy for dependent requirements	char	1	0	Allow NULL?
192	DIBER	Indicator: MRP area exists	char	1	0	Allow NULL?
193	KZPSP	Indicator for cross-project material	char	1	0	Allow NULL?
194	OCMPF	Overall profile for order change management	nvarchar	6	0	Allow NULL?
195	APOKZ	Indicator: Is material relevant for APO	char	1	0	Allow NULL?
196	MCRUE	MARDH rec. already exists for per. before last of MARD per.	char	1	0	Allow NULL?
197	LFMON	Current period (posting period)	nvarchar	2	0	Allow NULL?
198	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	Allow NULL?
199	EISLO	Minimum Safety Stock	decimal	13	3
200	NCOST	Do Not Cost	char	1	0	Allow NULL?
201	ROTATION_DATE	Strategy for Putaway and Stock Removal	char	1	0	Allow NULL?
202	UCHKZ	Indicator for Original Batch Management	char	1	0	Allow NULL?
203	UCMAT	Reference Material for Original Batches	nvarchar	18	0	Allow NULL?
204	BWESB	Valuated Goods Receipt Blocked Stock	decimal	13	3
205	SGT_COVS	Segmentation Strategy	nvarchar	8	0	Allow NULL?
206	SGT_STATC	Segmentation Status	char	1	0	Allow NULL?
207	SGT_SCOPE	Segmentation Strategy Scope	char	1	0	Allow NULL?
208	SGT_MRPSI	Sort Stock based on Segment	char	1	0	Allow NULL?
209	SGT_PRCM	Consumption Priority	char	1	0	Allow NULL?
210	SGT_CHINT	Discrete Batch Number	char	1	0	Allow NULL?
211	SGT_STK_PRT	Stock Protection Indicator	char	1	0	Allow NULL?
212	SGT_DEFSC	Default Stock Segment value	nvarchar	16	0	Allow NULL?
213	FSH_MG_ARUN_REQ	Order Allocation Run	char	1	0	Allow NULL?
214	FSH_SEAIM	Indicator: Season Active in Inventory Management	char	1	0	Allow NULL?
215	/MRSS/PROF_GUID	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	Allow NULL?
216	/MRSS/PROF_KEY	Profile Key	nvarchar	10	0	Allow NULL?
217	/MRSS/DATACHANGE	Data was changed in the controls on the user screen	char	1	0	Allow NULL?
218	/SAPMP/TOLPRPL	Percentage Tolerance Plus	decimal	3	1
219	/SAPMP/TOLPRMI	Percentage Tolerance Minus	decimal	3	1
220	/VSO/R_PKGRP	Packing Group of the Material (VSO)	nvarchar	18	0	Allow NULL?
221	/VSO/R_LANE_NUM	Line within the Automatic Picking Zone (VSO)	nvarchar	3	0	Allow NULL?
222	/VSO/R_PAL_VEND	Material No. of the Packaging Material of the Vendor (VSO)	nvarchar	18	0	Allow NULL?
223	/VSO/R_FORK_DIR	Pick Packaging Materials only Lengthwise (VSO)	char	1	0	Allow NULL?
224	IUID_RELEVANT	IUID-Relevant	char	1	0	Allow NULL?
225	IUID_TYPE	Structure Type of UII	nvarchar	10	0	Allow NULL?
226	UID_IEA	External Allocation of UII	char	1	0	Allow NULL?
227	CONS_PROCG	Consignment Control	char	1	0	Allow NULL?
228	GI_PR_TIME	Goods Issue Processing Time in Days	decimal	3	0
229	MULTIPLE_EKGRP	Purchasing Across Purchasing Group	char	1	0	Allow NULL?
230	REF_SCHEMA	Reference Determination Schema	nvarchar	2	0	Allow NULL?
231	MIN_TROC	Minimum Target Range of Coverage	nvarchar	3	0	Allow NULL?
232	MAX_TROC	Maximum Target Range of Coverage	nvarchar	3	0	Allow NULL?
233	TARGET_STOCK	Target Stock	decimal	13	3

TOP ERP 6.0 | MMARC INDEXES

Name	Primary	Unique	Type	Columns
MMARC~0	Yes	Yes	CLUSTERED	WERKS, MATNR, MANDT
MMARC~D	No	No	NONCLUSTERED	DISPR, MANDT
MMARC~NFM	No	No	NONCLUSTERED	NFMAT, MANDT
MMARC~STD	No	No	NONCLUSTERED	STDPD, MANDT
MMARC~VBM	No	No	NONCLUSTERED	VRBWK, VRBMT, MANDT
MMARC~WRK	No	No	NONCLUSTERED	WERKS, 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

233 COLUMNS | 6 INDEXES | ERP 6.0 | MMARC TABLE

TOP ERP 6.0 | MMARC COLUMNS

TOP ERP 6.0 | MMARC 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

233 COLUMNS | 6 INDEXES | ERP 6.0 | MMARC TABLE

TOPERP 6.0 | MMARC COLUMNS

TOPERP 6.0 | MMARC INDEXES

TOP ERP 6.0 | MMARC COLUMNS

TOP ERP 6.0 | MMARC INDEXES