	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

STG_MM001 TABLE

ERP EHP7

6.0

429

Data staging - Material master plant view complex table

SQL: selectupdate insert create

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

SELECT MANDT, DSF_GUID, DSF_DSTORE_ID, USER_GUID, DSF_RECORD_ID, DSF_CHANGED_BY, DSF_CHANGED_TS, MATNR, VPSTA, 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, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, 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, 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, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, /BEV1/LULEINH, /BEV1/LULDEGRP, /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, MCOND, RETDELC, LOGLEV_RETO, NSNID, 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, MAKTX, 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 /SMERP/STG_MM001

TOP ERP 6.0 | /SMERP/STG_MM001 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	DSF_GUID	DSF GUID	nvarchar	32	0	CHAR	(N' ')	No		/SMFND/DSF_GUID_DTE	Allow NULL?
3	DSF_DSTORE_ID	Data Store ID	nvarchar	40	0	CHAR	(N' ')	Yes	*	/SMFND/DSF_DSTORE_ID_DTE	Allow NULL?
4	USER_GUID	User GUID	nvarchar	32	0	CHAR	(N' ')	Yes		/SYCLO/CORE_USER_GUID_DTE	Allow NULL?
5	DSF_RECORD_ID	DSF Record ID	nvarchar	10	0	NUMC	(N'0000000000')	Yes		/SMFND/DSF_RECORD_ID_DTE	Allow NULL?
6	DSF_CHANGED_BY	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		/SYCLO/CORE_CHANGEDBY_DTE	Allow NULL?
7	DSF_CHANGED_TS	Changed time stamp	decimal	15	0	DEC	((0))	Yes		/SYCLO/CORE_CHANGEDTS_DTE
8	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
9	VPSTA	Maintenance status of complete material	nvarchar	15	0	CHAR	(N' ')	Yes		VPSTA	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	SAISO	Season Category	nvarchar	4	0	CHAR	(N' ')	Yes	T6WSP	SAISO	Allow NULL?
47	ETIAR	Label type	nvarchar	2	0	CHAR	(N' ')	Yes	T6WP3	ETIAR	Allow NULL?
48	ETIFO	Label form	nvarchar	2	0	CHAR	(N' ')	Yes	T6WP4	ETIFO	Allow NULL?
49	ENTAR	Deactivated	char	1	0	CHAR	(N' ')	Yes		DUMMYENTAR	Allow NULL?
50	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
51	NUMTP	Category of International Article Number (EAN)	nvarchar	2	0	CHAR	(N' ')	Yes	TNTP	NUMTP	Allow NULL?
52	LAENG	Length	decimal	13	3	QUAN	((0))	Yes		LAENG
53	BREIT	Width	decimal	13	3	QUAN	((0))	Yes		BREIT
54	HOEHE	Height	decimal	13	3	QUAN	((0))	Yes		HOEHE
55	MEABM	Unit of Dimension for Length/Width/Height	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEABM	Allow NULL?
56	PRDHA	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
57	AEKLK	Stock Transfer Net Change Costing	char	1	0	CHAR	(N' ')	Yes		CK_AEKLK	Allow NULL?
58	CADKZ	CAD Indicator	char	1	0	CHAR	(N' ')	Yes		CADKZ	Allow NULL?
59	QMPUR	QM in Procurement is Active	char	1	0	CHAR	(N' ')	Yes		QMPUR	Allow NULL?
60	ERGEW	Allowed packaging weight	decimal	13	3	QUAN	((0))	Yes		ERGEW
61	ERGEI	Unit of weight (allowed packaging weight)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERGEI	Allow NULL?
62	ERVOL	Allowed packaging volume	decimal	13	3	QUAN	((0))	Yes		ERVOL
63	ERVOE	Volume unit (allowed packaging volume)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERVOE	Allow NULL?
64	GEWTO	Excess Weight Tolerance for Handling unit	decimal	3	1	DEC	((0))	Yes		GEWTO
65	VOLTO	Excess Volume Tolerance of the Handling Unit	decimal	3	1	DEC	((0))	Yes		VOLTO
66	VABME	Variable Purchase Order Unit Active	char	1	0	CHAR	(N' ')	Yes		VABME	Allow NULL?
67	KZREV	Revision Level Has Been Assigned to the Material	char	1	0	CHAR	(N' ')	Yes		KZREV	Allow NULL?
68	KZKFG	Configurable Material	char	1	0	CHAR	(N' ')	Yes		KZKFG	Allow NULL?
69	VHART	Packaging Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVTY	VHIART	Allow NULL?
70	FUELG	Maximum level (by volume)	decimal	3	0	DEC	((0))	Yes		FUELG
71	STFAK	Stacking factor	smallint	5	0	INT2	((0))	Yes		STFAK
72	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	CHAR	(N' ')	Yes	TVEGR	MAGRV	Allow NULL?
73	BEGRU	Authorization Group	nvarchar	4	0	CHAR	(N' ')	Yes		BEGRU	Allow NULL?
74	DATAB	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATAB	Allow NULL?
75	LIQDT	Deletion date	nvarchar	8	0	DATS	(N'00000000')	Yes		LIQDT	Allow NULL?
76	SAISJ	Season Year	nvarchar	4	0	CHAR	(N' ')	Yes		SAISJ	Allow NULL?
77	PLGTP	Price Band Category	nvarchar	2	0	CHAR	(N' ')	Yes	TWPT	PLGTP	Allow NULL?
78	MLGUT	Empties Bill of Material	char	1	0	CHAR	(N' ')	Yes		W_MITLEERG	Allow NULL?
79	EXTWG	External Material Group	nvarchar	18	0	CHAR	(N' ')	Yes	TWEW	EXTWG	Allow NULL?
80	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	SATNR	Allow NULL?
81	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
82	KZNFM	Indicator: The material has a follow-up material	char	1	0	CHAR	(N' ')	Yes		KZNFM	Allow NULL?
83	PMATA	Pricing Reference Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PMATN	Allow NULL?
84	MSTAE	Cross-Plant Material Status	nvarchar	2	0	CHAR	(N' ')	Yes	T141	MSTAE	Allow NULL?
85	MSTAV	Cross-distribution-chain material status	nvarchar	2	0	CHAR	(N' ')	Yes	TVMS	MSTAV	Allow NULL?
86	MSTDE	Date from which the cross-plant material status is valid	nvarchar	8	0	DATS	(N'00000000')	Yes		MSTDE	Allow NULL?
87	MSTDV	Date from which the X-distr.-chain material status is valid	nvarchar	8	0	DATS	(N'00000000')	Yes		MSTDV	Allow NULL?
88	TAKLV	Tax classification of the material	char	1	0	CHAR	(N' ')	Yes	TSKM	TAKLV	Allow NULL?
89	RBNRM	Catalog Profile	nvarchar	9	0	CHAR	(N' ')	Yes	T352B	RBNR	Allow NULL?
90	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
91	MHDHB	Total shelf life	decimal	4	0	DEC	((0))	Yes		MHDHB
92	MHDLP	Storage percentage	decimal	3	0	DEC	((0))	Yes		MHDLP
93	INHME	Content unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	INHME	Allow NULL?
94	INHAL	Net contents	decimal	13	3	QUAN	((0))	Yes		INHAL
95	VPREH	Comparison price unit	decimal	5	0	DEC	((0))	Yes		VPREH
96	ETIAG	IS-R Labeling: material grouping (deactivated in 4.0)	nvarchar	18	0	CHAR	(N' ')	Yes	*	ETIAG	Allow NULL?
97	INHBR	Gross contents	decimal	13	3	QUAN	((0))	Yes		INHBR
98	CMETH	Quantity Conversion Method	char	1	0	CHAR	(N' ')	Yes		OIB_CMETH	Allow NULL?
99	CUOBF	Internal object number	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBM	Allow NULL?
100	KZUMW	Environmentally Relevant	char	1	0	CHAR	(N' ')	Yes		KZUMW	Allow NULL?
101	KOSCH	Product allocation determination procedure	nvarchar	18	0	CHAR	(N' ')	Yes	T190S	KOSCH	Allow NULL?
102	SPROF	Pricing profile for variants	char	1	0	CHAR	(N' ')	Yes		SPROF	Allow NULL?
103	NRFHG	Material qualifies for discount in kind	char	1	0	CHAR	(N' ')	Yes		NRFHG	Allow NULL?
104	MFRPN	Manufacturer Part Number	nvarchar	40	0	CHAR	(N' ')	Yes		MFRPN	Allow NULL?
105	MFRNR	Number of a Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	MFRNR	Allow NULL?
106	BMATN	Number of firm's own (internal) inventory-managed material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MPMAT	Allow NULL?
107	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	TMPPF	MPROF	Allow NULL?
108	KZWSM	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
109	SAITY	Rollout in a Season	nvarchar	2	0	CHAR	(N' ')	Yes	T6WSA	SAITY	Allow NULL?
110	PROFL	Dangerous Goods Indicator Profile	nvarchar	3	0	CHAR	(N' ')	Yes	TDG41	ADGE_PROFL	Allow NULL?
111	IHIVI	Indicator: Highly Viscous	char	1	0	CHAR	(N' ')	Yes		ADGE_IHIVI	Allow NULL?
112	ILOOS	Indicator: In Bulk/Liquid	char	1	0	CHAR	(N' ')	Yes		ADGE_ILOOS	Allow NULL?
113	SERLV	Level of Explicitness for Serial Number	char	1	0	CHAR	(N' ')	Yes		SERLV	Allow NULL?
114	KZGVH	Packaging Material is Closed Packaging	char	1	0	CHAR	(N' ')	Yes		KZGVH	Allow NULL?
115	XGCHP	Indicator: Approved batch record required	char	1	0	CHAR	(N' ')	Yes		XGCHP	Allow NULL?
116	KZEFF	Assign effectivity parameter values/ override change numbers	char	1	0	CHAR	(N' ')	Yes		CC_MTEFF	Allow NULL?
117	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
118	RDMHD	Rounding rule for calculation of SLED	char	1	0	CHAR	(N' ')	Yes		RDMHD	Allow NULL?
119	PRZUS	Indicator: Product composition printed on packaging	char	1	0	CHAR	(N' ')	Yes		PRZUS	Allow NULL?
120	MTPOS_MARA	General item category group	nvarchar	4	0	CHAR	(N' ')	Yes	TPTM	MTPOS_MARA	Allow NULL?
121	BFLME	Generic Material with Logistical Variants	char	1	0	CHAR	(N' ')	Yes		BFLME	Allow NULL?
122	MATFI	Material Is Locked	char	1	0	CHAR	(N' ')	Yes		MATFI	Allow NULL?
123	CMREL	Relevant for Configuration Management	char	1	0	CHAR	(N' ')	Yes		DE_CM_RELEVANCE_FLAG	Allow NULL?
124	BBTYP	Assortment List Type	char	1	0	CHAR	(N' ')	Yes	*	BBTYP	Allow NULL?
125	SLED_BBD	Expiration Date	char	1	0	CHAR	(N' ')	Yes		SLED_BBD	Allow NULL?
126	GTIN_VARIANT	Global Trade Item Number Variant	nvarchar	2	0	CHAR	(N' ')	Yes		GTIN_VARIANT	Allow NULL?
127	GENNR	Material Number of the Generic Material in Prepack Materials	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	WSTR_SATNR_PP	Allow NULL?
128	RMATP	Reference material for materials packed in same way	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PL_RMATP	Allow NULL?
129	GDS_RELEVANT	Indicator: Global Data Synchronization-Relevant	char	1	0	CHAR	(N' ')	Yes		GDS_RELEVANT	Allow NULL?
130	WEORA	Acceptance At Origin	char	1	0	CHAR	(N' ')	Yes		WEORA	Allow NULL?
131	HUTYP_DFLT	Standard HU Type	nvarchar	4	0	CHAR	(N' ')	Yes	THUTYP	CIFHUTYPDF	Allow NULL?
132	PILFERABLE	Pilferable	char	1	0	CHAR	(N' ')	Yes		CIFPILFRBL	Allow NULL?
133	WHSTC	Warehouse Storage Condition	nvarchar	2	0	CHAR	(N' ')	Yes	TWHSTC	CIFWHSTC	Allow NULL?
134	WHMATGR	Warehouse Material Group	nvarchar	4	0	CHAR	(N' ')	Yes	TWHMATGR	CIFWHMATGR	Allow NULL?
135	HNDLCODE	Handling Indicator	nvarchar	4	0	CHAR	(N' ')	Yes	THNDLCD	CIFHDLCODE	Allow NULL?
136	HAZMAT	Relevant for Hazardous Substances	char	1	0	CHAR	(N' ')	Yes		CIFHAZMAT	Allow NULL?
137	HUTYP	Handling Unit Type	nvarchar	4	0	CHAR	(N' ')	Yes	THUTYP	CIFHUTYP	Allow NULL?
138	TARE_VAR	Variable Tare Weight	char	1	0	CHAR	(N' ')	Yes		CIFTAREVAR	Allow NULL?
139	MAXC	Maximum Allowed Capacity of Packaging Material	decimal	15	3	DEC	((0))	Yes		CIFMAXC
140	MAXC_TOL	Overcapacity Tolerance of the Handling Unit	decimal	3	1	DEC	((0))	Yes		CIFMAXCTOL
141	MAXL	Maximum Packing Length of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXL
142	MAXB	Maximum Packing Width of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXB
143	MAXH	Maximum Packing Height of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXH
144	MAXDIM_UOM	Unit of Measure for Maximum Packing Length/Width/Height	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CIFMAXDUOM	Allow NULL?
145	QQTIME	Quarantine Period	decimal	3	0	QUAN	((0))	Yes		CIFQQTIME
146	QQTIMEUOM	Time Unit for Quarantine Period	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CIFQQTIMEUOM	Allow NULL?
147	QGRP	Quality Inspection Group	nvarchar	4	0	CHAR	(N' ')	Yes	TQGRP	CIFQGRP	Allow NULL?
148	SERIAL	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	TSERIAL	CIFSERIAL	Allow NULL?
149	PS_SMARTFORM	Form Name	nvarchar	30	0	CHAR	(N' ')	Yes	STXFADM	CIFPSSFNAME	Allow NULL?
150	LOGUNIT	EWM CW: Logistics Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	MARM	CIFLOGUNIT	Allow NULL?
151	CWQREL	EWM CW: Material Is a Catch Weight Material	char	1	0	CHAR	(N' ')	Yes		CIFCWQREL	Allow NULL?
152	CWQPROC	EWM CW: Catch Weight Profile for Entering CW Quantity	nvarchar	2	0	CHAR	(N' ')	Yes	TCWQPROC	CIFCWQPROC	Allow NULL?
153	CWQTOLGR	EWM-CW: Catch Weight Tolerance Group for EWM	nvarchar	9	0	CHAR	(N' ')	Yes	TCWQTOLGR	CIFCWQTOLGR	Allow NULL?
154	/BEV1/LULEINH	Loading Units	nvarchar	8	0	NUMC	(N'00000000')	Yes		/BEV1/LULEINH	Allow NULL?
155	/BEV1/LULDEGRP	Loading Unit Group: IS Beverage	nvarchar	3	0	CHAR	(N' ')	Yes	/BEV1/LUT906	/BEV1/LULDEGRP	Allow NULL?
156	/DSD/VC_GROUP	DSD Grouping	nvarchar	6	0	CHAR	(N' ')	Yes	/DSD/VC_GRP	/DSD/VC_GROUP	Allow NULL?
157	/VSO/R_TILT_IND	Material may be Tilted (Vehicle Space Optimization)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_TILT_IND	Allow NULL?
158	/VSO/R_STACK_IND	Stacking not Allowed (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_STACK_IND	Allow NULL?
159	/VSO/R_BOT_IND	Bottom Layer (Vehicle Space Optimization)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_BOTTOM_IND	Allow NULL?
160	/VSO/R_TOP_IND	Top Layer (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_TOP_IND	Allow NULL?
161	/VSO/R_STACK_NO	Stacking Factor (Vehicle Space Optimization)	nvarchar	3	0	NUMC	(N'000')	Yes		/VSO/M_STACK_NO	Allow NULL?
162	/VSO/R_PAL_IND	Load without Packaging Material (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_PALLET_IND	Allow NULL?
163	/VSO/R_PAL_OVR_D	Permissible Overhang (Depth) of Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_OVR_D
164	/VSO/R_PAL_OVR_W	Permissible Overhang (Width) of Shipping Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_OVR_W
165	/VSO/R_PAL_B_HT	Maximum Stacking Height of the Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_BIN_HGT
166	/VSO/R_PAL_MIN_H	Minimum Stacking Height of the Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_MIN_HT
167	/VSO/R_TOL_B_HT	Tolerance to Exceed the Max. Stacking Height (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_TOL_BIN_HT
168	/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?
169	/VSO/R_QUAN_UNIT	Unit of Measure Vehicle Space Optimization	nvarchar	3	0	UNIT	(N' ')	Yes		/VSO/R_QUAN_UNIT	Allow NULL?
170	/VSO/R_KZGVH_IND	Closed Packaging Material Required (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_KZGVH_IND	Allow NULL?
171	MCOND	Material Condition Management	char	1	0	CHAR	(N' ')	Yes		DFPS_MCOND	Allow NULL?
172	RETDELC	Return Code	char	1	0	CHAR	(N' ')	Yes		DFPS_RETDELC	Allow NULL?
173	LOGLEV_RETO	Return to Logistics Level	char	1	0	CHAR	(N' ')	Yes		DFPS_LOGLEV_RETO	Allow NULL?
174	NSNID	NATO Item Identification Number	nvarchar	9	0	CHAR	(N' ')	Yes		DFPS_NSNID	Allow NULL?
175	IMATN	FFF class	nvarchar	18	0	CHAR	(N' ')	Yes	*	IMATN	Allow NULL?
176	PICNUM	Supersession chain number	nvarchar	18	0	CHAR	(N' ')	Yes		PIC_PICNUM_SUS	Allow NULL?
177	BSTAT	Creation Status - Seasonal Procurement	nvarchar	2	0	CHAR	(N' ')	Yes	*	WRFBSTAT	Allow NULL?
178	COLOR_ATINN	Internal Charactieristic Number for Color Characteristics	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_COLOR_ATINN	Allow NULL?
179	SIZE1_ATINN	Internal Char. Number for Characteristics for Main Sizes	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_SIZE1_ATINN	Allow NULL?
180	SIZE2_ATINN	Internal Char. Number for Characteristics for Second Sizes	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_SIZE2_ATINN	Allow NULL?
181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_COLOR	Allow NULL?
182	SIZE1	Characteristic Value for Main Sizes of Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_SIZE1	Allow NULL?
183	SIZE2	Characteristic Value for Second Size for Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_SIZE2	Allow NULL?
184	FREE_CHAR	Characteristic Value for Evaluation Purposes	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_FREE_CHAR	Allow NULL?
185	CARE_CODE	Care Codes (such as Washing Code, Ironing Code, etc.)	nvarchar	16	0	CHAR	(N' ')	Yes		WRF_CARE_CODE	Allow NULL?
186	BRAND_ID	Brand	nvarchar	4	0	CHAR	(N' ')	Yes	WRF_BRANDS	WRF_BRAND_ID	Allow NULL?
187	FIBER_CODE1	Fiber Code for Textiles (Component 1)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_1	Allow NULL?
188	FIBER_PART1	Percentage Share of Fiber (Component 1)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_1	Allow NULL?
189	FIBER_CODE2	Fiber Code for Textiles (Component 2)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_2	Allow NULL?
190	FIBER_PART2	Percentage Share of Fiber (Component 2)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_2	Allow NULL?
191	FIBER_CODE3	Fiber Code for Textiles (Component 3)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_3	Allow NULL?
192	FIBER_PART3	Percentage Share of Fiber (Component 3)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_3	Allow NULL?
193	FIBER_CODE4	Fiber Code for Textiles (Component 4)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_4	Allow NULL?
194	FIBER_PART4	Percentage Share of Fiber (Component 4)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_4	Allow NULL?
195	FIBER_CODE5	Fiber Code for Textiles (Component 5)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_5	Allow NULL?
196	FIBER_PART5	Percentage Share of Fiber (Component 5)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_5	Allow NULL?
197	FASHGRD	Fashion Grade	nvarchar	4	0	CHAR	(N' ')	Yes		FASHGRD	Allow NULL?
198	MAKTX	Material Description (Short Text)	nvarchar	40	0	CHAR	(N' ')	Yes		MAKTX	Allow NULL?
199	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
200	PSTAT	Maintenance status	nvarchar	15	0	CHAR	(N' ')	Yes		PSTAT_D	Allow NULL?
201	LVORM	Flag Material for Deletion at Plant Level	char	1	0	CHAR	(N' ')	Yes		LVOWK	Allow NULL?
202	BWTTY	Valuation Category	char	1	0	CHAR	(N' ')	Yes	T149C	BWTTY_D	Allow NULL?
203	XCHAR	Batch management indicator (internal)	char	1	0	CHAR	(N' ')	Yes		XCHAR	Allow NULL?
204	MMSTA	Plant-Specific Material Status	nvarchar	2	0	CHAR	(N' ')	Yes	T141	MMSTA	Allow NULL?
205	MMSTD	Date from which the plant-specific material status is valid	nvarchar	8	0	DATS	(N'00000000')	Yes		MMSTD	Allow NULL?
206	MAABC	ABC Indicator	char	1	0	CHAR	(N' ')	Yes	TMABC	MAABC	Allow NULL?
207	KZKRI	Indicator: Critical part	char	1	0	CHAR	(N' ')	Yes		KZKRI	Allow NULL?
208	EKGRP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	T024	EKGRP	Allow NULL?
209	AUSME	Unit of issue	nvarchar	3	0	UNIT	(N' ')	Yes	T006	AUSME	Allow NULL?
210	DISPR	Material: MRP profile	nvarchar	4	0	CHAR	(N' ')	Yes	MDIP	DISPR	Allow NULL?
211	DISMM	MRP Type	nvarchar	2	0	CHAR	(N' ')	Yes	T438A	DISMM	Allow NULL?
212	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	CHAR	(N' ')	Yes	T024D	DISPO	Allow NULL?
213	KZDIE	Indicator: MRP controller is buyer (deactivated)	char	1	0	CHAR	(N' ')	Yes		KZDIE	Allow NULL?
214	PLIFZ	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
215	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
216	PERKZ	Period Indicator	char	1	0	CHAR	(N' ')	Yes		PERKZ	Allow NULL?
217	AUSSS	Assembly scrap in percent	decimal	5	2	DEC	((0))	Yes		AUSSS
218	DISLS	Lot size (materials planning)	nvarchar	2	0	CHAR	(N' ')	Yes	T439A	DISLS	Allow NULL?
219	BESKZ	Procurement Type	char	1	0	CHAR	(N' ')	Yes		BESKZ	Allow NULL?
220	SOBSL	Special procurement type	nvarchar	2	0	CHAR	(N' ')	Yes	T460A	SOBSL	Allow NULL?
221	MINBE	Reorder Point	decimal	13	3	QUAN	((0))	Yes		MINBE
222	EISBE	Safety Stock	decimal	13	3	QUAN	((0))	Yes		EISBE
223	BSTMI	Minimum Lot Size	decimal	13	3	QUAN	((0))	Yes		BSTMI
224	BSTMA	Maximum Lot Size	decimal	13	3	QUAN	((0))	Yes		BSTMA
225	BSTFE	Fixed lot size	decimal	13	3	QUAN	((0))	Yes		BSTFE
226	BSTRF	Rounding value for purchase order quantity	decimal	13	3	QUAN	((0))	Yes		BSTRF
227	MABST	Maximum stock level	decimal	13	3	QUAN	((0))	Yes		MABST
228	LOSFX	Ordering costs	decimal	11	2	CURR	((0))	Yes		LOSFX
229	SBDKZ	Dependent requirements ind. for individual and coll. reqmts	char	1	0	CHAR	(N' ')	Yes		SBDKZ	Allow NULL?
230	LAGPR	Storage costs indicator	char	1	0	CHAR	(N' ')	Yes	T439L	LAGPR	Allow NULL?
231	ALTSL	Method for Selecting Alternative Bills of Material	char	1	0	CHAR	(N' ')	Yes		ALTSL	Allow NULL?
232	KZAUS	Discontinuation indicator	char	1	0	CHAR	(N' ')	Yes		KZAUS	Allow NULL?
233	AUSDT	Effective-Out Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUSDT	Allow NULL?
234	NFMAT	Follow-Up Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	NFMAT	Allow NULL?
235	KZBED	Indicator for Requirements Grouping	char	1	0	CHAR	(N' ')	Yes		KZBED	Allow NULL?
236	MISKZ	Mixed MRP indicator	char	1	0	CHAR	(N' ')	Yes		MISKZ	Allow NULL?
237	FHORI	Scheduling Margin Key for Floats	nvarchar	3	0	CHAR	(N' ')	Yes	T436A	FHORI	Allow NULL?
238	PFREI	Indicator: automatic fixing of planned orders	char	1	0	CHAR	(N' ')	Yes		PFREI	Allow NULL?
239	FFREI	Release indicator for production orders	char	1	0	CHAR	(N' ')	Yes		FFREI	Allow NULL?
240	RGEKZ	Indicator: Backflush	char	1	0	CHAR	(N' ')	Yes		RGEKM	Allow NULL?
241	FEVOR	Production Supervisor	nvarchar	3	0	CHAR	(N' ')	Yes	T024F	FEVOR	Allow NULL?
242	BEARZ	Processing time	decimal	5	2	DEC	((0))	Yes		BEARZ
243	RUEZT	Setup and teardown time	decimal	5	2	DEC	((0))	Yes		RUEZT
244	TRANZ	Interoperation time	decimal	5	2	DEC	((0))	Yes		TRANZ
245	BASMG	Base quantity	decimal	13	3	QUAN	((0))	Yes		BASMG
246	DZEIT	In-house production time	decimal	3	0	DEC	((0))	Yes		DZEIT
247	MAXLZ	Maximum Storage Period	decimal	5	0	DEC	((0))	Yes		MAXLZ
248	LZEIH	Unit for maximum storage period	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LZEIH	Allow NULL?
249	KZPRO	Indicator: withdrawal of stock from production bin	char	1	0	CHAR	(N' ')	Yes		KZPRO	Allow NULL?
250	GPMKZ	Indicator: Material Included in Rough-Cut Planning	char	1	0	CHAR	(N' ')	Yes		GPMKZ	Allow NULL?
251	UEETO	Overdelivery tolerance limit	decimal	3	1	DEC	((0))	Yes		UEETO
252	UEETK	Indicator: Unlimited Overdelivery Allowed	char	1	0	CHAR	(N' ')	Yes		UEETK	Allow NULL?
253	UNETO	Underdelivery tolerance limit	decimal	3	1	DEC	((0))	Yes		UNETO
254	WZEIT	Total replenishment lead time (in workdays)	decimal	3	0	DEC	((0))	Yes		WZEIT
255	ATPKZ	Replacement part	char	1	0	CHAR	(N' ')	Yes		ATPKZ	Allow NULL?
256	VZUSL	Surcharge factor for cost in percent	decimal	5	2	DEC	((0))	Yes		VZUSL
257	HERBL	State of manufacture	nvarchar	2	0	CHAR	(N' ')	Yes		HERBL	Allow NULL?
258	INSMK	Post to Inspection Stock	char	1	0	CHAR	(N' ')	Yes		INSMK_MAT	Allow NULL?
259	SPROZ	Sample for quality inspection (in %) (deactivated)	decimal	3	1	DEC	((0))	Yes		SPROZ
260	QUAZT	Quarantine period (deactivated)	decimal	3	0	DEC	((0))	Yes		QUAZT
261	SSQSS	Control Key for Quality Management in Procurement	nvarchar	8	0	CHAR	(N' ')	Yes	TQ08	QSSPUR	Allow NULL?
262	MPDAU	Mean inspection duration (deactivated)	decimal	5	0	DEC	((0))	Yes		MPDAU
263	KZPPV	Indicator for inspection plan (deactivated)	char	1	0	CHAR	(N' ')	Yes		KZPPV	Allow NULL?
264	KZDKZ	Documentation required indicator	char	1	0	CHAR	(N' ')	Yes		KZDKZ	Allow NULL?
265	WSTGH	Active substance content (deactivated)	decimal	9	0	DEC	((0))	Yes		WSTGH
266	PRFRQ	Interval until next recurring inspection	decimal	5	0	DEC	((0))	Yes		PRFRQ
267	NKMPR	Date according to check sampling inspection (deactivated)	nvarchar	8	0	DATS	(N'00000000')	Yes		NKMPR	Allow NULL?
268	UMLMC	Stock in Transfer (Plant to Plant)	decimal	13	3	QUAN	((0))	Yes		UMLME
269	LADGR	Loading Group	nvarchar	4	0	CHAR	(N' ')	Yes	TLGR	LADGR	Allow NULL?
270	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
271	USEQU	Quota arrangement usage	char	1	0	CHAR	(N' ')	Yes	TMQ2	USEQU	Allow NULL?
272	LGRAD	Service level	decimal	3	1	DEC	((0))	Yes		LGRAD
273	AUFTL	Splitting Indicator	char	1	0	CHAR	(N' ')	Yes	T439P	AUFTL	Allow NULL?
274	PLVAR	Plan Version	nvarchar	2	0	CHAR	(N' ')	Yes	T778P	PLVAR	Allow NULL?
275	OTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	T778O	OTYPE	Allow NULL?
276	OBJID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
277	MTVFP	Checking Group for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	TMVF	MTVFP	Allow NULL?
278	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
279	KZKFK	Indicator: take correction factors into account	char	1	0	CHAR	(N' ')	Yes		KZKFK	Allow NULL?
280	VRVEZ	Shipping setup time	decimal	5	2	DEC	((0))	Yes		VRVEZ
281	VBAMG	Base quantity for capacity planning in shipping	decimal	13	3	QUAN	((0))	Yes		VBAMG
282	VBEAZ	Shipping processing time	decimal	5	2	DEC	((0))	Yes		VBEAZ
283	LIZYK	Deactivated	nvarchar	4	0	CHAR	(N' ')	Yes		DUMMYLIZYK	Allow NULL?
284	BWSCL	Source of Supply	char	1	0	CHAR	(N' ')	Yes	TMBW1	BWSCL	Allow NULL?
285	KAUTB	Indicator: "automatic purchase order allowed"	char	1	0	CHAR	(N' ')	Yes		KAUTB	Allow NULL?
286	KORDB	Indicator: Source list requirement	char	1	0	CHAR	(N' ')	Yes		KORDB	Allow NULL?
287	STAWN	Commodity Code/Import Code Number for Foreign Trade	nvarchar	17	0	CHAR	(N' ')	Yes	T604	STAWN	Allow NULL?
288	HERKL	Country of origin of the material	nvarchar	3	0	CHAR	(N' ')	Yes	T005	HERKL	Allow NULL?
289	HERKR	Region of origin of material (non-preferential origin)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	HERKR	Allow NULL?
290	EXPME	Unit of measure for commodity code (foreign trade)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EXPME	Allow NULL?
291	MTVER	Export/import material group	nvarchar	4	0	CHAR	(N' ')	Yes	TVFM	MTVER	Allow NULL?
292	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
293	TRAME	Stock in Transit	decimal	13	3	QUAN	((0))	Yes		TRAME
294	MRPPP	PPC planning calendar	nvarchar	3	0	CHAR	(N' ')	Yes	T439G	MRPPP	Allow NULL?
295	SAUFT	Ind.: Repetitive mfg allowed	char	1	0	CHAR	(N' ')	Yes		SA_SAUFT	Allow NULL?
296	FXHOR	Planning time fence	nvarchar	3	0	NUMC	(N'000')	Yes		FXHOR	Allow NULL?
297	VRMOD	Consumption mode	char	1	0	CHAR	(N' ')	Yes		VRMOD	Allow NULL?
298	VINT1	Consumption period: backward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT1	Allow NULL?
299	VINT2	Consumption period: forward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT2	Allow NULL?
300	VERKZ	Version Indicator	char	1	0	CHAR	(N' ')	Yes		CK_VERK1	Allow NULL?
301	STLAL	Alternative BOM	nvarchar	2	0	CHAR	(N' ')	Yes		STALT	Allow NULL?
302	STLAN	BOM Usage	char	1	0	CHAR	(N' ')	Yes	T416	STLAN	Allow NULL?
303	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
304	APLAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
305	LOSGR	Lot Size for Product Costing	decimal	13	3	QUAN	((0))	Yes		CK_LOSGR
306	SOBSK	Special Procurement Type for Costing	nvarchar	2	0	CHAR	(N' ')	Yes	T460A	CK_SOBSL	Allow NULL?
307	FRTME	Production unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	FRTME	Allow NULL?
308	LGPRO	Issue Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGPRO	Allow NULL?
309	DISGR	MRP Group	nvarchar	4	0	CHAR	(N' ')	Yes	T438M	DISGR	Allow NULL?
310	KAUSF	Component scrap in percent	decimal	5	2	DEC	((0))	Yes		KAUSF
311	QZGTP	Certificate Type	nvarchar	4	0	CHAR	(N' ')	Yes	TQ05	QZGTYP	Allow NULL?
312	QMATV	Inspection Setup Exists for Material/Plant	char	1	0	CHAR	(N' ')	Yes		QMATV	Allow NULL?
313	TAKZT	Takt time	decimal	3	0	DEC	((0))	Yes		TAKZT
314	RWPRO	Range of coverage profile	nvarchar	3	0	CHAR	(N' ')	Yes	T438R	RWPRO	Allow NULL?
315	COPAM	Local field name for CO/PA link to SOP	nvarchar	10	0	CHAR	(N' ')	Yes		COPAM	Allow NULL?
316	ABCIN	Physical inventory indicator for cycle counting	char	1	0	CHAR	(N' ')	Yes	T159C	ABCIN	Allow NULL?
317	AWSLS	Variance Key	nvarchar	6	0	CHAR	(N' ')	Yes	TKV01	AWSLS	Allow NULL?
318	SERNP	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	T377P	SERAIL	Allow NULL?
319	CUOBJ	Internal object number	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBM	Allow NULL?
320	STDPD	Configurable material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	STDPD	Allow NULL?
321	SFEPR	Repetitive manufacturing profile	nvarchar	4	0	CHAR	(N' ')	Yes	T437S	SFEPR	Allow NULL?
322	XMCNG	Negative stocks allowed in plant	char	1	0	CHAR	(N' ')	Yes		XMCNG	Allow NULL?
323	QSSYS	Required QM System for Vendor	nvarchar	4	0	CHAR	(N' ')	Yes	TQ02	QSSYS_SOLL	Allow NULL?
324	LFRHY	Planning cycle	nvarchar	3	0	CHAR	(N' ')	Yes	T439G	LFRHY	Allow NULL?
325	RDPRF	Rounding Profile	nvarchar	4	0	CHAR	(N' ')	Yes	RDPR	RDPRF	Allow NULL?
326	VRBMT	Reference material for consumption	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	VRBMT	Allow NULL?
327	VRBWK	Reference plant for consumption	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	VRBWK	Allow NULL?
328	VRBDT	To date of the material to be copied for consumption	nvarchar	8	0	DATS	(N'00000000')	Yes		VRBDT	Allow NULL?
329	VRBFK	Multiplier for reference material for consumption	decimal	4	2	DEC	((0))	Yes		VRBFK
330	AUTRU	Reset Forecast Model Automatically	char	1	0	CHAR	(N' ')	Yes		AUTRU	Allow NULL?
331	PREFE	Preference indicator in export/import	char	1	0	CHAR	(N' ')	Yes		PREFE	Allow NULL?
332	PRENC	Exemption certificate: Indicator for legal control	char	1	0	CHAR	(N' ')	Yes		PRENC	Allow NULL?
333	PRENO	Exemption certificate number for legal control	nvarchar	8	0	CHAR	(N' ')	Yes		PRENN	Allow NULL?
334	PREND	Exemption certificate: Issue date of exemption certificate	nvarchar	8	0	DATS	(N'00000000')	Yes		PREND	Allow NULL?
335	PRENE	Indicator: Vendor declaration exists	char	1	0	CHAR	(N' ')	Yes		PRENE	Allow NULL?
336	PRENG	Validity date of vendor declaration	nvarchar	8	0	DATS	(N'00000000')	Yes		PRENG	Allow NULL?
337	ITARK	Indicator: Military goods	char	1	0	CHAR	(N' ')	Yes		ITARK	Allow NULL?
338	SERVG	IS-R service level	char	1	0	CHAR	(N' ')	Yes	TWSG	W_SERVGRD	Allow NULL?
339	KZKUP	Indicator: Material can be co-product	char	1	0	CHAR	(N' ')	Yes		KZKUPMAT	Allow NULL?
340	STRGR	Planning strategy group	nvarchar	2	0	CHAR	(N' ')	Yes	T461P	STRGR	Allow NULL?
341	CUOBV	Internal object number of configurable material for planning	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBV	Allow NULL?
342	LGFSB	Default storage location for external procurement	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGFSB	Allow NULL?
343	SCHGT	Indicator: Bulk Material	char	1	0	CHAR	(N' ')	Yes		SCHGT	Allow NULL?
344	CCFIX	CC indicator is fixed	char	1	0	CHAR	(N' ')	Yes		CCFIX	Allow NULL?
345	EPRIO	Stock determination group	nvarchar	4	0	CHAR	(N' ')	Yes	T434G	BF_GROUP	Allow NULL?
346	QMATA	Material Authorization Group for Activities in QM	nvarchar	6	0	CHAR	(N' ')	Yes	TQ01B	QMATAUTH	Allow NULL?
347	RESVP	Period of adjustment for planned independent requirements	decimal	3	0	DEC	((0))	Yes		RESVP
348	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	TCA01	PLNTY	Allow NULL?
349	UOMGR	Unit of Mearsure Group (Oil, Natural Gas,...)	nvarchar	3	0	CHAR	(N' ')	Yes	OIB06	OIB_UOMGR	Allow NULL?
350	UMRSL	Conversion Group (Oil, Natural Gas,..)	nvarchar	4	0	CHAR	(N' ')	Yes	OIB01	OIB_UMRSL	Allow NULL?
351	ABFAC	Air Bouyancy Factor	decimal	2	1	DEC	((0))	Yes	*	OIL_ABFAC
352	SFCPF	Production Scheduling Profile	nvarchar	6	0	CHAR	(N' ')	Yes	TCO43	CO_PRODPRF	Allow NULL?
353	SHFLG	Safety time indicator (with or without safety time)	char	1	0	CHAR	(N' ')	Yes		SHFLG	Allow NULL?
354	SHZET	Safety time (in workdays)	nvarchar	2	0	NUMC	(N'00')	Yes		SHZET	Allow NULL?
355	MDACH	Action control: planned order processing	nvarchar	2	0	CHAR	(N' ')	Yes	T46AC	MDACH	Allow NULL?
356	KZECH	Determination of batch entry in the production/process order	char	1	0	CHAR	(N' ')	Yes		KZECH	Allow NULL?
357	MEGRU	Unit of Measure Group	nvarchar	4	0	CHAR	(N' ')	Yes	TWMEG	MEGRU	Allow NULL?
358	MFRGR	Material freight group	nvarchar	8	0	CHAR	(N' ')	Yes	TMFG	MFRGR	Allow NULL?
359	VKUMC	Stock transfer sales value (plant to plant) for VO material	decimal	13	2	CURR	((0))	Yes		VKUMC
360	VKTRW	Transit value at sales price for value-only material	decimal	13	2	CURR	((0))	Yes		VKTRW
361	KZAGL	Indicator: smooth promotion consumption	char	1	0	CHAR	(N' ')	Yes		KZAGL	Allow NULL?
362	FVIDK	Production Version To Be Costed	nvarchar	4	0	CHAR	(N' ')	Yes	*	CK_VERID	Allow NULL?
363	FXPRU	Fixed-Price Co-Product	char	1	0	CHAR	(N' ')	Yes		CK_FIXPRKU	Allow NULL?
364	LOGGR	Logistics handling group for workload calculation	nvarchar	4	0	CHAR	(N' ')	Yes	TLOG	LOGGR	Allow NULL?
365	FPRFM	Distribution profile of material in plant	nvarchar	3	0	CHAR	(N' ')	Yes	*	FPRFM	Allow NULL?
366	GLGMG	Tied Empties Stock	decimal	13	3	QUAN	((0))	Yes		GLGMG
367	VKGLG	Sales value of tied empties stock	decimal	13	2	CURR	((0))	Yes		VKGLG
368	INDUS	Material CFOP category	nvarchar	2	0	CHAR	(N' ')	Yes		J_1BINDUS3	Allow NULL?
369	MOWNR	CAP: Number of CAP products list	nvarchar	12	0	CHAR	(N' ')	Yes	T618M	MOWNR	Allow NULL?
370	MOGRU	Common Agricultural Policy: CAP products group-Foreign Trade	nvarchar	6	0	CHAR	(N' ')	Yes	T618G	MOGRU	Allow NULL?
371	CASNR	CAS number for pharmaceutical products in foreign trade	nvarchar	15	0	CHAR	(N' ')	Yes	T610C	CASNR	Allow NULL?
372	GPNUM	Production statistics: PRODCOM number for foreign trade	nvarchar	9	0	CHAR	(N' ')	Yes	T609G	GPNUM	Allow NULL?
373	STEUC	Control code for consumption taxes in foreign trade	nvarchar	16	0	CHAR	(N' ')	Yes	T604F	STEUC	Allow NULL?
374	FABKZ	Indicator: Item Relevant to JIT Delivery Schedules	char	1	0	CHAR	(N' ')	Yes		FABKZ	Allow NULL?
375	MATGR	Group of Materials for Transition Matrix	nvarchar	20	0	CHAR	(N' ')	Yes		MATNRGROUP	Allow NULL?
376	VSPVB	Proposed Supply Area in Material Master Record	nvarchar	10	0	CHAR	(N' ')	Yes	PVBE	VSPVB	Allow NULL?
377	DPLFS	Fair share rule	nvarchar	2	0	CHAR	(N' ')	Yes		DPLFS	Allow NULL?
378	DPLPU	Indicator: push distribution	char	1	0	CHAR	(N' ')	Yes		DPLPU	Allow NULL?
379	DPLHO	Deployment horizon in days	decimal	3	0	DEC	((0))	Yes		DPLHO
380	MINLS	Minimum lot size for Supply Demand Match	decimal	13	3	QUAN	((0))	Yes		CSCP_MINLOTSIZE
381	MAXLS	Maximum lot size for Supply Demand Match	decimal	13	3	QUAN	((0))	Yes		CSCP_MAXLOTSIZE
382	FIXLS	Fixed lot size for Supply Demand Match	decimal	13	3	QUAN	((0))	Yes		CSCP_FIXLOTSIZE
383	LTINC	Lot size increment for Supply Demand Match	decimal	13	3	QUAN	((0))	Yes		CSCP_LOTINCREMENT
384	COMPL	This field is no longer used	nvarchar	2	0	NUMC	(N'00')	Yes	TCSCP_COMP_LVL	CSCP_DUMMY	Allow NULL?
385	CONVT	Conversion types for production figures	nvarchar	2	0	CHAR	(N' ')	Yes	TCSCP_CONV_TYPE	CSCP_CONV_TYPE	Allow NULL?
386	SHPRO	Period Profile for Safety Time	nvarchar	3	0	CHAR	(N' ')	Yes	T438V	SHPRO	Allow NULL?
387	AHDIS	MRP relevancy for dependent requirements	char	1	0	CHAR	(N' ')	Yes		AHDIS	Allow NULL?
388	DIBER	Indicator: MRP area exists	char	1	0	CHAR	(N' ')	Yes		DIBER	Allow NULL?
389	KZPSP	Indicator for cross-project material	char	1	0	CHAR	(N' ')	Yes		KZPSP	Allow NULL?
390	OCMPF	Overall profile for order change management	nvarchar	6	0	CHAR	(N' ')	Yes	TCO48	OCM_GPROFILE	Allow NULL?
391	APOKZ	Indicator: Is material relevant for APO	char	1	0	CHAR	(N' ')	Yes		APOKZ	Allow NULL?
392	MCRUE	MARDH rec. already exists for per. before last of MARD per.	char	1	0	CHAR	(N' ')	Yes		MCRUE	Allow NULL?
393	LFMON	Current period (posting period)	nvarchar	2	0	NUMC	(N'00')	Yes		LFMON	Allow NULL?
394	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	NUMC	(N'0000')	Yes		LFGJA	Allow NULL?
395	EISLO	Minimum Safety Stock	decimal	13	3	QUAN	((0))	Yes		EISLO
396	NCOST	Do Not Cost	char	1	0	CHAR	(N' ')	Yes		CK_NO_COSTING	Allow NULL?
397	ROTATION_DATE	Strategy for Putaway and Stock Removal	char	1	0	CHAR	(N' ')	Yes		ROTATION_DATE	Allow NULL?
398	UCHKZ	Indicator for Original Batch Management	char	1	0	CHAR	(N' ')	Yes		UCHKZ	Allow NULL?
399	UCMAT	Reference Material for Original Batches	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	VBOB_OB_RFMAT	Allow NULL?
400	BWESB	Valuated Goods Receipt Blocked Stock	decimal	13	3	QUAN	((0))	Yes		BWESB
401	SGT_COVS	Segmentation Strategy	nvarchar	8	0	CHAR	(N' ')	Yes	SGT_COVS_T	SGT_COVS	Allow NULL?
402	SGT_STATC	Segmentation Status	char	1	0	CHAR	(N' ')	Yes		SGT_STATC	Allow NULL?
403	SGT_SCOPE	Segmentation Strategy Scope	char	1	0	CHAR	(N' ')	Yes		SGT_SCOPE	Allow NULL?
404	SGT_MRPSI	Sort Stock based on Segment	char	1	0	CHAR	(N' ')	Yes		SGT_SRT_STK	Allow NULL?
405	SGT_PRCM	Consumption Priority	char	1	0	CHAR	(N' ')	Yes		SGT_PRCM	Allow NULL?
406	SGT_CHINT	Discrete Batch Number	char	1	0	CHAR	(N' ')	Yes		SGT_CHINT	Allow NULL?
407	SGT_STK_PRT	Stock Protection Indicator	char	1	0	CHAR	(N' ')	Yes		SGT_STK_PRT	Allow NULL?
408	SGT_DEFSC	Default Stock Segment value	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_DEFSC	Allow NULL?
409	FSH_MG_ARUN_REQ	Order Allocation Run	char	1	0	CHAR	(N' ')	Yes		FSH_MG_ARUN_REQ	Allow NULL?
410	FSH_SEAIM	Indicator: Season Active in Inventory Management	char	1	0	CHAR	(N' ')	Yes		FSH_SEAIM	Allow NULL?
411	/MRSS/PROF_GUID	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	CHAR	(N' ')	Yes		GUID_32	Allow NULL?
412	/MRSS/PROF_KEY	Profile Key	nvarchar	10	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_REQUID	Allow NULL?
413	/MRSS/DATACHANGE	Data was changed in the controls on the user screen	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_USCREENCTL_DATACHANGED	Allow NULL?
414	/SAPMP/TOLPRPL	Percentage Tolerance Plus	decimal	3	1	DEC	((0))	Yes		/SAPMP/TOLPRPL
415	/SAPMP/TOLPRMI	Percentage Tolerance Minus	decimal	3	1	DEC	((0))	Yes		/SAPMP/TOLPRMI
416	/VSO/R_PKGRP	Packing Group of the Material (VSO)	nvarchar	18	0	CHAR	(N' ')	Yes	/VSO/M_PKG	/VSO/M_PKGRP	Allow NULL?
417	/VSO/R_LANE_NUM	Line within the Automatic Picking Zone (VSO)	nvarchar	3	0	CHAR	(N' ')	Yes		/VSO/M_LANE_NUM	Allow NULL?
418	/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?
419	/VSO/R_FORK_DIR	Pick Packaging Materials only Lengthwise (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_FORK_DIR	Allow NULL?
420	IUID_RELEVANT	IUID-Relevant	char	1	0	CHAR	(N' ')	Yes		IUID_RELEVANT	Allow NULL?
421	IUID_TYPE	Structure Type of UII	nvarchar	10	0	CHAR	(N' ')	Yes	TIUID_TYPE	IUID_TYPE	Allow NULL?
422	UID_IEA	External Allocation of UII	char	1	0	CHAR	(N' ')	Yes		UID_IEA	Allow NULL?
423	CONS_PROCG	Consignment Control	char	1	0	CHAR	(N' ')	Yes	WRFT_CONS_PROCG	WRF_CONS_PROCG	Allow NULL?
424	GI_PR_TIME	Goods Issue Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WRF_PSCD_WABAZ
425	MULTIPLE_EKGRP	Purchasing Across Purchasing Group	char	1	0	CHAR	(N' ')	Yes		WRF_POHF_OTHER_EKGRP_ALLOW	Allow NULL?
426	REF_SCHEMA	Reference Determination Schema	nvarchar	2	0	CHAR	(N' ')	Yes	WRF_REF_RFS	WRF_REF_SCHEMA	Allow NULL?
427	MIN_TROC	Minimum Target Range of Coverage	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FRE_TROC_MIN	Allow NULL?
428	MAX_TROC	Maximum Target Range of Coverage	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FRE_TROC_MAX	Allow NULL?
429	TARGET_STOCK	Target Stock	decimal	13	3	QUAN	((0))	Yes		WRF_FRE_TARGET_STOCK

TOP ERP 6.0 | /SMERP/STG_MM001 INDEXES

Name	Primary	Unique	Type	Columns
/SMERP/STG_MM00100	No	No	NONCLUSTERED	DSF_RECORD_ID, MANDT
/SMERP/STG_MM001A0	No	No	NONCLUSTERED	DSF_DSTORE_ID, MANDT
/SMERP/STG_MM001~0	Yes	Yes	CLUSTERED	DSF_GUID, 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

429 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_MM001 TABLE

TOP ERP 6.0 | /SMERP/STG_MM001 COLUMNS

TOP ERP 6.0 | /SMERP/STG_MM001 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

429 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_MM001 TABLE

TOPERP 6.0 | /SMERP/STG_MM001 COLUMNS

TOPERP 6.0 | /SMERP/STG_MM001 INDEXES

TOP ERP 6.0 | /SMERP/STG_MM001 COLUMNS

TOP ERP 6.0 | /SMERP/STG_MM001 INDEXES