	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

200 COLUMNS | 1 INDEXES | ERP 6.0 | MWXVM07M TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MWXVM07M	200	1	Fields: Update Control of Module Pool SAPMM07M	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, ZEILV, SMARC, SMARD, SMCHB, SMBPR, SMLIB, SMKOL, SMEIK, SMKLK, SMKUB, SEKPO, SFAUP, SMRES, SMSKU, SMSLB, SMSSL, SMSKA, SMSSA, SMSPR, SMSSQ, SMSCA, SMSOA, SMSCP, SMSOP, LFGJA, LFMON, KMBEW, BWKEY, KZBAA, HRKFT, XBBST, XBFAU, WEBRE, KZWES, PSTYP, AWEWR, ELIKZ_OLD, WEAKT, EKORG, EKGRP, NETWR, NETWW, ERNAM, PABPM, EISBE, MINBE, DISMM, DISST, DISKZ, APOKZ, DISPO, MTVFP, XPBED, MISKZ, VRMOD, VINT1, VINT2, BDTER, VBTYP, MTART, SPART, BWAER, TBFKZ, BETYP, BENUM, TRART, AUTTA, WEDKZ, XLIFU, GSVBR, UNVBR, VGART, XINVB, XIUPD, SOBFI, SOBLO, SOBVO, QSSBW, QSSHK, XQSSP, QPLOS, LBBSA, KBBSA, KZBWA, ETIAR, ETIFO, XNAPR, DISGR, XCHPF, XSTOR, VERAB, LIFCH, LICHA, XFMAT, DUSER, BUMRZ, BUMRN, ETENS, CO_KAKST, CO_KAAUF, CO_KAPRO, CO_KAKTR, CO_KANPL, CO_KAIMO, CO_KAKDA, CO_KAERG, CO_KAABS, CO_KAPRZ, CO_KASAT, ABELN, ABEPL, MLMAA, KALN1, EK_CHARG, EK_LIFCH, EK_LICHA, HKMAT, XVKBW, DZEIT, KNBDR, PRDHA, SATNR, ATTYP, BWVOR, BWSCL, SAISO, VOLEH, PLGTP, SERVG, LWEDT, STRGR, BRGEW, GEWEI, VOLUM, QNDAT, CLNEW, KZEAR_OLD, QPLOA, MONAT, MLAST, SAISJ, VRGNG, RETPO, XNEBE, XKZBEW, AUREL, VBELN, VBELP, XAKON, AWEWW, LGNTB, KALNR, ANZGEB, GEBEH, LQNUM, UMLQN, XSTAU, J_1BNFREL, XHEAD, L2SKR, KDAUF_SD, KDPOS_SD, LMBMV, FELDV, WM_KZBEW, LFBJA_INTERNAL, LFBNR_INTERNAL, LFPOS_INTERNAL, EXWMS, UMEXW, LFART, KUNWE, VKORG, VSTEL, VTWEG, XBLNR_AVIS, FRBNR_AVIS, PABNUM, PABPOS, PKKEY, NAVNW, MB_MWSKZ, OBJNR, OBJTYPE, SEKPK, LVS_LIFNR, LADGR, XHUPF, SDLIF, SDKUN, SISEG, IBPOI, SEKLA, BFLME, GLOBAL_COUNTER, MLCCS_RELEVANT FROM MWXVM07M

