ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MWZVM07M	200	1	Fields: Update Control of Module Pool SAPMM07M	Inventory Management

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

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 | MWZVM07M TABLE

TOP ERP 6.0 | MWZVM07M COLUMNS

TOP ERP 6.0 | MWZVM07M 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 | MWZVM07M TABLE

TOPERP 6.0 | MWZVM07M COLUMNS

TOPERP 6.0 | MWZVM07M INDEXES

TOP ERP 6.0 | MWZVM07M COLUMNS

TOP ERP 6.0 | MWZVM07M INDEXES