SAP ABAP Table OI0BW_OIGV (Structure for vehicle data (OIGV))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	INTTAB	Structure
Structure	OI0BW_OIGV	Table Relationship Diagram
Short Description	Structure for vehicle data (OIGV)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
3	.INCLUDE	☐				0	0	TD Vehicle header data in transport
4	COMP_GROUP	☐	OIG_VEHCUSTGRP	OIG_VCG	CHAR	8	0	TD Vehicle Customer group	TOIGBV
5	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	TOIGV
6	VEH_ID	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
7	CARRIER	☐	OIG_LIFNR	LIFNR	CHAR	10	0	TD carrier (vendor account number)	LFA1
8	VEH_NRTUS	☐	OIG_NMRTU	OIG_NMRTU	NUMC	2	0	Number of transport units on vehicle (TD)
9	VOL_UOM	☐	OIG_VOLUOM	MEINS	UNIT	3	0	TD volume unit of measure	T006
10	WGT_UOM	☐	OIG_WGTUOM	MEINS	UNIT	3	0	TD weight unit of measure	T006
11	DIM_UOM	☐	OIG_DIMUOM	MEINS	UNIT	3	0	TD dimension unit of measure	T006
12	VEH_MAXWGT	☐	OIG_VEHMWT	OIB_ADQNT	FLTP	16	16	TD vehicle maximum weight
13	VEH_UNLWGT	☐	OIG_VEHUWT	OIB_ADQNT	FLTP	16	16	TD vehicle unladen weight
14	VEH_MAXVOL	☐	OIG_VEHMVL	OIB_ADQNT	FLTP	16	16	TD vehicle maximum volume
15	EQUIP_NR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
16	VEH_HEIGHT	☐	OIG_VEHHEI	MENG13	QUAN	13	3	Vehicle height
17	VEH_WIDTH	☐	OIG_VEHWID	MENG13	QUAN	13	3	TD width
18	VEH_LENGTH	☐	OIG_VEHLEN	MENG13	QUAN	13	3	Vehicle length
19	ROUTE	☐	OIG_ROUTEV	ROUTE	CHAR	6	0	TD-F vehicle route	TVRO
20	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
21	CALENDAR	☐	CR_WFCID	WFCID	CHAR	2	0	Factory calendar ID	TFACD
22	DEPOT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
23	VEH_SCREL	☐	OIG_VHSCREL	OIG_VHLNMR	CHAR	10	0	Freight cost relevant vehicle	OIGV
24	.INCLUDE	☐				0	0	TD Vehicle, Marine Scheduling Attributes
25	NAME_EFF_DATE	☐	OIG_NMEFFDT	OIG_NMEFFDT	DATS	8	0	Name Effective Date	*
26	CLF_EFDT	☐	OIG_CLFEFFDT	OIG_CLFEFFDT	DATS	8	0	Vehicle Classification Effective Date	*
27	REG_CNTRY	☐	OIG_REG_CNTR	LAND1	CHAR	3	0	Vehicle Registered Country	T005
28	REG_DATE	☐	OIG_REGDT	OIG_REGDT	DATS	8	0	TD-Vehicle Registered Date	*
29	OWNER	☐	OIG_VEH_OWNER	OIG_VEH_OWNER	CHAR	20	0	TD-Vehicle Owner
30	REG_OWNER	☐	OIG_VEH_REG_OWN	OIG_VEH_REG_OWN	CHAR	20	0	TD-Vehicle Registered Owner
31	GRP_ID	☐	OIG_BR_CP_GRP_ID	OI0_CP_GRP_ID	CHAR	10	0	TD-Vehicle Berth Compatibility Group ID	TOI0_CP_GRP
32	OWN_FLAG	☐	OIG_VOWNFL	OIG_VOWNFL	CHAR	1	0	TD-Vehicle Own Flag
33	BALLCAP	☐	OIG_BALLCAP	OIG_BALLCAP	QUAN	13	3	TD-Vehicle Ballast Capacity
34	FL_BNK_CAPA	☐	OIG_FL_BNK_CAPA	OIG_FL_BNK_CAPA	QUAN	13	3	TD-Vehicle Fuel Bunker Capacity
35	DSL_BNK_CAPA	☐	OIG_DSL_BNK_CAPA	OIG_DSL_BNK_CAPA	QUAN	13	3	TD-Vehicle Diesel Bunker Capacity
36	CAP_UOM	☐	OIG_CAP_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle Bunker Capacity	T006
37	WT_UOM	☐	OIG_WT_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle(For Draft)	T006
38	CLASS_GRP	☐	OIG_CL_GRP	OIG_CL_GRP	CHAR	10	0	TD-Vehicle Classification Group	TOIGVCLGR
39	VHCLSIGN	☐	OIG_VHCLSIGN	OIG_VHCLSIGN	CHAR	10	0	TD-Vehicle Call Sign
40	STCMNR	☐	OIG_STCMNR	OIG_STCMNR	CHAR	30	0	TD-Vehicle Telex Number
41	SRFXNR	☐	OIG_STFXNR	OIG_STFXNR	CHAR	30	0	TD-Vehicle Fax Number
42	DRAFT	☐	OIG_VEH_DRAFT	OIG_VEH_DRAFT	QUAN	13	3	Maximum Vehicle Draft
43	TPPOINT	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	*
44	VEH_STATUS	☐	OIG_VEHSTA	OIG_VEHSTA	CHAR	1	0	TD vehicle status
45	CRE_DATE	☐	ERSDA	DATUM	DATS	8	0	Created On
46	CRE_NAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
47	CHA_DATE	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
48	CHA_NAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
49	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OI0BW_OIGV	CALENDAR	TFACD	IDENT
2	OI0BW_OIGV	CAP_UOM	T006	MSEHI
3	OI0BW_OIGV	CARRIER	LFA1	LIFNR
4	OI0BW_OIGV	CLASS_GRP	TOIGVCLGR	CLASS_GRP
5	OI0BW_OIGV	COMP_GROUP	TOIGBV	GROUPNAME
6	OI0BW_OIGV	DEPOT	T001W	WERKS
7	OI0BW_OIGV	DIM_UOM	T006	MSEHI
8	OI0BW_OIGV	EQUIP_NR	EQUI	EQUNR
9	OI0BW_OIGV	GRP_ID	TOI0_CP_GRP	GRP_ID	REF	C	CN
10	OI0BW_OIGV	REG_CNTRY	T005	LAND1
11	OI0BW_OIGV	ROUTE	TVRO	ROUTE
12	OI0BW_OIGV	TZONE	TTZZ	TZONE
13	OI0BW_OIGV	VEH_SCREL	OIGV	VEHICLE
14	OI0BW_OIGV	VEH_TYPE	TOIGV	VEH_TYPE
15	OI0BW_OIGV	VOL_UOM	T006	MSEHI
16	OI0BW_OIGV	WGT_UOM	T006	MSEHI
17	OI0BW_OIGV	WT_UOM	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in