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
Logistics - General :: Logistics Basic Data :: Material Master
1	ERP EHP7	6.0	MBEW	109	2	Material Valuation	Material Master

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	MATNR	Material Number	nvarchar	18	0	Allow NULL?
3	BWKEY	Valuation Area	nvarchar	4	0	Allow NULL?
4	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
5	LVORM	Deletion flag for all material data of a valuation type	char	1	0	Allow NULL?
6	LBKUM	Total Valuated Stock	decimal	13	3
7	SALK3	Value of Total Valuated Stock	decimal	13	2
8	VPRSV	Price control indicator	char	1	0	Allow NULL?
9	VERPR	Moving Average Price/Periodic Unit Price	decimal	11	2
10	STPRS	Standard price	decimal	11	2
11	PEINH	Price Unit	decimal	5	0
12	BKLAS	Valuation Class	nvarchar	4	0	Allow NULL?
13	SALKV	Value based on moving average price (only with price ctrl S)	decimal	13	2
14	VMKUM	Total valuated stock in previous period	decimal	13	3
15	VMSAL	Value of total valuated stock in previous period	decimal	13	2
16	VMVPR	Price Control Indicator in Previous Period	char	1	0	Allow NULL?
17	VMVER	Moving Average Price/Periodic Unit Price in Previous Period	decimal	11	2
18	VMSTP	Standard price in the previous period	decimal	11	2
19	VMPEI	Price unit of previous period	decimal	5	0
20	VMBKL	Valuation Class in Previous Period	nvarchar	4	0	Allow NULL?
21	VMSAV	Value based on moving average price (previous period)	decimal	13	2
22	VJKUM	Total Valuated Stock in Previous Year	decimal	13	3
23	VJSAL	Value of total valuated stock in previous year	decimal	13	2
24	VJVPR	Price Control Indicator in Previous Year	char	1	0	Allow NULL?
25	VJVER	Moving Average Price/Periodic Unit Price in Previous Year	decimal	11	2
26	VJSTP	Standard price in previous year	decimal	11	2
27	VJPEI	Price unit of previous year	decimal	5	0
28	VJBKL	Valuation Class in Previous Year	nvarchar	4	0	Allow NULL?
29	VJSAV	Value based on moving average price (previous year)	decimal	13	2
30	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	Allow NULL?
31	LFMON	Current period (posting period)	nvarchar	2	0	Allow NULL?
32	BWTTY	Valuation Category	char	1	0	Allow NULL?
33	STPRV	Previous price	decimal	11	2
34	LAEPR	Date of the last price change	nvarchar	8	0	Allow NULL?
35	ZKPRS	Future price	decimal	11	2
36	ZKDAT	Date as of which the price is valid	nvarchar	8	0	Allow NULL?
37	TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
38	BWPRS	Valuation price based on tax law: level 1	decimal	11	2
39	BWPRH	Valuation price based on commercial law: level 1	decimal	11	2
40	VJBWS	Valuation price based on tax law: level 3	decimal	11	2
41	VJBWH	Valuation price based on commercial law: level 3	decimal	11	2
42	VVJSL	Value of total valuated stock in year before last	decimal	13	2
43	VVJLB	Total valuated stock in year before last	decimal	13	3
44	VVMLB	Total valuated stock in period before last	decimal	13	3
45	VVSAL	Value of total valuated stock in period before last	decimal	13	2
46	ZPLPR	Future planned price	decimal	11	2
47	ZPLP1	Future Planned Price 1	decimal	11	2
48	ZPLP2	Future Planned Price 2	decimal	11	2
49	ZPLP3	Future Planned Price 3	decimal	11	2
50	ZPLD1	Date from Which Future Planned Price 1 Is Valid	nvarchar	8	0	Allow NULL?
51	ZPLD2	Date from Which Future Planned Price 2 Is Valid	nvarchar	8	0	Allow NULL?
52	ZPLD3	Date from Which Future Planned Price 3 Is Valid	nvarchar	8	0	Allow NULL?
53	PPERZ	Period for future standard cost estimate (deactivated)	nvarchar	6	0	Allow NULL?
54	PPERL	Period for current standard cost estimate (deactivated)	nvarchar	6	0	Allow NULL?
55	PPERV	Period for previous standard cost estimate (deactivated)	nvarchar	6	0	Allow NULL?
56	KALKZ	Indicator: standard cost estimate for future period	char	1	0	Allow NULL?
57	KALKL	Standard Cost Estimate for Current Period	char	1	0	Allow NULL?
58	KALKV	Indicator: standard cost estimate for previous period	char	1	0	Allow NULL?
59	KALSC	Overhead key (deactivated)	nvarchar	6	0	Allow NULL?
60	XLIFO	LIFO/FIFO-Relevant	char	1	0	Allow NULL?
61	MYPOL	Pool number for LIFO valuation	nvarchar	4	0	Allow NULL?
62	BWPH1	Valuation price based on commercial law: level 2	decimal	11	2
63	BWPS1	Valuation price based on tax law: level 2	decimal	11	2
64	ABWKZ	Lowest value: devaluation indicator	nvarchar	2	0	Allow NULL?
65	PSTAT	Maintenance status	nvarchar	15	0	Allow NULL?
66	KALN1	Cost Estimate Number - Product Costing	nvarchar	12	0	Allow NULL?
67	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	Allow NULL?
68	BWVA1	Valuation Variant for Future Standard Cost Estimate	nvarchar	3	0	Allow NULL?
69	BWVA2	Valuation Variant for Current Standard Cost Estimate	nvarchar	3	0	Allow NULL?
70	BWVA3	Valuation Variant for Previous Standard Cost Estimate	nvarchar	3	0	Allow NULL?
71	VERS1	Costing Version of Future Standard Cost Estimate	nvarchar	2	0	Allow NULL?
72	VERS2	Costing Version of Current Standard Cost Estimate	nvarchar	2	0	Allow NULL?
73	VERS3	Costing Version of Previous Standard Cost Estimate	nvarchar	2	0	Allow NULL?
74	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
75	KOSGR	Costing Overhead Group	nvarchar	10	0	Allow NULL?
76	PPRDZ	Period of Future Standard Cost Estimate	nvarchar	3	0	Allow NULL?
77	PPRDL	Period of Current Standard Cost Estimate	nvarchar	3	0	Allow NULL?
78	PPRDV	Period of Previous Standard Cost Estimate	nvarchar	3	0	Allow NULL?
79	PDATZ	Fiscal Year of Future Standard Cost Estimate	nvarchar	4	0	Allow NULL?
80	PDATL	Fiscal Year of Current Standard Cost Estimate	nvarchar	4	0	Allow NULL?
81	PDATV	Fiscal Year of Previous Standard Cost Estimate	nvarchar	4	0	Allow NULL?
82	EKALR	Material Is Costed with Quantity Structure	char	1	0	Allow NULL?
83	VPLPR	Previous planned price	decimal	11	2
84	MLMAA	Material ledger activated at material level	char	1	0	Allow NULL?
85	MLAST	Material Price Determination: Control	char	1	0	Allow NULL?
86	LPLPR	Current Planned Price	decimal	11	2
87	VKSAL	Value of Total Valuated Stock at Sales Price	decimal	13	2
88	HKMAT	Material-related origin	char	1	0	Allow NULL?
89	SPERW	Physical Inventory Blocking Indicator	char	1	0	Allow NULL?
90	KZIWL	Phys. inventory indicator for value-only material	nvarchar	3	0	Allow NULL?
91	WLINL	Date of Last Posted Count for Unrestricted-Use Stock	nvarchar	8	0	Allow NULL?
92	ABCIW	Physical inventory indicator for cycle counting	char	1	0	Allow NULL?
93	BWSPA	Valuation margin	decimal	6	2
94	LPLPX	Fixed Portion of Current Planned Price	decimal	11	2
95	VPLPX	Fixed Portion of Previous Planned Price	decimal	11	2
96	FPLPX	Fixed Portion of Future Planned Price	decimal	11	2
97	LBWST	Val. Strat. for Current Plan Price, Sales Order/Proj. Stock	char	1	0	Allow NULL?
98	VBWST	Valuation Strategy for Previous Plan Price, Special Stock	char	1	0	Allow NULL?
99	FBWST	Valuation Strategy for Future Planned Price, Special Stock	char	1	0	Allow NULL?
100	EKLAS	Valuation Class for Sales Order Stock	nvarchar	4	0	Allow NULL?
101	QKLAS	Valuation Class for Project Stock	nvarchar	4	0	Allow NULL?
102	MTUSE	Usage of the material	char	1	0	Allow NULL?
103	MTORG	Origin of the material	char	1	0	Allow NULL?
104	OWNPR	Produced in-house	char	1	0	Allow NULL?
105	XBEWM	Valuation based on the batch-specific unit of measure	char	1	0	Allow NULL?
106	BWPEI	Price unit for valuation prices based on tax/commercial law	decimal	5	0
107	MBRUE	MBEWH rec. already exists for per. before last of MBEW per.	char	1	0	Allow NULL?
108	OKLAS	Valuation Class for Special Stock at the Vendor	nvarchar	4	0	Allow NULL?
109	OIPPINV	Prepaid Inventory Flag for Material Valuation Type Segment	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
MBEW~0	Yes	Yes	CLUSTERED	BWTAR, BWKEY, MATNR, MANDT
MBEW~ML1	No	Yes	NONCLUSTERED	KALN1, 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

109 COLUMNS | 2 INDEXES | ERP 6.0 | MBEW TABLE

TOP ERP 6.0 | MBEW COLUMNS

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

109 COLUMNS | 2 INDEXES | ERP 6.0 | MBEW TABLE

TOPERP 6.0 | MBEW COLUMNS

TOPERP 6.0 | MBEW INDEXES

TOP ERP 6.0 | MBEW COLUMNS

TOP ERP 6.0 | MBEW INDEXES