	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

239 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M2 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MWZDM07M2	239	1	ZDM07M2	Inventory Management

SQL: selectupdate insert create

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

SELECT MANDT, MBLNR, MJAHR, ZEILE, VBUND, XOWST, XPRMS, XLAUT, XWESC, KZGRU, GRTXT, WESCH, RECID, KASPE, KAVSP, SASPE, XSTBW, ZEILO, DIMNG, BWTOR, PRREG, KO_GSBER, KO_PARGB, XBKNG, XMCNG, XLONG, XSVNG, XSMNG, UMXBN, UMXMN, UMXLN, UMXSV, UMXSM, RESWK, LEWED, REVLV, KANBA, SERNP, UMMLM, UMKAL, VMVPR, UMVMV, ANZL1, ANZL2, LMEN1, LMEN2, LETY1, LETY2, IDNLF, EAN11, SONUM, UMSON, UMHKM, UMXVK, KZMHD, MHDRZ, MHDHB, UMXCH, QM_ZUSTD, QM_UMZST, KZCLA, MHDAT, ANZSN, UMPRDHA, UMSATNR, UMBWVOR, UMBWSCL, UMSAISO, UMVOLEH, UMPLGTP, UMSERVG, EAN11_BME, EAN11_KON, EANME, CLASS, UMCLA, QMAT_INAKT, CHSMM, UMCHS, XCLAS, UMXCL, RMVCT, EK_VKWRT, EK_VKWRA, PKNUM, PKPOS, PKLVS, UMLIFCH, UMLICHA, UMLWEDT, UMVFDAT, UMHSDAT, MHDAT_OLD, UMQNDAT, XKOKO, UMAUT, TBBEL, TBBPO, TBBJR, VFMNG, CUOBJ, STDPD, TBPKZ, TAFKZ, XWART, DGLTS, UMMEN, UMXEI, DGLTP, UMKZB, UMMLA, UMSAISJ, EQUMG, XEXEQ, UMXEXEQ, GLMNG, UMKZBAA, DIRTA, UMSERNP, KZECH, FCHAR, XKCFC, KZCHP, INFNR, BWSPA, UPVOR, UPTYP, MEKOR, UEZEI, UEBPO, LWMNG, LWSBS, XWMHD, LAMNG, PRVBE, VEXVK, RBLVS, UMRBL, UMRBU, PARWK, KTOMA, XLBPD, XBNSB, XWAIT, XNOEQ, XSKNG, XSONG, XSWNG, UMXSK, UMXSO, UMXSW, XEWRX, X2FDO, UMVKW, UMVKA, XSENG, XSQNG, UMXSE, UMXSQ, AREWW, MHDLG, VWERW, KZWSO, UMATT, KZKUB, UBTYP, UBLGP, UMKZBWS, SETKZBWS, UMKZVBR, KALSM, UMKALNR, URERFMG, URVERMG, UMMTA, MBBME, MLBWG, UMXSTAU, UMXHEAD, EKALR, UMEKALR, EPRIO, UMEPR, RULES, AUFPL_ORD, APLZL_ORD, XERSY, MPROF, MFRNR, ELIKZ_INPUT, UMLGNTB, XOARC, XBEWM, UMXBEWM, KZEAR_INP, VUMVKW, ORZEIL, MTUSE, NFVAL, JV_CRPCALC, JV_RECIND, HSDAT_INPUT, VFDAT_INPUT, UMXWMHD, UMMHDHB, UMMHDRZ, BWTAR_XMBWL, UMBWTAR_XMBWL, RDMHD, IPRKZ, IPRKZ_HBD, UMIPRKZ, ESTAK, MBLFM, MBGJA, RMBEWH, MBRUE, XSAUT, UMMBLFM, UMMBGJA, UMRMBEWH, UMMBRUE, GWEMG, XREFC, UCUOB, USTDP, PRERR, FRLFD, XEXIT, VBELN_VL, VBELP_VL, KZXAB, UMKZXAB, UEKLA, UMXLAUT, XVASH, UMBFLME, KSTAR, ORUML FROM MWZDM07M2

