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
Plant Maintenance :: Technical Objects
1	ERP EHP7	6.0	FLEET	55	5	Fleet Attributes	Technical Objects

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	OBJNR	Object number	nvarchar	22	0	Allow NULL?
3	OBJECT_GRP	Grouping of technical objects in Plant Maintenance	nvarchar	2	0	Allow NULL?
4	FLEET_CAT	Vehicle Type	nvarchar	10	0	Allow NULL?
5	FLEET_NUM	Identification number for fleet object	nvarchar	18	0	Allow NULL?
6	FLEET_VIN	Manufacturer Vehicle Identification Number for Fleet Object	nvarchar	30	0	Allow NULL?
7	CHASSIS_NUM	Chassis number	nvarchar	30	0	Allow NULL?
8	LICENSE_NUM	License plate number	nvarchar	15	0	Allow NULL?
9	EXPIRY_DATE	Validity end date	nvarchar	8	0	Allow NULL?
10	FLEET_HGT	Maximum fleet object height	decimal	13	3
11	FLEET_WID	Width of fleet object	decimal	13	3
12	FLEET_LEN	Maximum fleet object length	decimal	13	3
13	DIM_UNIT	Unit of length	nvarchar	3	0	Allow NULL?
14	PRI_CALC	Indicator to determine the calculation method f. consumption	char	1	0	Allow NULL?
15	REPLA_DATE	Date on which the object should be replaced	nvarchar	8	0	Allow NULL?
16	REPLA_ODOM	Odometer reading at replacement	nvarchar	22	0	Allow NULL?
17	REPLA_OPH	Hour meter reading at replacement	nvarchar	22	0	Allow NULL?
18	NUM_AXLE	Number of Axles in Fleet Object	nvarchar	2	0	Allow NULL?
19	MAX_OCCUPANTS	Maximum number of occupants	nvarchar	4	0	Allow NULL?
20	CARD_NUM	Fuel card number	nvarchar	30	0	Allow NULL?
21	KEY_NUM	Key number of vehicle	nvarchar	20	0	Allow NULL?
22	FLEET_USE	Usage indicator	char	1	0	Allow NULL?
23	ENGINE_TYPE	Engine type	nvarchar	10	0	Allow NULL?
24	ENGINE_POWER	Power at specific number of revolutions per minute	decimal	13	3
25	UNIT_POWER	Power unit	nvarchar	3	0	Allow NULL?
26	REVOLUTIONS	Revolutions per minute	nvarchar	7	0	Allow NULL?
27	ENGINE_CYL	Number of cylinders	nvarchar	2	0	Allow NULL?
28	ENGINE_CAP	Engine capacity	decimal	13	3
29	UNIT_CAP	Unit for engine capacity measurement	nvarchar	3	0	Allow NULL?
30	ENGINE_SNR	Engine serial number of manufacturer	nvarchar	30	0	Allow NULL?
31	FUEL_PRI	Consumable Type of Primary Fuel	nvarchar	12	0	Allow NULL?
32	FUEL_SEC	Consumable type of secondary fuel	nvarchar	12	0	Allow NULL?
33	OIL_TYPE	Consumable type of oil	nvarchar	12	0	Allow NULL?
34	GROSS_WGT	Total Weight Allowed	decimal	13	3
35	LOAD_WGT	Maximum load weight	decimal	13	3
36	WGT_UNIT	Unit of weight	nvarchar	3	0	Allow NULL?
37	LOAD_HGT	Load height	decimal	13	3
38	LOAD_WID	Load width	decimal	13	3
39	LOAD_LEN	Load length	decimal	13	3
40	LOAD_DIM_UNIT	Unit for freight dimensions	nvarchar	3	0	Allow NULL?
41	LOAD_VOL	Load volume	decimal	13	3
42	VOL_UNIT	Volume unit	nvarchar	3	0	Allow NULL?
43	NO_COMPART	NUmber of compartments	nvarchar	2	0	Allow NULL?
44	SPEED_MAX	Maximum Fleet Object Speed	decimal	9	3
45	SPEED_UNIT	Speed Unit	nvarchar	3	0	Allow NULL?
46	CONSUMP_TOL	Indicator Consumption Recording: Permitted Tolerances	char	1	0	Allow NULL?
47	CONSUMP_MOVE	Indicator Consumption Recording: Material Movement	char	1	0	Allow NULL?
48	/DSD/RP_EIGEN	Indicator for Own (X) or External Vehicle	char	1	0	Allow NULL?
49	/DSD/RP_AHLAST	Trailer Load	decimal	13	3
50	/DSD/RP_AHLAST_U	Unit of weight	nvarchar	3	0	Allow NULL?
51	/DSD/RP_VARKAP	Free Capacity Field with Variable Unit of Measure	decimal	7	2
52	/DSD/RP_KAPUNIT	Unit of Measure for Var. Capacity Field	nvarchar	3	0	Allow NULL?
53	/BEV1/LULEINH	Loading Units	nvarchar	8	0	Allow NULL?
54	/VSO/M_VSO_FTYPE	Vehicle Type for Vehicle Space Optimation	nvarchar	10	0	Allow NULL?
55	IS_SI_UNIT	PM: Vehicle Data in SI Unit (e.g. Dimensions)	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
FLEET~0	Yes	Yes	CLUSTERED	OBJNR, MANDT
FLEET~CHA	No	No	NONCLUSTERED	CHASSIS_NUM
FLEET~LIC	No	No	NONCLUSTERED	LICENSE_NUM
FLEET~NUM	No	No	NONCLUSTERED	FLEET_NUM
FLEET~VIN	No	No	NONCLUSTERED	FLEET_VIN

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

55 COLUMNS | 5 INDEXES | ERP 6.0 | FLEET TABLE

TOP ERP 6.0 | FLEET COLUMNS

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

55 COLUMNS | 5 INDEXES | ERP 6.0 | FLEET TABLE

TOPERP 6.0 | FLEET COLUMNS

TOPERP 6.0 | FLEET INDEXES

TOP ERP 6.0 | FLEET COLUMNS

TOP ERP 6.0 | FLEET INDEXES