	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

235 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M1 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MWZDM07M1	235	1	ZDM07M1	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, ZEILD, EXWRT, KONTO, XKMAN, FAUSW, XCHAR, MAKTX, MATKL, TXART, RMBEW, XLORT, KZZDE, KZDRU, XLIFO, VMENG, VERMG, VBSMG, VBPMG, VWERT, VVKWR, VWERR, VWALT, VWERE, BTEXT, XEINK, KTOPL, PERIV, BWMOD, BKLAS, EKLAS, QKLAS, OKLAS, BWTTY, PEINH, STPRS, VERPR, SALKV, VKSAL, VMKUM, VMSAL, VMPEI, VMSTP, VMVER, VMSAV, KZVBL, KZVBU, PERKZ, PERIM, VZBEW, KNTTP, BSTYP, NAME1, ORT01, PSTLZ, INCO1, INCO2, UMREZ, UMREN, BPUMZ, BPUMN, BSMNG, BPBMG, UETMG, UNTMG, WAMNG, WAWRT, WESBS, BPWES, WEMNG, WWMNG, MB_BPRME, BPWEM, BPWWM, WEWRT, REMNG, BPREM, MULKO, REWRT, AREWR, XELIK, SPERQ, SSQSS, ZGTYP, XZGVH, INSNC, KZUML, UMRMB, UMBUK, UMBWK, UMXLI, UMHRK, UMGJA, UMMON, UMXRM, UMXRJ, UMLFG, UMLFM, UMTYP, UMWAE, UMVWE, UMVWR, UMBUA, UMVWA, UMPEI, UMVPR, UMGSB, UMPRC, UMKPL, UMPER, UMBWM, UMBKL, UMEKL, UMQKL, UMOKL, UMLBK, UMSAL, UMSTP, UMVER, UMSAV, UMVKS, UMVKU, UMVSA, UMVPE, UMVSP, UMVVP, UMVMS, UMWER, UMMYK, UMKZV, UMMTV, UMFAB, UMPLI, UMEIS, UMMINBE, UMWEB, UMWZE, UMBES, UMUML, UMXQS, UMSOF, UMSOL, UMSOV, UMARC, UMARD, UMCHB, UMBPR, UMLIB, UMKOL, UMEIK, UMKLK, UMKUB, UEKPO, UFAUP, UMRES, UMSKU, UMSLB, UMSSL, UMSKA, UMSSA, UMSPR, UMSSQ, UMSCA, UMSOA, UMSCP, UMSOP, UMLBB, UMKBB, UMDIS, UMDIT, UMXPB, UMMIS, UMVRM, UMVI1, UMVI2, UMBDT, KZVBP, PLIFZ, UMLMC, WEBAZ, WZEIT, ATPM1, BESKZ, UBFKZ, UMLGN, UMLGT, UMLGP, UMBSQ, UMBLV, UMXBL, UMVOS, UMNAS, UMDYP, UMTBF, UMTRA, UMBTY, UMBEN, UMTBP, UMWKZ, UMBKZ, WENUM, MBLMG, MBLBM, MBBMG, FABKL, RSHKZ, BDMNG, ENMNG, BDART, ENWRT, RLGOR, RCHAR, KONPR, KOPEI, ANZRE, ANBWA, LNRAN, BEWAR, VMVKS, UMVMVKS, UMXHUPF, UMVKORG, UMVSTEL, UMVTWEG, UMSPART, UMSDLIF, UMSDKUN, UISEG, UMIBPOI, IMSEG_ORIGINAL, UMDISMM, PARBW FROM MWZDM07M1