TOP ERP 6.0 | MWXVM07M 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	ZEILV	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
6	SMARC	Segment string MARC	nvarchar	3	0	CHAR	(N' ')	Yes		SMARC_D	Allow NULL?
7	SMARD	Segment string MARD	nvarchar	3	0	CHAR	(N' ')	Yes		SMARD_D	Allow NULL?
8	SMCHB	Segment string MCHB	nvarchar	3	0	CHAR	(N' ')	Yes		SMCHB_D	Allow NULL?
9	SMBPR	Segment string MBPR	nvarchar	3	0	CHAR	(N' ')	Yes		SMBPR	Allow NULL?
10	SMLIB	Segment string	nvarchar	3	0	CHAR	(N' ')	Yes		SMLIB	Allow NULL?
11	SMKOL	Segment string MKOL	nvarchar	3	0	CHAR	(N' ')	Yes		SMKOL_D	Allow NULL?
12	SMEIK	Segment string MEIK	nvarchar	3	0	CHAR	(N' ')	Yes		SMEIK	Allow NULL?
13	SMKLK	Segment string MKLK	nvarchar	3	0	CHAR	(N' ')	Yes		SMKLK	Allow NULL?
14	SMKUB	Segment string MKVB	nvarchar	3	0	CHAR	(N' ')	Yes		SMKUB	Allow NULL?
15	SEKPO	Segment string EKPO	nvarchar	3	0	CHAR	(N' ')	Yes		SEKPO_D	Allow NULL?
16	SFAUP	Segment string FAUP	nvarchar	3	0	CHAR	(N' ')	Yes		SFAUP_D	Allow NULL?
17	SMRES	Segment string MRES	nvarchar	3	0	CHAR	(N' ')	Yes		SMRES_D	Allow NULL?
18	SMSKU	Segment string MSKU	nvarchar	3	0	CHAR	(N' ')	Yes		SMSKU_D	Allow NULL?
19	SMSLB	Segment string MSLB	nvarchar	3	0	CHAR	(N' ')	Yes		SMSLB_D	Allow NULL?
20	SMSSL	Segment string MSSL	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSL_D	Allow NULL?
21	SMSKA	Segment string MSKA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSKA_D	Allow NULL?
22	SMSSA	Segment string MSSA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSA_D	Allow NULL?
23	SMSPR	Segment string MSPR	nvarchar	3	0	CHAR	(N' ')	Yes		SMSPR_D	Allow NULL?
24	SMSSQ	Segment string MSSQ	nvarchar	3	0	CHAR	(N' ')	Yes		SMSSQ_D	Allow NULL?
25	SMSCA	Segment string MSCA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSCA	Allow NULL?
26	SMSOA	Segment string MSOA	nvarchar	3	0	CHAR	(N' ')	Yes		SMSOA	Allow NULL?
27	SMSCP	Segment string MSCP	nvarchar	3	0	CHAR	(N' ')	Yes		SMSCP	Allow NULL?
28	SMSOP	Segment string MSOP	nvarchar	3	0	CHAR	(N' ')	Yes		SMSOP	Allow NULL?
29	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	NUMC	(N'0000')	Yes		LFGJA	Allow NULL?
30	LFMON	Current period (posting period)	nvarchar	2	0	NUMC	(N'00')	Yes		LFMON	Allow NULL?
31	KMBEW	Indicator MBEW from configurable material	char	1	0	CHAR	(N' ')	Yes		KMBEW	Allow NULL?
32	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	T001K	BWKEY	Allow NULL?
33	KZBAA	Indicator: valuation type is set automatically	char	1	0	CHAR	(N' ')	Yes		KZBAA	Allow NULL?
34	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	Yes	*	HRKFT	Allow NULL?
35	XBBST	Indicator: purchase order update	char	1	0	CHAR	(N' ')	Yes		XBBST	Allow NULL?
36	XBFAU	Update production order	char	1	0	CHAR	(N' ')	Yes		XBFAU	Allow NULL?
37	WEBRE	Indicator: GR-Based Invoice Verification	char	1	0	CHAR	(N' ')	Yes		WEBRE	Allow NULL?
38	KZWES	GR blocked stock	char	1	0	CHAR	(N' ')	Yes		KZWES	Allow NULL?
39	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
40	AWEWR	Value of goods received in local currency	decimal	13	2	CURR	((0))	Yes		WEWRT
41	ELIKZ_OLD	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
42	WEAKT	Indicator: Goods Receipt Message	char	1	0	CHAR	(N' ')	Yes		WEAKT	Allow NULL?
43	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
44	EKGRP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	T024	EKGRP	Allow NULL?
45	NETWR	Net order value in document currency	decimal	13	2	CURR	((0))	Yes		BSTWR
46	NETWW	Net Order Value in PO Currency	decimal	13	2	CURR	((0))	Yes		BWERT
47	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
48	PABPM	Percentage variance in order price unit	decimal	4	2	DEC	((0))	Yes		PABPM
49	EISBE	Safety Stock	decimal	13	3	QUAN	((0))	Yes		EISBE
50	MINBE	Reorder Point	decimal	13	3	QUAN	((0))	Yes		MINBE
51	DISMM	MRP Type	nvarchar	2	0	CHAR	(N' ')	Yes	T438A	DISMM	Allow NULL?
52	DISST	Low-Level Code	nvarchar	3	0	CHAR	(N' ')	Yes		DISST	Allow NULL?
53	DISKZ	Storage location MRP indicator	char	1	0	CHAR	(N' ')	Yes		DISKZ	Allow NULL?
54	APOKZ	Indicator: Is material relevant for APO	char	1	0	CHAR	(N' ')	Yes		APOKZ	Allow NULL?
55	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	CHAR	(N' ')	Yes	*	DISPO	Allow NULL?
56	MTVFP	Checking Group for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	*	MTVFP	Allow NULL?
57	XPBED	Requirements reduction upon goods movements	char	1	0	CHAR	(N' ')	Yes		XPBED	Allow NULL?
58	MISKZ	Mixed MRP indicator	char	1	0	CHAR	(N' ')	Yes		MISKZ	Allow NULL?
59	VRMOD	Consumption mode	char	1	0	CHAR	(N' ')	Yes		VRMOD	Allow NULL?
60	VINT1	Consumption period: backward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT1	Allow NULL?
61	VINT2	Consumption period: forward	nvarchar	3	0	NUMC	(N'000')	Yes		VINT2	Allow NULL?
62	BDTER	Requirement Date for the Component	nvarchar	8	0	DATS	(N'00000000')	Yes		BDTER	Allow NULL?
63	VBTYP	SD document category	char	1	0	CHAR	(N' ')	Yes		VBTYP	Allow NULL?
64	MTART	Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	MTART	Allow NULL?
65	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	*	SPART	Allow NULL?
66	BWAER	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
67	TBFKZ	Indicator: Creation/Cancellation of a Transfer Requirement	char	1	0	CHAR	(N' ')	Yes		T321_TBFKZ	Allow NULL?
68	BETYP	Requirement Type	char	1	0	CHAR	(N' ')	Yes	T308	LVS_BETYP	Allow NULL?
69	BENUM	Requirement Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_BENUM	Allow NULL?
70	TRART	Shipment Type	char	1	0	CHAR	(N' ')	Yes	T333A	LVS_TRART	Allow NULL?
71	AUTTA	Automatic Transfer Order Creation	char	1	0	CHAR	(N' ')	Yes	*	LVS_AUTTA	Allow NULL?
72	WEDKZ	Indicator: generate goods receipt date	char	1	0	CHAR	(N' ')	Yes		T321_WEDKZ	Allow NULL?
73	XLIFU	LIFO/FIFO-Relevant	char	1	0	CHAR	(N' ')	Yes		XLIFO	Allow NULL?
74	GSVBR	Total consumption	decimal	13	3	QUAN	((0))	Yes		GSVBR
75	UNVBR	Unplanned consumption	decimal	13	3	QUAN	((0))	Yes		UNVBR
76	VGART	Transaction/Event Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	VGART	Allow NULL?
77	XINVB	Generate physical inventory document for material doc. item	char	1	0	CHAR	(N' ')	Yes		XINVB	Allow NULL?
78	XIUPD	Physical inventory stock type from material document item	char	1	0	CHAR	(N' ')	Yes	*	XIUPD	Allow NULL?
79	SOBFI	Special stock ind.: Accounting/bookkeeping assignment	char	1	0	CHAR	(N' ')	Yes		SOBFI	Allow NULL?
80	SOBLO	Special stock indicator: Logistics assignment	char	1	0	CHAR	(N' ')	Yes		SOBLO	Allow NULL?
81	SOBVO	Special stock indicator: Transaction assignment	char	1	0	CHAR	(N' ')	Yes		SOBVO	Allow NULL?
82	QSSBW	Inspection by quality assurance	char	1	0	CHAR	(N' ')	Yes		QSSBW	Allow NULL?
83	QSSHK	Inspection Lot Origin	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSHK	Allow NULL?
84	XQSSP	No Manual Inventory Posting for QM-Relevant Material	char	1	0	CHAR	(N' ')	Yes		QQSSP	Allow NULL?
85	QPLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	QPLOS	Allow NULL?
86	LBBSA	Stock Type of Goods Movement (Primary Posting)	nvarchar	2	0	CHAR	(N' ')	Yes	*	LBBSA	Allow NULL?
87	KBBSA	Stock Type of Goods Movement (Complementary Posting)	nvarchar	2	0	CHAR	(N' ')	Yes	*	KBBSA	Allow NULL?
88	KZBWA	Movement type category	nvarchar	2	0	CHAR	(N' ')	Yes		KZBWA	Allow NULL?
89	ETIAR	Label type	nvarchar	2	0	CHAR	(N' ')	Yes	*	ETIAR	Allow NULL?
90	ETIFO	Label form	nvarchar	2	0	CHAR	(N' ')	Yes	*	ETIFO	Allow NULL?
91	XNAPR	Print via Output Control	char	1	0	CHAR	(N' ')	Yes		XNAPR	Allow NULL?
92	DISGR	MRP Group	nvarchar	4	0	CHAR	(N' ')	Yes	T438M	DISGR	Allow NULL?
93	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
94	XSTOR	Reversal, return delivery, or transfer posting	char	1	0	CHAR	(N' ')	Yes		KZSTO	Allow NULL?
95	VERAB	Availability date	nvarchar	8	0	DATS	(N'00000000')	Yes		VERAB	Allow NULL?
96	LIFCH	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	ELIFN	Allow NULL?
97	LICHA	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
98	XFMAT	Material is a missing part	char	1	0	CHAR	(N' ')	Yes		XFMAT	Allow NULL?
99	DUSER	Recipient Name	nvarchar	12	0	CHAR	(N' ')	Yes		SO_REC_NAM	Allow NULL?
100	BUMRZ	Numerator for Conversion to Base Units of Measure	decimal	5	0	DEC	((0))	Yes		UMREZ
101	BUMRN	Denominator for conversion to base units of measure	decimal	5	0	DEC	((0))	Yes		UMREN
102	ETENS	Sequential Number of Vendor Confirmation	nvarchar	4	0	NUMC	(N'0000')	Yes		ETENS	Allow NULL?
103	CO_KAKST	Account Assignment Type: Cost Center	char	1	0	NUMC	(N'0')	Yes		CO_KAKST	Allow NULL?
104	CO_KAAUF	Account assignment type: Order	char	1	0	NUMC	(N'0')	Yes		CO_KAAUF	Allow NULL?
105	CO_KAPRO	Project account assignment type	char	1	0	NUMC	(N'0')	Yes		CO_KAPRO	Allow NULL?
106	CO_KAKTR	Account Assignment Type: Cost Object	char	1	0	NUMC	(N'0')	Yes		CO_KAKTR	Allow NULL?
107	CO_KANPL	Account Assignment Type: Network	char	1	0	NUMC	(N'0')	Yes		CO_KANPL	Allow NULL?
108	CO_KAIMO	Account Assignment Type: Real Estate Object	char	1	0	NUMC	(N'0')	Yes		CO_KAIMO	Allow NULL?
109	CO_KAKDA	Account Assignment Type: Sales Order	char	1	0	NUMC	(N'0')	Yes		CO_KAKDA	Allow NULL?
110	CO_KAERG	Business segment account assignment type	char	1	0	NUMC	(N'0')	Yes		CO_KAERG	Allow NULL?
111	CO_KAABS	Account assignment type: reconciliation object	char	1	0	NUMC	(N'0')	Yes		CO_KAABS	Allow NULL?
112	CO_KAPRZ	Account Assignment Type: Business Process	char	1	0	NUMC	(N'0')	Yes		CO_KAPRZ	Allow NULL?
113	CO_KASAT	Account Assignment Type Not Used	char	1	0	NUMC	(N'0')	Yes		CO_KASAT	Allow NULL?
114	ABELN	Allocation Table Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ABELN	Allow NULL?
115	ABEPL	Item number of allocation table	nvarchar	5	0	NUMC	(N'00000')	Yes	*	ABELP	Allow NULL?
116	MLMAA	Material ledger activated at material level	char	1	0	CHAR	(N' ')	Yes		CK_ML_MAAC	Allow NULL?
117	KALN1	Cost Estimate Number - Product Costing	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR1	Allow NULL?
118	EK_CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
119	EK_LIFCH	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ELIFN	Allow NULL?
120	EK_LICHA	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
121	HKMAT	Material-related origin	char	1	0	CHAR	(N' ')	Yes		HKMAT	Allow NULL?
122	XVKBW	Sales price valuation active	char	1	0	CHAR	(N' ')	Yes		XVKBW	Allow NULL?
123	DZEIT	In-house production time	decimal	3	0	DEC	((0))	Yes		DZEIT
124	KNBDR	Print kanban card	char	1	0	CHAR	(N' ')	Yes		KNBDR	Allow NULL?
125	PRDHA	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	*	PRODH_D	Allow NULL?
126	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	SATNR	Allow NULL?
127	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
128	BWVOR	Procurement rule	char	1	0	CHAR	(N' ')	Yes	*	BWVOR	Allow NULL?
129	BWSCL	Source of Supply	char	1	0	CHAR	(N' ')	Yes	*	BWSCL	Allow NULL?
130	SAISO	Season Category	nvarchar	4	0	CHAR	(N' ')	Yes	*	SAISO	Allow NULL?
131	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	VOLEH	Allow NULL?
132	PLGTP	Price Band Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	PLGTP	Allow NULL?
133	SERVG	IS-R service level	char	1	0	CHAR	(N' ')	Yes	*	W_SERVGRD	Allow NULL?
134	LWEDT	Date of last goods receipt	nvarchar	8	0	DATS	(N'00000000')	Yes		LWEDT	Allow NULL?
135	STRGR	Planning strategy group	nvarchar	2	0	CHAR	(N' ')	Yes	*	STRGR	Allow NULL?
136	BRGEW	Gross weight	decimal	15	3	QUAN	((0))	Yes		BRGEW_15
137	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	GEWEI	Allow NULL?
138	VOLUM	Volume	decimal	15	3	QUAN	((0))	Yes		VOLUM_15
139	QNDAT	Next Inspection Date	nvarchar	8	0	DATS	(N'00000000')	Yes		QNPDAT	Allow NULL?
140	CLNEW	Object indicator is new in classification	char	1	0	CHAR	(N' ')	Yes		CLNEW	Allow NULL?
141	KZEAR_OLD	Final Issue for This Reservation	char	1	0	CHAR	(N' ')	Yes		KZEAR	Allow NULL?
142	QPLOA	Inspection Lot on Which the Usage Decision is Based	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	QPLOA	Allow NULL?
143	MONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
144	MLAST	Material Price Determination: Control	char	1	0	CHAR	(N' ')	Yes		CK_ML_ABST	Allow NULL?
145	SAISJ	Season Year	nvarchar	4	0	CHAR	(N' ')	Yes		SAISJ	Allow NULL?
146	VRGNG	Business Transaction	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_VORGANG	Allow NULL?
147	RETPO	Returns Item	char	1	0	CHAR	(N' ')	Yes		RETPO	Allow NULL?
148	XNEBE	Create purchase order automatically	char	1	0	CHAR	(N' ')	Yes		XNEBE	Allow NULL?
149	XKZBEW	Propose movmt type despite diff. movmt type indicator	char	1	0	CHAR	(N' ')	Yes		XKZBEW	Allow NULL?
150	AUREL	Relevant to Allocation Table	char	1	0	CHAR	(N' ')	Yes		AUREL	Allow NULL?
151	VBELN	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN	Allow NULL?
152	VBELP	Sales document item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	VBELP	Allow NULL?
153	XAKON	Indicator: CO account assignment field filled automatically	char	1	0	CHAR	(N' ')	Yes		XAKON	Allow NULL?
154	AWEWW	Value of goods received in foreign currency	decimal	13	2	CURR	((0))	Yes		WEWWR
155	LGNTB	Do not adopt storage location into transfer requirement	char	1	0	CHAR	(N' ')	Yes		LVS_LGNTB	Allow NULL?
156	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR	Allow NULL?
157	ANZGEB	QM - No. of Containers	decimal	6	3	QUAN	((0))	Yes		QANZGEB
158	GEBEH	Lot Container	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QGEBEH	Allow NULL?
159	LQNUM	Quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LVS_LQNUM	Allow NULL?
160	UMLQN	Quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LVS_LQNUM	Allow NULL?
161	XSTAU	Break down structure	char	1	0	CHAR	(N' ')	Yes		XSTAU	Allow NULL?
162	J_1BNFREL	Nota Fiscal Relevance	char	1	0	CHAR	(N' ')	Yes		J_1BNFREL	Allow NULL?
163	XHEAD	Indicates header of structured material	char	1	0	CHAR	(N' ')	Yes		XHEAD	Allow NULL?
164	L2SKR	Relevance for 2-step picking	char	1	0	CHAR	(N' ')	Yes		LVS_2SKREL	Allow NULL?
165	KDAUF_SD	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KDAUF	Allow NULL?
166	KDPOS_SD	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
167	LMBMV	Under/Overdelivery	char	1	0	CHAR	(N' ')	Yes		LMBMV	Allow NULL?
168	FELDV	Name of field	nvarchar	16	0	CHAR	(N' ')	Yes		FELDN	Allow NULL?
169	WM_KZBEW	Movement Indicator	char	1	0	CHAR	(N' ')	Yes		KZBEW	Allow NULL?
170	LFBJA_INTERNAL	Fiscal Year of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFBJA	Allow NULL?
171	LFBNR_INTERNAL	Document No. of a Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		LFBNR	Allow NULL?
172	LFPOS_INTERNAL	Item of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFPOS	Allow NULL?
173	EXWMS	Indicator: Item for external WM	char	1	0	CHAR	(N' ')	Yes		LVS_EXWMS	Allow NULL?
174	UMEXW	Indicator: Item for external WM	char	1	0	CHAR	(N' ')	Yes		LVS_EXWMS	Allow NULL?
175	LFART	Delivery Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	LFART	Allow NULL?
176	KUNWE	Ship-to-party for delivery for WMS	nvarchar	10	0	CHAR	(N' ')	Yes	*	LVS_KUNWE	Allow NULL?
177	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
178	VSTEL	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	*	VSTEL	Allow NULL?
179	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	*	VTWEG	Allow NULL?
180	XBLNR_AVIS	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
181	FRBNR_AVIS	Number of Bill of Lading at Time of Goods Receipt	nvarchar	16	0	CHAR	(N' ')	Yes		FRBNR1	Allow NULL?
182	PABNUM	JIT Call Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PABNUM	Allow NULL?
183	PABPOS	JIT call item	nvarchar	4	0	NUMC	(N'0000')	Yes		PABPOS	Allow NULL?
184	PKKEY	Identification Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PKKEY	Allow NULL?
185	NAVNW	Non-deductible input tax	decimal	13	2	CURR	((0))	Yes		NAVNW
186	MB_MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
187	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	*	J_OBJNR	Allow NULL?
188	OBJTYPE	Change indicator	char	1	0	CHAR	(N' ')	Yes		OCM_OBJ_TYPE	Allow NULL?
189	SEKPK	Segment string EKPK	nvarchar	3	0	CHAR	(N' ')	Yes		SEKPK_D	Allow NULL?
190	LVS_LIFNR	Account number of vendor for inbound delivery WMS	nvarchar	10	0	CHAR	(N' ')	Yes	*	LVS_LIFNR	Allow NULL?
191	LADGR	Loading Group	nvarchar	4	0	CHAR	(N' ')	Yes	*	LADGR	Allow NULL?
192	XHUPF	Handling unit requirement	char	1	0	CHAR	(N' ')	Yes		XHUPF	Allow NULL?
193	SDLIF	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
194	SDKUN	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
195	SISEG	Segment string ISEG	nvarchar	3	0	CHAR	(N' ')	Yes		SISEG_D	Allow NULL?
196	IBPOI	Pointer on phys. inv. docmt item	nvarchar	10	0	CHAR	(N' ')	Yes		IBPOI	Allow NULL?
197	SEKLA	Segment string EKLA	nvarchar	3	0	CHAR	(N' ')	Yes		SEKLA_D	Allow NULL?
198	BFLME	Generic Material with Logistical Variants	char	1	0	CHAR	(N' ')	Yes		BFLME	Allow NULL?
199	GLOBAL_COUNTER	Unique number for one line	nvarchar	6	0	NUMC	(N'000000')	Yes		MIGO_GLOBAL_COUNTER	Allow NULL?
200	MLCCS_RELEVANT	Active Actual Cost Component Split	char	1	0	CHAR	(N' ')	Yes		CK_MLCCS	Allow NULL?

TOP ERP 6.0 | MWXVM07M INDEXES

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

200 COLUMNS | 1 INDEXES | ERP 6.0 | MWXVM07M TABLE

TOP ERP 6.0 | MWXVM07M COLUMNS

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

200 COLUMNS | 1 INDEXES | ERP 6.0 | MWXVM07M TABLE

TOPERP 6.0 | MWXVM07M COLUMNS

TOPERP 6.0 | MWXVM07M INDEXES

TOP ERP 6.0 | MWXVM07M COLUMNS

TOP ERP 6.0 | MWXVM07M INDEXES