	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

238 COLUMNS | 7 INDEXES | ERP 6.0 | MARC TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Logistics Basic Data :: Material Master
1	ERP EHP7	6.0	MARC	238	7	Plant Data for Material	Material Master

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, OITAXGRP, OIOILCON, OIEDCODE, FDICH, COEFF FROM MARC

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

TOP ERP 6.0 | MARC INDEXES

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

238 COLUMNS | 7 INDEXES | ERP 6.0 | MARC TABLE

TOP ERP 6.0 | MARC COLUMNS

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

238 COLUMNS | 7 INDEXES | ERP 6.0 | MARC TABLE

TOPERP 6.0 | MARC COLUMNS

TOPERP 6.0 | MARC INDEXES

TOP ERP 6.0 | MARC COLUMNS

TOP ERP 6.0 | MARC INDEXES