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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
1	ERP EHP7	6.0	/BEV1/RPFZ	57	2	Vehicle Master (Route Planning)	Remaining Beverage - Obsolete Objects

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	FZGNR	Vehicle Number	nvarchar	10	0	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
4	TPLST	Transportation planning point	nvarchar	4	0	Allow NULL?
5	VSTEL	Shipping Point/Receiving Point	nvarchar	4	0	Allow NULL?
6	BEZEI	Description	nvarchar	30	0	Allow NULL?
7	FZGART	Vehicle Type	char	1	0	Allow NULL?
8	FZGTYP	Vehicle Category	nvarchar	5	0	Allow NULL?
9	EIGEN	DSD - RA: Own/External	char	1	0	Allow NULL?
10	TDISPZ	Permissible for Route Planning	char	1	0	Allow NULL?
11	SPERZ1V	Blocked Period from	nvarchar	8	0	Allow NULL?
12	SPERZ1B	Blocked Period to	nvarchar	8	0	Allow NULL?
13	SPERZ2V	Blocked Period from	nvarchar	8	0	Allow NULL?
14	SPERZ2B	Blocked Period to	nvarchar	8	0	Allow NULL?
15	SPERZ3V	Blocked Period from	nvarchar	8	0	Allow NULL?
16	SPERZ3B	Blocked Period to	nvarchar	8	0	Allow NULL?
17	KENNZ	Registration Number	nvarchar	15	0	Allow NULL?
18	PSTLZ	Postal Code	nvarchar	10	0	Allow NULL?
19	STANDORT	Location	nvarchar	30	0	Allow NULL?
20	LEGEW	Unladen Weight	decimal	13	3
21	ERGGEW	Permitted Total Weight	decimal	13	3
22	NUTZL	Usable Load	decimal	13	3
23	FZ_GEW_U	Unit for Vehicle Weight	nvarchar	3	0	Allow NULL?
24	LLFL	Loading Area Length	decimal	13	3
25	BLFL	Width of Loading Area	decimal	13	3
26	HLFL	Loading Area Height	decimal	13	3
27	LD_ABM_U	Unit Loading Area Dimensions	nvarchar	3	0	Allow NULL?
28	LVOL	Load Volume	decimal	13	3
29	LVOL_U	Unit for Loading Volume	nvarchar	3	0	Allow NULL?
30	AHLAST	Trailer Load	decimal	13	3
31	AHLAST_U	Unit for Trailer Load	nvarchar	3	0	Allow NULL?
32	LAENGE	Vehicle Length	decimal	13	3
33	BREITE	Vehicle Width	decimal	13	3
34	HOEHE	Vehicle Height	decimal	13	3
35	FZ_ABM_U	Unit Vehicle Dimensions	nvarchar	3	0	Allow NULL?
36	FSKL	Driving License Class	nvarchar	3	0	Allow NULL?
37	PALPL	Number of Pallet Positions	decimal	4	0
38	LEINH	Loading Units	nvarchar	8	0	Allow NULL?
39	FUNKNR	Radiophone Number	nvarchar	15	0	Allow NULL?
40	TELNR	Phone Number/Car	nvarchar	15	0	Allow NULL?
41	STATUS	Master Record Status	char	1	0	Allow NULL?
42	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
43	AEZET	Time last change was made	nvarchar	6	0	Allow NULL?
44	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
45	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
46	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
47	VARKAP	Free Capacity Field with Variable Unit of Measure	decimal	7	2
48	KAPUNIT	Unit of Measure for Variant Capacity Field	nvarchar	3	0	Allow NULL?
49	/VSO/B_FZ_ABM_U	Base Unit of Measure	nvarchar	3	0	Allow NULL?
50	/VSO/B_AXL_POS_F	Quantity	decimal	13	3
51	/VSO/B_AXL_POS_R	Quantity	decimal	13	3
52	/VSO/B_FZ_GEW_U	Base Unit of Measure	nvarchar	3	0	Allow NULL?
53	/VSO/B_AXL_WGT_F	Quantity	decimal	13	3
54	/VSO/B_AXL_WGT_R	Quantity	decimal	13	3
55	/VSO/B_VCL_CAT	Two digit number	nvarchar	2	0	Allow NULL?
56	/VSO/B_LOAD_DIR	Numeric 1-character	char	1	0	Allow NULL?
57	/VSO/B_MATNR_HU	Material Number	nvarchar	18	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/BEV1/RPFZ~0	Yes	Yes	CLUSTERED	FZGNR, MANDT
/BEV1/RPFZ~001	No	No	NONCLUSTERED	FZGNR, VSTEL, TPLST, FZGART

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

57 COLUMNS | 2 INDEXES | ERP 6.0 | /BEV1/RPFZ TABLE

TOP ERP 6.0 | /BEV1/RPFZ COLUMNS

TOP ERP 6.0 | /BEV1/RPFZ 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

57 COLUMNS | 2 INDEXES | ERP 6.0 | /BEV1/RPFZ TABLE

TOPERP 6.0 | /BEV1/RPFZ COLUMNS

TOPERP 6.0 | /BEV1/RPFZ INDEXES

TOP ERP 6.0 | /BEV1/RPFZ COLUMNS

TOP ERP 6.0 | /BEV1/RPFZ INDEXES