TOP ERP 6.0 | MWZDM07M2 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	MBLNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	No		MBLNR	Allow NULL?
3	MJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	No		MJAHR	Allow NULL?
4	ZEILE	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	No		MBLPO	Allow NULL?
5	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
6	XOWST	No value string where valuation types the same	char	1	0	CHAR	(N' ')	Yes		XOWST	Allow NULL?
7	XPRMS	Material status already checked	char	1	0	CHAR	(N' ')	Yes		XPRMS	Allow NULL?
8	XLAUT	Automatic creation of storage location allowed	char	1	0	CHAR	(N' ')	Yes		XLAUT	Allow NULL?
9	XWESC	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
10	KZGRU	Control: Reason for Movement	char	1	0	CHAR	(N' ')	Yes		KZGRU	Allow NULL?
11	GRTXT	Text: Reason for Goods Movement	nvarchar	20	0	CHAR	(N' ')	Yes		GRTXT	Allow NULL?
12	WESCH	Quantity: Number of GR/GI slips to be printed	decimal	13	3	QUAN	((0))	Yes		WESCH
13	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	T8JJ	JV_RECIND	Allow NULL?
14	KASPE	Blocked Stock	decimal	13	3	QUAN	((0))	Yes		SPEME
15	KAVSP	Blocked stock of previous period	decimal	13	3	QUAN	((0))	Yes		VMSPE
16	SASPE	Blocked Stock	decimal	13	3	QUAN	((0))	Yes		SPEME
17	XSTBW	Reversal movement type	char	1	0	CHAR	(N' ')	Yes		XSTBW	Allow NULL?
18	ZEILO	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
19	DIMNG	Difference quantity for goods movements	decimal	13	3	QUAN	((0))	Yes		MB_DIMNG
20	BWTOR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
21	PRREG	Checking Rule for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	*	PRREG	Allow NULL?
22	KO_GSBER	Business area reported to the partner	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER_GP	Allow NULL?
23	KO_PARGB	assumed business area of the business partner	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARGB_GP	Allow NULL?
24	XBKNG	Negative stocks in valuation area allowed	char	1	0	CHAR	(N' ')	Yes		XBKNG	Allow NULL?
25	XMCNG	Negative stocks allowed in plant	char	1	0	CHAR	(N' ')	Yes		XMCNG	Allow NULL?
26	XLONG	Negative stocks allowed in storage location	char	1	0	CHAR	(N' ')	Yes		XLONG	Allow NULL?
27	XSVNG	Stock of ret. packaging w. cust. allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSVNG	Allow NULL?
28	XSMNG	RTP stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSMNG	Allow NULL?
29	UMXBN	Negative stocks in valuation area allowed	char	1	0	CHAR	(N' ')	Yes		XBKNG	Allow NULL?
30	UMXMN	Negative stocks allowed in plant	char	1	0	CHAR	(N' ')	Yes		XMCNG	Allow NULL?
31	UMXLN	Negative stocks allowed in storage location	char	1	0	CHAR	(N' ')	Yes		XLONG	Allow NULL?
32	UMXSV	Stock of ret. packaging w. cust. allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSVNG	Allow NULL?
33	UMXSM	RTP stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSMNG	Allow NULL?
34	RESWK	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
35	LEWED	Latest Possible Goods Receipt	nvarchar	8	0	DATS	(N'00000000')	Yes		LEWED	Allow NULL?
36	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
37	KANBA	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
38	SERNP	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	SERAIL	Allow NULL?
39	UMMLM	Material ledger activated at material level	char	1	0	CHAR	(N' ')	Yes		CK_ML_MAAC	Allow NULL?
40	UMKAL	Cost Estimate Number - Product Costing	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR1	Allow NULL?
41	VMVPR	Price Control Indicator in Previous Period	char	1	0	CHAR	(N' ')	Yes		VMVPR	Allow NULL?
42	UMVMV	Price control for prev. month - stock transfer line	char	1	0	CHAR	(N' ')	Yes		UMVMV	Allow NULL?
43	ANZL1	Number of Storage Units to be Placed Into Storage	decimal	3	0	DEC	((0))	Yes		LVS_ANZLE
44	ANZL2	Number of Storage Units to be Placed Into Storage	decimal	3	0	DEC	((0))	Yes		LVS_ANZLE
45	LMEN1	Quantity per Storage Unit to be Placed into Stock in Alt.UoM	decimal	13	3	QUAN	((0))	Yes		LVS_LEMEN
46	LMEN2	Quantity per Storage Unit to be Placed into Stock in Alt.UoM	decimal	13	3	QUAN	((0))	Yes		LVS_LEMEN
47	LETY1	Storage Unit Type	nvarchar	3	0	CHAR	(N' ')	Yes	T307	LVS_LETYP	Allow NULL?
48	LETY2	Storage Unit Type	nvarchar	3	0	CHAR	(N' ')	Yes	T307	LVS_LETYP	Allow NULL?
49	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
50	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
51	SONUM	Special Stock Number	nvarchar	16	0	CHAR	(N' ')	Yes		LVS_SONUM	Allow NULL?
52	UMSON	Special Stock Number	nvarchar	16	0	CHAR	(N' ')	Yes		LVS_SONUM	Allow NULL?
53	UMHKM	Material-related origin	char	1	0	CHAR	(N' ')	Yes		HKMAT	Allow NULL?
54	UMXVK	Sales price valuation active	char	1	0	CHAR	(N' ')	Yes		XVKBW	Allow NULL?
55	KZMHD	Check Best Before Date/Production Date	char	1	0	CHAR	(N' ')	Yes		KZMHD	Allow NULL?
56	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
57	MHDHB	Total shelf life	decimal	4	0	DEC	((0))	Yes		MHDHB
58	UMXCH	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
59	QM_ZUSTD	Batch status with status changed in QM (internal)	char	1	0	CHAR	(N' ')	Yes		QM_ZUSTD	Allow NULL?
60	QM_UMZST	Status of receiv. batch when status changed in QM (intern.)	char	1	0	CHAR	(N' ')	Yes		QM_UMZST	Allow NULL?
61	KZCLA	Option to classify batches	char	1	0	CHAR	(N' ')	Yes		KZCLA	Allow NULL?
62	MHDAT	SLED/Best-Before Date or Date of Production	nvarchar	8	0	DATS	(N'00000000')	Yes		TMHHD	Allow NULL?
63	ANZSN	Number of Serial Numbers/Pieces of Equipment to be Created	int	10	0	INT4	((0))	Yes		ANZSER	Allow NULL?
64	UMPRDHA	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	*	PRODH_D	Allow NULL?
65	UMSATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	SATNR	Allow NULL?
66	UMBWVOR	Procurement rule	char	1	0	CHAR	(N' ')	Yes	*	BWVOR	Allow NULL?
67	UMBWSCL	Source of Supply	char	1	0	CHAR	(N' ')	Yes	*	BWSCL	Allow NULL?
68	UMSAISO	Season Category	nvarchar	4	0	CHAR	(N' ')	Yes	*	SAISO	Allow NULL?
69	UMVOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	VOLEH	Allow NULL?
70	UMPLGTP	Price Band Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	PLGTP	Allow NULL?
71	UMSERVG	IS-R service level	char	1	0	CHAR	(N' ')	Yes	*	W_SERVGRD	Allow NULL?
72	EAN11_BME	International Article Number (EAN/UPC) in Order Unit	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11_BME	Allow NULL?
73	EAN11_KON	International Article Number (EAN/UPC) Check	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11_KON	Allow NULL?
74	EANME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
75	CLASS	Class number	nvarchar	18	0	CHAR	(N' ')	Yes		KLASSE_D	Allow NULL?
76	UMCLA	Class number	nvarchar	18	0	CHAR	(N' ')	Yes		KLASSE_D	Allow NULL?
77	QMAT_INAKT	X and Blank	char	1	0	CHAR	(N' ')	Yes		QKZ	Allow NULL?
78	CHSMM	Search procedure for batch determination	nvarchar	6	0	CHAR	(N' ')	Yes	*	KALSMA_CH	Allow NULL?
79	UMCHS	Search procedure for batch determination	nvarchar	6	0	CHAR	(N' ')	Yes	*	KALSMA_CH	Allow NULL?
80	XCLAS	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
81	UMXCL	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
82	RMVCT	Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	RMVCT	Allow NULL?
83	EK_VKWRT	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
84	EK_VKWRA	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
85	PKNUM	Control cycle number	nvarchar	7	0	CHAR	(N' ')	Yes	*	PKNUM	Allow NULL?
86	PKPOS	Kanban item number / control cycle item	nvarchar	3	0	NUMC	(N'000')	Yes		PKPOS	Allow NULL?
87	PKLVS	Requirement Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_BENUM	Allow NULL?
88	UMLIFCH	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ELIFN	Allow NULL?
89	UMLICHA	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
90	UMLWEDT	Date of last goods receipt	nvarchar	8	0	DATS	(N'00000000')	Yes		LWEDT	Allow NULL?
91	UMVFDAT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
92	UMHSDAT	Date of Manufacture	nvarchar	8	0	DATS	(N'00000000')	Yes		HSDAT	Allow NULL?
93	MHDAT_OLD	SLED/Best-Before Date or Date of Production	nvarchar	8	0	DATS	(N'00000000')	Yes		TMHHD	Allow NULL?
94	UMQNDAT	Next Inspection Date	nvarchar	8	0	DATS	(N'00000000')	Yes		QNPDAT	Allow NULL?
95	XKOKO	Cost element accounting	char	1	0	CHAR	(N' ')	Yes		XKOKO	Allow NULL?
96	UMAUT	Automatic Transfer Order Creation	char	1	0	CHAR	(N' ')	Yes	*	LVS_AUTTA	Allow NULL?
97	TBBEL	Material doc. no. of transfer requirement to be cancelled	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_TBBEL	Allow NULL?
98	TBBPO	Material doc. item of transf.reqmnt item to be cancelled	nvarchar	4	0	NUMC	(N'0000')	Yes		LVS_TBBPO	Allow NULL?
99	TBBJR	Material doc. year of transfer requirement to be cancelled	nvarchar	4	0	NUMC	(N'0000')	Yes		LVS_TBBJR	Allow NULL?
100	VFMNG	Confirmed quantity for availability check in SKU	decimal	15	3	QUAN	((0))	Yes		VMENG
101	CUOBJ	Internal object number	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBM	Allow NULL?
102	STDPD	Configurable material	nvarchar	18	0	CHAR	(N' ')	Yes	*	STDPD	Allow NULL?
103	TBPKZ	Indicator: No Transfer Requirement Created	char	1	0	CHAR	(N' ')	Yes		LVS_TBFKZ	Allow NULL?
104	TAFKZ	Indicator: do not cal up automatic TO creation	char	1	0	CHAR	(N' ')	Yes		LVS_TAFKZ	Allow NULL?
105	XWART	Indicates that the value-only material is to be inventoried	char	1	0	CHAR	(N' ')	Yes		XWART	Allow NULL?
106	DGLTS	Scheduled finish	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTRS	Allow NULL?
107	UMMEN	Quantity Updating in Material Master Record	char	1	0	CHAR	(N' ')	Yes		MENGU	Allow NULL?
108	UMXEI	Indicator: Purchase Account Processing is Active	char	1	0	CHAR	(N' ')	Yes		XEINK	Allow NULL?
109	DGLTP	Basic finish date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTRP	Allow NULL?
110	UMKZB	Movement Indicator	char	1	0	CHAR	(N' ')	Yes		KZBEW	Allow NULL?
111	UMMLA	Material Price Determination: Control	char	1	0	CHAR	(N' ')	Yes		CK_ML_ABST	Allow NULL?
112	UMSAISJ	Season Year	nvarchar	4	0	CHAR	(N' ')	Yes		SAISJ	Allow NULL?
113	EQUMG	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
114	XEXEQ	Exclusive enqueue for MBEW required	char	1	0	CHAR	(N' ')	Yes		XEXEQ	Allow NULL?
115	UMXEXEQ	Exclusive enqueue for MBEW required	char	1	0	CHAR	(N' ')	Yes		XEXEQ	Allow NULL?
116	GLMNG	Quantity Delivered (Stock Transfer)	decimal	13	3	QUAN	((0))	Yes		GLMNG
117	UMKZBAA	Indicator: valuation type is set automatically	char	1	0	CHAR	(N' ')	Yes		KZBAA	Allow NULL?
118	DIRTA	Automatic TO Creation Immediately After TR Generation	char	1	0	CHAR	(N' ')	Yes		LVS_DIRTA	Allow NULL?
119	UMSERNP	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	SERAIL	Allow NULL?
120	KZECH	Determination of batch entry in the production/process order	char	1	0	CHAR	(N' ')	Yes		KZECH	Allow NULL?
121	FCHAR	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
122	XKCFC	Extended classification via CFC	char	1	0	CHAR	(N' ')	Yes		XKCFC	Allow NULL?
123	KZCHP	Indicator: Check of the batch entered is active	char	1	0	CHAR	(N' ')	Yes		KZCHP	Allow NULL?
124	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	*	INFNR	Allow NULL?
125	BWSPA	Valuation margin	decimal	6	2	DEC	((0))	Yes		BWSPA
126	UPVOR	Subitems Exist	char	1	0	CHAR	(N' ')	Yes		UPVOR	Allow NULL?
127	UPTYP	Subitem Category, Purchasing Document	char	1	0	CHAR	(N' ')	Yes	*	UPTYP	Allow NULL?
128	MEKOR	Indicates quantity correlation	char	1	0	CHAR	(N' ')	Yes		MEKOR	Allow NULL?
129	UEZEI	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
130	UEBPO	Higher-Level Item in Purchasing Documents	nvarchar	5	0	NUMC	(N'00000')	Yes	*	UEBPO	Allow NULL?
131	LWMNG	Quantity Reduced (MRP)	decimal	13	3	QUAN	((0))	Yes		DABMG
132	LWSBS	GR blocked stock in order unit per shipping notif. item	decimal	13	3	QUAN	((0))	Yes		LWSBS
133	XWMHD	Check Best Before Date/Production Date	char	1	0	CHAR	(N' ')	Yes		XWMHD	Allow NULL?
134	LAMNG	Quantity as Per Vendor Confirmation	decimal	13	3	QUAN	((0))	Yes		BBMNG
135	PRVBE	Production Supply Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRVBE	Allow NULL?
136	VEXVK	Externally Entered Sales Value in Local Currency	decimal	13	2	CURR	((0))	Yes		EXVKW
137	RBLVS	Reference movement type for WM from material movements	nvarchar	3	0	NUMC	(N'000')	Yes		RBLVS	Allow NULL?
138	UMRBL	Reference movement type for transfer in warehouse mgmt	nvarchar	3	0	NUMC	(N'000')	Yes		LVS_UMRBL	Allow NULL?
139	UMRBU	Reference movement type for posting change in whse mgmt	nvarchar	3	0	NUMC	(N'000')	Yes		LVS_UMRBU	Allow NULL?
140	PARWK	Plant involved in settlement	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARWK	Allow NULL?
141	KTOMA	Acct entered manually	char	1	0	CHAR	(N' ')	Yes		KTOMA	Allow NULL?
142	XLBPD	Price difference posting in GR for subcontract oder	char	1	0	CHAR	(N' ')	Yes		XLBPD	Allow NULL?
143	XBNSB	Debit delivery costs separately	char	1	0	CHAR	(N' ')	Yes		XBNSB	Allow NULL?
144	XWAIT	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
145	XNOEQ	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
146	XSKNG	Consignment stock from vendor allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSKNG	Allow NULL?
147	XSONG	Stock of material prov. to vendor allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSONG	Allow NULL?
148	XSWNG	Consignment Stock with Customer Allowed to Become Negative	char	1	0	CHAR	(N' ')	Yes		XSWNG	Allow NULL?
149	UMXSK	Consignment stock from vendor allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSKNG	Allow NULL?
150	UMXSO	Stock of material prov. to vendor allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSONG	Allow NULL?
151	UMXSW	Consignment Stock with Customer Allowed to Become Negative	char	1	0	CHAR	(N' ')	Yes		XSWNG	Allow NULL?
152	XEWRX	Post purchase account with receipt value	char	1	0	CHAR	(N' ')	Yes		XEWRX	Allow NULL?
153	X2FDO	Two FI documents with purchase account	char	1	0	CHAR	(N' ')	Yes		X2FDO	Allow NULL?
154	UMVKW	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
155	UMVKA	Value at sales prices excluding value-added tax	decimal	13	2	CURR	((0))	Yes		VKWRA
156	XSENG	Sales order stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSENG	Allow NULL?
157	XSQNG	Project stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSQNG	Allow NULL?
158	UMXSE	Sales order stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSENG	Allow NULL?
159	UMXSQ	Project stock allowed to become negative	char	1	0	CHAR	(N' ')	Yes		XSQNG	Allow NULL?
160	AREWW	Clearing value on GR/IR clearing account (transac. currency)	decimal	13	2	CURR	((0))	Yes		AREWW
161	MHDLG	Minimum Remaining Shelf Life (8-Char. Calculation Field)	decimal	8	0	DEC	((0))	Yes		MHDLG
162	VWERW	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
163	KZWSO	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
164	UMATT	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
165	KZKUB	Indicator: Do not create posting change notice	char	1	0	CHAR	(N' ')	Yes		LVS_KZKUB	Allow NULL?
166	UBTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	LGTYP	Allow NULL?
167	UBLGP	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	LGPLA	Allow NULL?
168	UMKZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
169	SETKZBWS	KZWBS was set	char	1	0	CHAR	(N' ')	Yes		SETKZBWS	Allow NULL?
170	UMKZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
171	KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	nvarchar	6	0	CHAR	(N' ')	Yes	*	KALSM_D	Allow NULL?
172	UMKALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR	Allow NULL?
173	URERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
174	URVERMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
175	UMMTA	Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	MTART	Allow NULL?
176	MBBME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
177	MLBWG	Movement Type Group for ML Update	nvarchar	2	0	CHAR	(N' ')	Yes	*	CKML_MLBWG	Allow NULL?
178	UMXSTAU	Break down structure	char	1	0	CHAR	(N' ')	Yes		XSTAU	Allow NULL?
179	UMXHEAD	Indicates header of structured material	char	1	0	CHAR	(N' ')	Yes		XHEAD	Allow NULL?
180	EKALR	Material Is Costed with Quantity Structure	char	1	0	CHAR	(N' ')	Yes		CK_EKALREL	Allow NULL?
181	UMEKALR	Material Is Costed with Quantity Structure	char	1	0	CHAR	(N' ')	Yes		CK_EKALREL	Allow NULL?
182	EPRIO	Withdrawal sequence group for stocks	nvarchar	4	0	CHAR	(N' ')	Yes	*	EPRIO	Allow NULL?
183	UMEPR	Withdrawal sequence group for stocks	nvarchar	4	0	CHAR	(N' ')	Yes	*	EPRIO	Allow NULL?
184	RULES	Stock determination rule	nvarchar	4	0	CHAR	(N' ')	Yes	*	BF_RULES	Allow NULL?
185	AUFPL_ORD	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
186	APLZL_ORD	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	CO_APLZL	Allow NULL?
187	XERSY	Evaluated Receipt Settlement (ERS)	char	1	0	CHAR	(N' ')	Yes		XERSY	Allow NULL?
188	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	MPROF	Allow NULL?
189	MFRNR	Number of a Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	*	MFRNR	Allow NULL?
190	ELIKZ_INPUT	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
191	UMLGNTB	Do not adopt storage location into transfer requirement	char	1	0	CHAR	(N' ')	Yes		LVS_LGNTB	Allow NULL?
192	XOARC	Storage upon goods movements active	char	1	0	CHAR	(N' ')	Yes		XOARC	Allow NULL?
193	XBEWM	Valuation based on the batch-specific unit of measure	char	1	0	CHAR	(N' ')	Yes		XBEWW	Allow NULL?
194	UMXBEWM	Valuation based on the batch-specific unit of measure	char	1	0	CHAR	(N' ')	Yes		XBEWW	Allow NULL?
195	KZEAR_INP	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
196	VUMVKW	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
197	ORZEIL	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
198	MTUSE	Usage of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATUSE	Allow NULL?
199	NFVAL	Net Value	decimal	15	2	CURR	((0))	Yes		J_1BNETVAL
200	JV_CRPCALC	Flag CRP Calculation: Yes or NO	char	1	0	CHAR	(N' ')	Yes		JV_CRPCAL	Allow NULL?
201	JV_RECIND	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_RECIND	Allow NULL?
202	HSDAT_INPUT	Date of Manufacture	nvarchar	8	0	DATS	(N'00000000')	Yes		HSDAT	Allow NULL?
203	VFDAT_INPUT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
204	UMXWMHD	Check Best Before Date/Production Date	char	1	0	CHAR	(N' ')	Yes		XWMHD	Allow NULL?
205	UMMHDHB	Total shelf life	decimal	4	0	DEC	((0))	Yes		MHDHB
206	UMMHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
207	BWTAR_XMBWL	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
208	UMBWTAR_XMBWL	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
209	RDMHD	Rounding rule for calculation of SLED	char	1	0	CHAR	(N' ')	Yes		RDMHD	Allow NULL?
210	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
211	IPRKZ_HBD	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
212	UMIPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
213	ESTAK	Status of Purchasing Document	char	1	0	CHAR	(N' ')	Yes		ESTAK	Allow NULL?
214	MBLFM	Period of MBEW or EBEW or QBEW	nvarchar	2	0	NUMC	(N'00')	Yes		MBLFM	Allow NULL?
215	MBGJA	Fiscal year of MBEW or EBEW or QBEW	nvarchar	4	0	NUMC	(N'0000')	Yes		MBGJA	Allow NULL?
216	RMBEWH	Ind.: MBEWH/EBEWH/QBEWH for prev. period could not be read	char	1	0	CHAR	(N' ')	Yes		RMBEWH	Allow NULL?
217	MBRUE	MBEWH rec. already exists for per. before last of MBEW per.	char	1	0	CHAR	(N' ')	Yes		MBRUE	Allow NULL?
218	XSAUT	Create serial number automatically	char	1	0	CHAR	(N' ')	Yes		XSAUT	Allow NULL?
219	UMMBLFM	Period of MBEW or EBEW or QBEW	nvarchar	2	0	NUMC	(N'00')	Yes		MBLFM	Allow NULL?
220	UMMBGJA	Fiscal year of MBEW or EBEW or QBEW	nvarchar	4	0	NUMC	(N'0000')	Yes		MBGJA	Allow NULL?
221	UMRMBEWH	Ind.: MBEWH/EBEWH/QBEWH for prev. period could not be read	char	1	0	CHAR	(N' ')	Yes		RMBEWH	Allow NULL?
222	UMMBRUE	MBEWH rec. already exists for per. before last of MBEW per.	char	1	0	CHAR	(N' ')	Yes		MBRUE	Allow NULL?
223	GWEMG	Quantity of Goods Received	decimal	13	3	QUAN	((0))	Yes		WEMNG
224	XREFC	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
225	UCUOB	Internal object number	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBM	Allow NULL?
226	USTDP	Configurable material	nvarchar	18	0	CHAR	(N' ')	Yes	*	STDPD	Allow NULL?
227	PRERR	Price determination error at time of goods receipt	nvarchar	12	0	CHAR	(N' ')	Yes		PRERR	Allow NULL?
228	FRLFD	Earliest delivery date	nvarchar	8	0	DATS	(N'00000000')	Yes		FRLFD	Allow NULL?
229	XEXIT	Cancel item (dialog)	char	1	0	CHAR	(N' ')	Yes		XEXIT	Allow NULL?
230	VBELN_VL	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
231	VBELP_VL	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
232	KZXAB	GR/GI slip number is active	char	1	0	CHAR	(N' ')	Yes		KZXAB	Allow NULL?
233	UMKZXAB	GR/GI slip number is active	char	1	0	CHAR	(N' ')	Yes		KZXAB	Allow NULL?
234	UEKLA	Segment string EKLA	nvarchar	3	0	CHAR	(N' ')	Yes		SEKLA_D	Allow NULL?
235	UMXLAUT	Automatic creation of storage location allowed	char	1	0	CHAR	(N' ')	Yes		XLAUT	Allow NULL?
236	XVASH	Main item with supplementary logistics services	char	1	0	CHAR	(N' ')	Yes		XVASH	Allow NULL?
237	UMBFLME	Generic Material with Logistical Variants	char	1	0	CHAR	(N' ')	Yes		BFLME	Allow NULL?
238	KSTAR	Account number	nvarchar	16	0	CHAR	(N' ')	Yes		KONTO	Allow NULL?
239	ORUML	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?

TOP ERP 6.0 | MWZDM07M2 INDEXES

Name	Primary	Unique	Type	Columns
MWZDM07M2~0	Yes	Yes	CLUSTERED	ZEILE, MJAHR, MBLNR, 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

239 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M2 TABLE

TOP ERP 6.0 | MWZDM07M2 COLUMNS

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

239 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M2 TABLE

TOPERP 6.0 | MWZDM07M2 COLUMNS

TOPERP 6.0 | MWZDM07M2 INDEXES

TOP ERP 6.0 | MWZDM07M2 COLUMNS

TOP ERP 6.0 | MWZDM07M2 INDEXES