TOP ERP 6.0 | MWZDM07M1 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	ZEILD	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
6	EXWRT	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
7	KONTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	SAKNR	Allow NULL?
8	XKMAN	Account entered manually	char	1	0	CHAR	(N' ')	Yes		XKMAN	Allow NULL?
9	FAUSW	Field Selection String	nvarchar	128	0	CHAR	(N' ')	Yes		FAUSW	Allow NULL?
10	XCHAR	Batch management indicator (internal)	char	1	0	CHAR	(N' ')	Yes		XCHAR	Allow NULL?
11	MAKTX	Material Description (Short Text)	nvarchar	40	0	CHAR	(N' ')	Yes		MAKTX	Allow NULL?
12	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
13	TXART	Text type in material master record (purchasing/sales)	char	1	0	CHAR	(N' ')	Yes		TXART	Allow NULL?
14	RMBEW	Return code MBEW	char	1	0	CHAR	(N' ')	Yes		RMBEW	Allow NULL?
15	XLORT	Storage location necessary	char	1	0	CHAR	(N' ')	Yes		XLORT	Allow NULL?
16	KZZDE	Maintain status data of a batch	char	1	0	CHAR	(N' ')	Yes		KZZDE	Allow NULL?
17	KZDRU	Printing of document item	char	1	0	CHAR	(N' ')	Yes	*	KZDRU	Allow NULL?
18	XLIFO	LIFO/FIFO-Relevant	char	1	0	CHAR	(N' ')	Yes		XLIFO	Allow NULL?
19	VMENG	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
20	VERMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
21	VBSMG	Goods receipt quantity in order unit	decimal	13	3	QUAN	((0))	Yes		MB_BSTMG
22	VBPMG	Goods Receipt Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPWEM
23	VWERT	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
24	VVKWR	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
25	VWERR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
26	VWALT	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
27	VWERE	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
28	BTEXT	Movement Type Text (Inventory Management)	nvarchar	20	0	CHAR	(N' ')	Yes		BWTXT	Allow NULL?
29	XEINK	Indicator: Purchase Account Processing is Active	char	1	0	CHAR	(N' ')	Yes		XEINK	Allow NULL?
30	KTOPL	Chart of Accounts	nvarchar	4	0	CHAR	(N' ')	Yes	T004	KTOPL	Allow NULL?
31	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
32	BWMOD	Valuation Grouping Code	nvarchar	4	0	CHAR	(N' ')	Yes		BWMOD	Allow NULL?
33	BKLAS	Valuation Class	nvarchar	4	0	CHAR	(N' ')	Yes	T025	BKLAS	Allow NULL?
34	EKLAS	Valuation Class for Sales Order Stock	nvarchar	4	0	CHAR	(N' ')	Yes	*	EKLAS	Allow NULL?
35	QKLAS	Valuation Class for Project Stock	nvarchar	4	0	CHAR	(N' ')	Yes	*	QKLAS	Allow NULL?
36	OKLAS	Valuation Class for Special Stock at the Vendor	nvarchar	4	0	CHAR	(N' ')	Yes	*	OKLAS	Allow NULL?
37	BWTTY	Valuation Category	char	1	0	CHAR	(N' ')	Yes	T149C	BWTTY_D	Allow NULL?
38	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
39	STPRS	Standard price	decimal	11	2	CURR	((0))	Yes		STPRS
40	VERPR	Moving Average Price/Periodic Unit Price	decimal	11	2	CURR	((0))	Yes		VERPR
41	SALKV	Value based on moving average price (only with price ctrl S)	decimal	13	2	CURR	((0))	Yes		SALKV
42	VKSAL	Value of Total Valuated Stock at Sales Price	decimal	13	2	CURR	((0))	Yes		VKSAL
43	VMKUM	Total valuated stock in previous period	decimal	13	3	QUAN	((0))	Yes		VMKUM
44	VMSAL	Value of total valuated stock in previous period	decimal	13	2	CURR	((0))	Yes		VMSAL
45	VMPEI	Price unit of previous period	decimal	5	0	DEC	((0))	Yes		VMPEI
46	VMSTP	Standard price in the previous period	decimal	11	2	CURR	((0))	Yes		VMSTP
47	VMVER	Moving Average Price/Periodic Unit Price in Previous Period	decimal	11	2	CURR	((0))	Yes		VMVER
48	VMSAV	Value based on moving average price (previous period)	decimal	13	2	CURR	((0))	Yes		VMSAV
49	KZVBL	Arithmetic	char	1	0	CHAR	(N' ')	Yes		KZARI	Allow NULL?
50	KZVBU	Consumption posting	char	1	0	CHAR	(N' ')	Yes		KZVBU	Allow NULL?
51	PERKZ	Period Indicator	char	1	0	CHAR	(N' ')	Yes		PERKZ	Allow NULL?
52	PERIM	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
53	VZBEW	Sign (+/-) of Material Posting	char	1	0	CHAR	(N' ')	Yes		VZBEW	Allow NULL?
54	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
55	BSTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		BSTYP	Allow NULL?
56	NAME1	Name	nvarchar	30	0	CHAR	(N' ')	Yes		NAME1	Allow NULL?
57	ORT01	City	nvarchar	25	0	CHAR	(N' ')	Yes		ORT01	Allow NULL?
58	PSTLZ	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
59	INCO1	Incoterms (Part 1)	nvarchar	3	0	CHAR	(N' ')	Yes	TINC	INCO1	Allow NULL?
60	INCO2	Incoterms (Part 2)	nvarchar	28	0	CHAR	(N' ')	Yes		INCO2	Allow NULL?
61	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0	DEC	((0))	Yes		UMREZ
62	UMREN	Denominator for conversion to base units of measure	decimal	5	0	DEC	((0))	Yes		UMREN
63	BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMZ
64	BPUMN	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMN
65	BSMNG	Quantity Ordered	decimal	13	3	QUAN	((0))	Yes		BESTM
66	BPBMG	Purchase order quantity in order price unit	decimal	13	3	QUAN	((0))	Yes		BPBMG
67	UETMG	Overdelivery tolerance (quantity)	decimal	13	3	QUAN	((0))	Yes		UETMG
68	UNTMG	Underdelivery Tolerance (Quantity)	decimal	13	3	QUAN	((0))	Yes		UNTMG
69	WAMNG	Issued Quantity	decimal	13	3	QUAN	((0))	Yes		WAMNG
70	WAWRT	Sum of the values of goods issues	decimal	13	2	CURR	((0))	Yes		WAWRT
71	WESBS	Goods Receipt Blocked Stock in Order Unit	decimal	13	3	QUAN	((0))	Yes		WESBS
72	BPWES	Quantity in GR blocked stock in order price unit	decimal	13	3	QUAN	((0))	Yes		BPWES
73	WEMNG	Quantity of Goods Received	decimal	13	3	QUAN	((0))	Yes		WEMNG
74	WWMNG	Valuated goods receipt quantity	decimal	13	3	QUAN	((0))	Yes		WWMNG
75	MB_BPRME	Quantity in Purchase Order Price Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MB_BPRME	Allow NULL?
76	BPWEM	Goods Receipt Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPWEM
77	BPWWM	Valuated Goods Receipt Quantity in Order Unit	decimal	13	3	QUAN	((0))	Yes		BPWWM
78	WEWRT	Value of goods received in local currency	decimal	13	2	CURR	((0))	Yes		WEWRT
79	REMNG	Quantity invoiced	decimal	13	3	QUAN	((0))	Yes		REMNG
80	BPREM	Invoice receipt quantity in order price unit	decimal	13	3	QUAN	((0))	Yes		BPREM
81	MULKO	Indicator: Multiple account assignment	char	1	0	CHAR	(N' ')	Yes		MULKO	Allow NULL?
82	REWRT	Invoice value in local currency	decimal	13	2	CURR	((0))	Yes		REWRT
83	AREWR	GR/IR account clearing value in local currency	decimal	13	2	CURR	((0))	Yes		AREWR
84	XELIK	Suggest "delivery completed" indicator	char	1	0	CHAR	(N' ')	Yes		XELIK	Allow NULL?
85	SPERQ	Function That Will Be Blocked	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSPERRFKT	Allow NULL?
86	SSQSS	Control Key for Quality Management in Procurement	nvarchar	8	0	CHAR	(N' ')	Yes	*	QSSPUR	Allow NULL?
87	ZGTYP	Certificate Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	QZGTYP	Allow NULL?
88	XZGVH	Processing of certificate in procurement active	char	1	0	CHAR	(N' ')	Yes		XZGVH	Allow NULL?
89	INSNC	Quality inspection indicator cannot be changed	char	1	0	CHAR	(N' ')	Yes		INSNC	Allow NULL?
90	KZUML	Stock transfer/transfer posting	char	1	0	CHAR	(N' ')	Yes		KZUML	Allow NULL?
91	UMRMB	Return code MBEW	char	1	0	CHAR	(N' ')	Yes		RMBEW	Allow NULL?
92	UMBUK	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
93	UMBWK	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	T001K	BWKEY	Allow NULL?
94	UMXLI	LIFO/FIFO-Relevant	char	1	0	CHAR	(N' ')	Yes		XLIFO	Allow NULL?
95	UMHRK	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	Yes	*	HRKFT	Allow NULL?
96	UMGJA	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
97	UMMON	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
98	UMXRM	Allow Posting to Previous Period (Backposting)	char	1	0	CHAR	(N' ')	Yes		XRUEM	Allow NULL?
99	UMXRJ	Indicator: post to previous year	char	1	0	CHAR	(N' ')	Yes		XRUEJ	Allow NULL?
100	UMLFG	Fiscal Year of Current Period	nvarchar	4	0	NUMC	(N'0000')	Yes		LFGJA	Allow NULL?
101	UMLFM	Current period (posting period)	nvarchar	2	0	NUMC	(N'00')	Yes		LFMON	Allow NULL?
102	UMTYP	Valuation Category	char	1	0	CHAR	(N' ')	Yes	T149C	BWTTY_D	Allow NULL?
103	UMWAE	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
104	UMVWE	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
105	UMVWR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
106	UMBUA	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
107	UMVWA	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
108	UMPEI	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
109	UMVPR	Price control indicator	char	1	0	CHAR	(N' ')	Yes		VPRSV	Allow NULL?
110	UMGSB	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
111	UMPRC	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
112	UMKPL	Chart of Accounts	nvarchar	4	0	CHAR	(N' ')	Yes	T004	KTOPL	Allow NULL?
113	UMPER	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
114	UMBWM	Valuation Grouping Code	nvarchar	4	0	CHAR	(N' ')	Yes		BWMOD	Allow NULL?
115	UMBKL	Valuation Class	nvarchar	4	0	CHAR	(N' ')	Yes	T025	BKLAS	Allow NULL?
116	UMEKL	Valuation Class for Sales Order Stock	nvarchar	4	0	CHAR	(N' ')	Yes	*	EKLAS	Allow NULL?
117	UMQKL	Valuation Class for Project Stock	nvarchar	4	0	CHAR	(N' ')	Yes	*	QKLAS	Allow NULL?
118	UMOKL	Valuation Class for Special Stock at the Vendor	nvarchar	4	0	CHAR	(N' ')	Yes	*	OKLAS	Allow NULL?
119	UMLBK	Total Valuated Stock	decimal	13	3	QUAN	((0))	Yes		LBKUM
120	UMSAL	Value of Total Valuated Stock	decimal	13	2	CURR	((0))	Yes		SALK3
121	UMSTP	Standard price	decimal	11	2	CURR	((0))	Yes		STPRS
122	UMVER	Moving Average Price/Periodic Unit Price	decimal	11	2	CURR	((0))	Yes		VERPR
123	UMSAV	Value based on moving average price (only with price ctrl S)	decimal	13	2	CURR	((0))	Yes		SALKV
124	UMVKS	Value of Total Valuated Stock at Sales Price	decimal	13	2	CURR	((0))	Yes		VKSAL
125	UMVKU	Total valuated stock in previous period	decimal	13	3	QUAN	((0))	Yes		VMKUM
126	UMVSA	Value of total valuated stock in previous period	decimal	13	2	CURR	((0))	Yes		VMSAL
127	UMVPE	Price unit of previous period	decimal	5	0	DEC	((0))	Yes		VMPEI
128	UMVSP	Standard price in the previous period	decimal	11	2	CURR	((0))	Yes		VMSTP
129	UMVVP	Moving Average Price/Periodic Unit Price in Previous Period	decimal	11	2	CURR	((0))	Yes		VMVER
130	UMVMS	Value based on moving average price (previous period)	decimal	13	2	CURR	((0))	Yes		VMSAV
131	UMWER	Value Update in Material Master Record	char	1	0	CHAR	(N' ')	Yes		WERTU	Allow NULL?
132	UMMYK	LIFO valuation level	nvarchar	4	0	CHAR	(N' ')	Yes	T001Y	MYKEY	Allow NULL?
133	UMKZV	+/- sign for consumption update in material master record	char	1	0	CHAR	(N' ')	Yes		KZVBL	Allow NULL?
134	UMMTV	Checking Group for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	*	MTVFP	Allow NULL?
135	UMFAB	Factory calendar key	nvarchar	2	0	CHAR	(N' ')	Yes	*	FABKL	Allow NULL?
136	UMPLI	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
137	UMEIS	Safety Stock	decimal	13	3	QUAN	((0))	Yes		EISBE
138	UMMINBE	Reorder Point	decimal	13	3	QUAN	((0))	Yes		MINBE
139	UMWEB	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
140	UMWZE	Total replenishment lead time (in workdays)	decimal	3	0	DEC	((0))	Yes		WZEIT
141	UMBES	Procurement Type	char	1	0	CHAR	(N' ')	Yes		BESKZ	Allow NULL?
142	UMUML	Stock in Transfer (Plant to Plant)	decimal	13	3	QUAN	((0))	Yes		UMLME
143	UMXQS	No Manual Inventory Posting for QM-Relevant Material	char	1	0	CHAR	(N' ')	Yes		QQSSP	Allow NULL?
144	UMSOF	Special stock ind.: Accounting/bookkeeping assignment	char	1	0	CHAR	(N' ')	Yes		SOBFI	Allow NULL?
145	UMSOL	Special stock indicator: Logistics assignment	char	1	0	CHAR	(N' ')	Yes		SOBLO	Allow NULL?
146	UMSOV	Special stock indicator: Transaction assignment	char	1	0	CHAR	(N' ')	Yes		SOBVO	Allow NULL?
147	UMARC	Segment string MARC	nvarchar	3	0	CHAR	(N' ')	Yes		SMARC_D	Allow NULL?
148	UMARD	Segment string MARD	nvarchar	3	0	CHAR	(N' ')	Yes		SMARD_D	Allow NULL?
149	UMCHB	Segment string MCHB	nvarchar	3	0	CHAR	(N' ')	Yes		SMCHB_D	Allow NULL?
150	UMBPR	Segment string MBPR	nvarchar	3	0	CHAR	(N' ')	Yes		SMBPR	Allow NULL?
151	UMLIB	Segment string	nvarchar	3	0	CHAR	(N' ')	Yes		SMLIB	Allow NULL?
152	UMKOL	Segment string MKOL	nvarchar	3	0	CHAR	(N' ')	Yes		SMKOL_D	Allow NULL?
153	UMEIK	Segment string MEIK	nvarchar	3	0	CHAR	(N' ')	Yes		SMEIK	Allow NULL?
154	UMKLK	Segment string MKLK	nvarchar	3	0	CHAR	(N' ')	Yes		SMKLK	Allow NULL?
155	UMKUB	Segment string MKVB	nvarchar	3	0	CHAR	(N' ')	Yes		SMKUB	Allow NULL?
156	UEKPO	Segment string EKPO	nvarchar	3	0	CHAR	(N' ')	Yes		SEKPO_D	Allow NULL?
157	UFAUP	Segment string FAUP	nvarchar	3	0	CHAR	(N' ')	Yes		SFAUP_D	Allow NULL?
158	UMRES	Segment string MRES	nvarchar	3	0	CHAR	(N' ')	Yes		SMRES_D	Allow NULL?
159	UMSKU	Segment string MSKU	nvarchar	3	0	CHAR	(N' ')	Yes		SMSKU_D	Allow NULL?
160	UMSLB	Segment string MSLB	nvarchar	3	0	CHAR	(N' ')	Yes		SMSLB_D	Allow NULL?
161	UMSSL	Segment string MSSL	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSL_D	Allow NULL?
162	UMSKA	Segment string MSKA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSKA_D	Allow NULL?
163	UMSSA	Segment string MSSA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSA_D	Allow NULL?
164	UMSPR	Segment string MSPR	nvarchar	3	0	CHAR	(N' ')	Yes		SMSPR_D	Allow NULL?
165	UMSSQ	Segment string MSSQ	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSQ_D	Allow NULL?
166	UMSCA	Segment string MSCA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSCA	Allow NULL?
167	UMSOA	Segment string MSOA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSOA	Allow NULL?
168	UMSCP	Segment string MSCP	nvarchar	3	0	CHAR	(N' ')	Yes		SMSCP	Allow NULL?
169	UMSOP	Segment string MSOP	nvarchar	3	0	CHAR	(N' ')	Yes		SMSOP	Allow NULL?
170	UMLBB	Stock Type of Goods Movement (Primary Posting)	nvarchar	2	0	CHAR	(N' ')	Yes	*	LBBSA	Allow NULL?
171	UMKBB	Stock Type of Goods Movement (Complementary Posting)	nvarchar	2	0	CHAR	(N' ')	Yes	*	KBBSA	Allow NULL?
172	UMDIS	Storage location MRP indicator	char	1	0	CHAR	(N' ')	Yes		DISKZ	Allow NULL?
173	UMDIT	Low-Level Code	nvarchar	3	0	CHAR	(N' ')	Yes		DISST	Allow NULL?
174	UMXPB	Requirements reduction upon goods movements	char	1	0	CHAR	(N' ')	Yes		XPBED	Allow NULL?
175	UMMIS	Mixed MRP indicator	char	1	0	CHAR	(N' ')	Yes		MISKZ	Allow NULL?
176	UMVRM	Consumption mode	char	1	0	CHAR	(N' ')	Yes		VRMOD	Allow NULL?
177	UMVI1	Consumption period: backward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT1	Allow NULL?
178	UMVI2	Consumption period: forward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT2	Allow NULL?
179	UMBDT	Requirement Date for the Component	nvarchar	8	0	DATS	(N'00000000')	Yes		BDTER	Allow NULL?
180	KZVBP	Dynamic availability check for goods movement	char	1	0	CHAR	(N' ')	Yes		KZVBP	Allow NULL?
181	PLIFZ	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
182	UMLMC	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
183	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
184	WZEIT	Total replenishment lead time (in workdays)	decimal	3	0	DEC	((0))	Yes		WZEIT
185	ATPM1	ATP quantity	decimal	13	3	QUAN	((0))	Yes		MNG04
186	BESKZ	Procurement Type	char	1	0	CHAR	(N' ')	Yes		BESKZ	Allow NULL?
187	UBFKZ	Indicator: Creation of a Posting Change Notice	char	1	0	CHAR	(N' ')	Yes		T321_UBFKZ	Allow NULL?
188	UMLGN	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
189	UMLGT	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LGTYP	Allow NULL?
190	UMLGP	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	LAGP	LGPLA	Allow NULL?
191	UMBSQ	Stock Category in the Warehouse Management System	char	1	0	CHAR	(N' ')	Yes		BESTQ	Allow NULL?
192	UMBLV	Movement Type for Warehouse Management	nvarchar	3	0	NUMC	(N'000')	Yes	T333	BWLVS	Allow NULL?
193	UMXBL	Indicator: posting in warehouse management system	char	1	0	CHAR	(N' ')	Yes		XBLVS	Allow NULL?
194	UMVOS	Ind: interim storage posting for source stor.type and bin	char	1	0	CHAR	(N' ')	Yes		T333_VSCHN	Allow NULL?
195	UMNAS	Ind.: interim storage posting for dest.stor.type and bin	char	1	0	CHAR	(N' ')	Yes		T333_NSCHN	Allow NULL?
196	UMDYP	Indicator: dynamic storage bin	char	1	0	CHAR	(N' ')	Yes		DYPLA	Allow NULL?
197	UMTBF	Indicator: Creation/Cancellation of a Transfer Requirement	char	1	0	CHAR	(N' ')	Yes		T321_TBFKZ	Allow NULL?
198	UMTRA	Shipment Type	char	1	0	CHAR	(N' ')	Yes	T333A	LVS_TRART	Allow NULL?
199	UMBTY	Requirement Type	char	1	0	CHAR	(N' ')	Yes	T308	LVS_BETYP	Allow NULL?
200	UMBEN	Requirement Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_BENUM	Allow NULL?
201	UMTBP	Transfer Priority	char	1	0	CHAR	(N' ')	Yes		TBPRI	Allow NULL?
202	UMWKZ	Indicator: generate goods receipt date	char	1	0	CHAR	(N' ')	Yes		T321_WEDKZ	Allow NULL?
203	UMBKZ	Posting change indicator in Warehouse Management (WM)	char	1	0	CHAR	(N' ')	Yes		LVS_UMBKZ	Allow NULL?
204	WENUM	Goods Receipt Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_WENUM	Allow NULL?
205	MBLMG	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
206	MBLBM	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
207	MBBMG	Quantity Ordered Against this Purchase Requisition	decimal	13	3	QUAN	((0))	Yes		BSMNG
208	FABKL	Factory calendar key	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FABKL	Allow NULL?
209	RSHKZ	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
210	BDMNG	Requirement Quantity	decimal	13	3	QUAN	((0))	Yes		BDMNG
211	ENMNG	Quantity Withdrawn	decimal	13	3	QUAN	((0))	Yes		ENMNG
212	BDART	Requirement type	nvarchar	2	0	CHAR	(N' ')	Yes		BDART	Allow NULL?
213	ENWRT	Value Withdrawn	decimal	13	2	CURR	((0))	Yes		ENWRT
214	RLGOR	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
215	RCHAR	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	CHARG_D	Allow NULL?
216	KONPR	Consignment price	decimal	11	2	CURR	((0))	Yes		KONPR
217	KOPEI	Price unit for consignment price	decimal	5	0	DEC	((0))	Yes		KOPEI
218	ANZRE	Rules for display of goods movements	nvarchar	3	0	CHAR	(N' ')	Yes		ANZRE	Allow NULL?
219	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	TABW	ANBWA	Allow NULL?
220	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	NUMC	(N'00000')	Yes	*	LNRAN	Allow NULL?
221	BEWAR	Consolidation Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	BEWAR	Allow NULL?
222	VMVKS	Value of Tot. Valuated Stock at Sales Price in Previous Per.	decimal	13	2	CURR	((0))	Yes		VMVKS
223	UMVMVKS	Value of Tot. Valuated Stock at Sales Price in Previous Per.	decimal	13	2	CURR	((0))	Yes		VMVKS
224	UMXHUPF	Handling unit requirement	char	1	0	CHAR	(N' ')	Yes		XHUPF	Allow NULL?
225	UMVKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
226	UMVSTEL	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	*	VSTEL	Allow NULL?
227	UMVTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	*	VTWEG	Allow NULL?
228	UMSPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	*	SPART	Allow NULL?
229	UMSDLIF	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
230	UMSDKUN	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
231	UISEG	Segment string ISEG	nvarchar	3	0	CHAR	(N' ')	Yes		SISEG_D	Allow NULL?
232	UMIBPOI	Pointer on phys. inv. docmt item	nvarchar	10	0	CHAR	(N' ')	Yes		IBPOI	Allow NULL?
233	IMSEG_ORIGINAL	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
234	UMDISMM	MRP Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	DISMM	Allow NULL?
235	PARBW	Valuation Grouping Code	nvarchar	4	0	CHAR	(N' ')	Yes		BWMOD	Allow NULL?

TOP ERP 6.0 | MWZDM07M1 INDEXES

Name	Primary	Unique	Type	Columns
MWZDM07M1~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

235 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M1 TABLE

TOP ERP 6.0 | MWZDM07M1 COLUMNS

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

235 COLUMNS | 1 INDEXES | ERP 6.0 | MWZDM07M1 TABLE

TOPERP 6.0 | MWZDM07M1 COLUMNS

TOPERP 6.0 | MWZDM07M1 INDEXES

TOP ERP 6.0 | MWZDM07M1 COLUMNS

TOP ERP 6.0 | MWZDM07M1 INDEXES