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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	VEHICLE	TD Vehicle Number	nvarchar	10	0	CHAR	(N' ')	No		OIG_VHLNMR	Allow NULL?
3	COMP_GROUP	TD Vehicle Customer group	nvarchar	8	0	CHAR	(N' ')	Yes	TOIGBV	OIG_VEHCUSTGRP	Allow NULL?
4	VEH_TYPE	TD vehicle type	nvarchar	4	0	CHAR	(N' ')	Yes	TOIGV	OIG_VHLTYP	Allow NULL?
5	VEH_ID	TD vehicle identifier	nvarchar	18	0	CHAR	(N' ')	Yes		OIG_VEHID	Allow NULL?
6	CARRIER	TD carrier (vendor account number)	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	OIG_LIFNR	Allow NULL?
7	VEH_NRTUS	Number of transport units on vehicle (TD)	nvarchar	2	0	NUMC	(N'00')	Yes		OIG_NMRTU	Allow NULL?
8	VOL_UOM	TD volume unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIG_VOLUOM	Allow NULL?
9	WGT_UOM	TD weight unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIG_WGTUOM	Allow NULL?
10	DIM_UOM	TD dimension unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIG_DIMUOM	Allow NULL?
11	VEH_MAXWGT	TD vehicle maximum weight	float	15	16	FLTP	((0))	Yes		OIG_VEHMWT
12	VEH_UNLWGT	TD vehicle unladen weight	float	15	16	FLTP	((0))	Yes		OIG_VEHUWT
13	VEH_MAXVOL	TD vehicle maximum volume	float	15	16	FLTP	((0))	Yes		OIG_VEHMVL
14	EQUIP_NR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	EQUI	EQUNR	Allow NULL?
15	VEH_HEIGHT	Vehicle height	decimal	13	3	QUAN	((0))	Yes		OIG_VEHHEI
16	VEH_WIDTH	TD width	decimal	13	3	QUAN	((0))	Yes		OIG_VEHWID
17	VEH_LENGTH	Vehicle length	decimal	13	3	QUAN	((0))	Yes		OIG_VEHLEN
18	ROUTE	TD-F vehicle route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	OIG_ROUTEV	Allow NULL?
19	TZONE	Time Zone	nvarchar	6	0	CHAR	(N' ')	Yes	TTZZ	TZNZONE	Allow NULL?
20	CALENDAR	Factory calendar ID	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	CR_WFCID	Allow NULL?
21	DEPOT	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
22	VEH_SCREL	Freight cost relevant vehicle	nvarchar	10	0	CHAR	(N' ')	Yes	OIGV	OIG_VHSCREL	Allow NULL?
23	NAME_EFF_DATE	Name Effective Date	nvarchar	8	0	DATS	(N'00000000')	Yes	*	OIG_NMEFFDT	Allow NULL?
24	CLF_EFDT	Vehicle Classification Effective Date	nvarchar	8	0	DATS	(N'00000000')	Yes	*	OIG_CLFEFFDT	Allow NULL?
25	REG_CNTRY	Vehicle Registered Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIG_REG_CNTR	Allow NULL?
26	REG_DATE	TD-Vehicle Registered Date	nvarchar	8	0	DATS	(N'00000000')	Yes	*	OIG_REGDT	Allow NULL?
27	OWNER	TD-Vehicle Owner	nvarchar	20	0	CHAR	(N' ')	Yes		OIG_VEH_OWNER	Allow NULL?
28	REG_OWNER	TD-Vehicle Registered Owner	nvarchar	20	0	CHAR	(N' ')	Yes		OIG_VEH_REG_OWN	Allow NULL?
29	GRP_ID	TD-Vehicle Berth Compatibility Group ID	nvarchar	10	0	CHAR	(N' ')	Yes	TOI0_CP_GRP	OIG_BR_CP_GRP_ID	Allow NULL?
30	OWN_FLAG	TD-Vehicle Own Flag	char	1	0	CHAR	(N' ')	Yes		OIG_VOWNFL	Allow NULL?
31	BALLCAP	TD-Vehicle Ballast Capacity	decimal	13	3	QUAN	((0))	Yes		OIG_BALLCAP
32	FL_BNK_CAPA	TD-Vehicle Fuel Bunker Capacity	decimal	13	3	QUAN	((0))	Yes		OIG_FL_BNK_CAPA
33	DSL_BNK_CAPA	TD-Vehicle Diesel Bunker Capacity	decimal	13	3	QUAN	((0))	Yes		OIG_DSL_BNK_CAPA
34	CAP_UOM	UoM of TD-Vehicle Bunker Capacity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIG_CAP_UOM	Allow NULL?
35	WT_UOM	UoM of TD-Vehicle(For Draft)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIG_WT_UOM	Allow NULL?
36	CLASS_GRP	TD-Vehicle Classification Group	nvarchar	10	0	CHAR	(N' ')	Yes	TOIGVCLGR	OIG_CL_GRP	Allow NULL?
37	VHCLSIGN	TD-Vehicle Call Sign	nvarchar	10	0	CHAR	(N' ')	Yes		OIG_VHCLSIGN	Allow NULL?
38	STCMNR	TD-Vehicle Telex Number	nvarchar	30	0	CHAR	(N' ')	Yes		OIG_STCMNR	Allow NULL?
39	SRFXNR	TD-Vehicle Fax Number	nvarchar	30	0	CHAR	(N' ')	Yes		OIG_STFXNR	Allow NULL?
40	DRAFT	Maximum Vehicle Draft	decimal	13	3	QUAN	((0))	Yes		OIG_VEH_DRAFT
41	AVERAGE_SPEED	Average Speed	decimal	6	2	QUAN	((0))	Yes		OIO_AVR_SPEED_02
42	AVR_SPEED_UOM	Average Speed UoM	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIO_SPEED_UOM_02	Allow NULL?
43	DECK_CAPACITY	Deck Capacity	decimal	6	2	QUAN	((0))	Yes		OIO_DECK_CAP_02
44	DECK_CAP_UOM	Deck Capacity UoM	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIO_DECK_UOM_02	Allow NULL?
45	ARRIVAL_BUFFER	Arrival Buffer	decimal	11	0	DEC	((0))	Yes		OIO_ARR_BUFF_02
46	DEPARTURE_BUFFER	Departure Buffer	decimal	11	0	DEC	((0))	Yes		OIO_DEP_BUFF_02
47	VEH_MAIL	E-Mail Address	nvarchar	241	0	CHAR	(N' ')	Yes		AD_SMTPADR	Allow NULL?
48	VEH_PHONE	Vehicle Phone	nvarchar	30	0	CHAR	(N' ')	Yes		OIO_VEH_PHONE_02	Allow NULL?
49	TPPOINT	Transportation planning point	nvarchar	4	0	CHAR	(N' ')	Yes	TTDS	TPLST	Allow NULL?
50	VEH_STATUS	TD vehicle status	char	1	0	CHAR	(N' ')	Yes		OIG_VEHSTA	Allow NULL?
51	CRE_DATE	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		ERSDA	Allow NULL?
52	CRE_NAME	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
53	CHA_DATE	Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		LAEDA	Allow NULL?
54	CHA_NAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	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