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
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
1	ERP EHP7	6.0	OIGV	54	2	TD Vehicle Header	Traders and Schedulers Workbench

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	VEHICLE	TD Vehicle Number	nvarchar	10	0	Allow NULL?
3	COMP_GROUP	TD Vehicle Customer group	nvarchar	8	0	Allow NULL?
4	VEH_TYPE	TD vehicle type	nvarchar	4	0	Allow NULL?
5	VEH_ID	TD vehicle identifier	nvarchar	18	0	Allow NULL?
6	CARRIER	TD carrier (vendor account number)	nvarchar	10	0	Allow NULL?
7	VEH_NRTUS	Number of transport units on vehicle (TD)	nvarchar	2	0	Allow NULL?
8	VOL_UOM	TD volume unit of measure	nvarchar	3	0	Allow NULL?
9	WGT_UOM	TD weight unit of measure	nvarchar	3	0	Allow NULL?
10	DIM_UOM	TD dimension unit of measure	nvarchar	3	0	Allow NULL?
11	VEH_MAXWGT	TD vehicle maximum weight	float	15	16
12	VEH_UNLWGT	TD vehicle unladen weight	float	15	16
13	VEH_MAXVOL	TD vehicle maximum volume	float	15	16
14	EQUIP_NR	Equipment Number	nvarchar	18	0	Allow NULL?
15	VEH_HEIGHT	Vehicle height	decimal	13	3
16	VEH_WIDTH	TD width	decimal	13	3
17	VEH_LENGTH	Vehicle length	decimal	13	3
18	ROUTE	TD-F vehicle route	nvarchar	6	0	Allow NULL?
19	TZONE	Time Zone	nvarchar	6	0	Allow NULL?
20	CALENDAR	Factory calendar ID	nvarchar	2	0	Allow NULL?
21	DEPOT	Plant	nvarchar	4	0	Allow NULL?
22	VEH_SCREL	Freight cost relevant vehicle	nvarchar	10	0	Allow NULL?
23	NAME_EFF_DATE	Name Effective Date	nvarchar	8	0	Allow NULL?
24	CLF_EFDT	Vehicle Classification Effective Date	nvarchar	8	0	Allow NULL?
25	REG_CNTRY	Vehicle Registered Country	nvarchar	3	0	Allow NULL?
26	REG_DATE	TD-Vehicle Registered Date	nvarchar	8	0	Allow NULL?
27	OWNER	TD-Vehicle Owner	nvarchar	20	0	Allow NULL?
28	REG_OWNER	TD-Vehicle Registered Owner	nvarchar	20	0	Allow NULL?
29	GRP_ID	TD-Vehicle Berth Compatibility Group ID	nvarchar	10	0	Allow NULL?
30	OWN_FLAG	TD-Vehicle Own Flag	char	1	0	Allow NULL?
31	BALLCAP	TD-Vehicle Ballast Capacity	decimal	13	3
32	FL_BNK_CAPA	TD-Vehicle Fuel Bunker Capacity	decimal	13	3
33	DSL_BNK_CAPA	TD-Vehicle Diesel Bunker Capacity	decimal	13	3
34	CAP_UOM	UoM of TD-Vehicle Bunker Capacity	nvarchar	3	0	Allow NULL?
35	WT_UOM	UoM of TD-Vehicle(For Draft)	nvarchar	3	0	Allow NULL?
36	CLASS_GRP	TD-Vehicle Classification Group	nvarchar	10	0	Allow NULL?
37	VHCLSIGN	TD-Vehicle Call Sign	nvarchar	10	0	Allow NULL?
38	STCMNR	TD-Vehicle Telex Number	nvarchar	30	0	Allow NULL?
39	SRFXNR	TD-Vehicle Fax Number	nvarchar	30	0	Allow NULL?
40	DRAFT	Maximum Vehicle Draft	decimal	13	3
41	AVERAGE_SPEED	Average Speed	decimal	6	2
42	AVR_SPEED_UOM	Average Speed UoM	nvarchar	3	0	Allow NULL?
43	DECK_CAPACITY	Deck Capacity	decimal	6	2
44	DECK_CAP_UOM	Deck Capacity UoM	nvarchar	3	0	Allow NULL?
45	ARRIVAL_BUFFER	Arrival Buffer	decimal	11	0
46	DEPARTURE_BUFFER	Departure Buffer	decimal	11	0
47	VEH_MAIL	E-Mail Address	nvarchar	241	0	Allow NULL?
48	VEH_PHONE	Vehicle Phone	nvarchar	30	0	Allow NULL?
49	TPPOINT	Transportation planning point	nvarchar	4	0	Allow NULL?
50	VEH_STATUS	TD vehicle status	char	1	0	Allow NULL?
51	CRE_DATE	Created On	nvarchar	8	0	Allow NULL?
52	CRE_NAME	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
53	CHA_DATE	Date of Last Change	nvarchar	8	0	Allow NULL?
54	CHA_NAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?

Name	Primary	Unique	Type	Columns
OIGV~0	Yes	Yes	CLUSTERED	VEHICLE, CLIENT
OIGV~ST	No	Yes	NONCLUSTERED	VEHICLE, VEH_STATUS, CLIENT

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

54 COLUMNS | 2 INDEXES | ERP 6.0 | OIGV TABLE

TOP ERP 6.0 | OIGV COLUMNS

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

54 COLUMNS | 2 INDEXES | ERP 6.0 | OIGV TABLE

TOPERP 6.0 | OIGV COLUMNS

TOPERP 6.0 | OIGV INDEXES

TOP ERP 6.0 | OIGV COLUMNS

TOP ERP 6.0 | OIGV INDEXES