SAP ABAP Table OIGSV (TD Vehicles in Transport/Shipment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIG (Package) TD Transport and Distribution

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIGSV	Table Relationship Diagram
Short Description	TD Vehicles in Transport/Shipment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	SHNUMBER	☑	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
3	VEH_NR	☑	OIG_VEHNR	OIG_VEHNR	NUMC	3	0	Vehicle Sequence Number in Shipment
4	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
5	.INCLUDE	☐				0	0	TD Vehicle header data in transport
6	COMP_GROUP	☐	OIG_VEHCUSTGRP	OIG_VCG	CHAR	8	0	TD Vehicle Customer group	TOIGBV
7	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	TOIGV
8	VEH_ID	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
9	CARRIER	☐	OIG_LIFNR	LIFNR	CHAR	10	0	TD carrier (vendor account number)	LFA1
10	VEH_NRTUS	☐	OIG_NMRTU	OIG_NMRTU	NUMC	2	0	Number of transport units on vehicle (TD)
11	VOL_UOM	☐	OIG_VOLUOM	MEINS	UNIT	3	0	TD volume unit of measure	T006
12	WGT_UOM	☐	OIG_WGTUOM	MEINS	UNIT	3	0	TD weight unit of measure	T006
13	DIM_UOM	☐	OIG_DIMUOM	MEINS	UNIT	3	0	TD dimension unit of measure	T006
14	VEH_MAXWGT	☐	OIG_VEHMWT	OIB_ADQNT	FLTP	16	16	TD vehicle maximum weight
15	VEH_UNLWGT	☐	OIG_VEHUWT	OIB_ADQNT	FLTP	16	16	TD vehicle unladen weight
16	VEH_MAXVOL	☐	OIG_VEHMVL	OIB_ADQNT	FLTP	16	16	TD vehicle maximum volume
17	EQUIP_NR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
18	VEH_HEIGHT	☐	OIG_VEHHEI	MENG13	QUAN	13	3	Vehicle height
19	VEH_WIDTH	☐	OIG_VEHWID	MENG13	QUAN	13	3	TD width
20	VEH_LENGTH	☐	OIG_VEHLEN	MENG13	QUAN	13	3	Vehicle length
21	ROUTE	☐	OIG_ROUTEV	ROUTE	CHAR	6	0	TD-F vehicle route	TVRO
22	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
23	CALENDAR	☐	CR_WFCID	WFCID	CHAR	2	0	Factory calendar ID	TFACD
24	DEPOT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
25	VEH_SCREL	☐	OIG_VHSCREL	OIG_VHLNMR	CHAR	10	0	Freight cost relevant vehicle	OIGV
26	.INCLUDE	☐				0	0	TD Vehicle, Marine Scheduling Attributes
27	NAME_EFF_DATE	☐	OIG_NMEFFDT	OIG_NMEFFDT	DATS	8	0	Name Effective Date	*
28	CLF_EFDT	☐	OIG_CLFEFFDT	OIG_CLFEFFDT	DATS	8	0	Vehicle Classification Effective Date	*
29	REG_CNTRY	☐	OIG_REG_CNTR	LAND1	CHAR	3	0	Vehicle Registered Country	T005
30	REG_DATE	☐	OIG_REGDT	OIG_REGDT	DATS	8	0	TD-Vehicle Registered Date	*
31	OWNER	☐	OIG_VEH_OWNER	OIG_VEH_OWNER	CHAR	20	0	TD-Vehicle Owner
32	REG_OWNER	☐	OIG_VEH_REG_OWN	OIG_VEH_REG_OWN	CHAR	20	0	TD-Vehicle Registered Owner
33	GRP_ID	☐	OIG_BR_CP_GRP_ID	OI0_CP_GRP_ID	CHAR	10	0	TD-Vehicle Berth Compatibility Group ID	TOI0_CP_GRP
34	OWN_FLAG	☐	OIG_VOWNFL	OIG_VOWNFL	CHAR	1	0	TD-Vehicle Own Flag
35	BALLCAP	☐	OIG_BALLCAP	OIG_BALLCAP	QUAN	13	3	TD-Vehicle Ballast Capacity
36	FL_BNK_CAPA	☐	OIG_FL_BNK_CAPA	OIG_FL_BNK_CAPA	QUAN	13	3	TD-Vehicle Fuel Bunker Capacity
37	DSL_BNK_CAPA	☐	OIG_DSL_BNK_CAPA	OIG_DSL_BNK_CAPA	QUAN	13	3	TD-Vehicle Diesel Bunker Capacity
38	CAP_UOM	☐	OIG_CAP_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle Bunker Capacity	T006
39	WT_UOM	☐	OIG_WT_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle(For Draft)	T006
40	CLASS_GRP	☐	OIG_CL_GRP	OIG_CL_GRP	CHAR	10	0	TD-Vehicle Classification Group	TOIGVCLGR
41	VHCLSIGN	☐	OIG_VHCLSIGN	OIG_VHCLSIGN	CHAR	10	0	TD-Vehicle Call Sign
42	STCMNR	☐	OIG_STCMNR	OIG_STCMNR	CHAR	30	0	TD-Vehicle Telex Number
43	SRFXNR	☐	OIG_STFXNR	OIG_STFXNR	CHAR	30	0	TD-Vehicle Fax Number
44	DRAFT	☐	OIG_VEH_DRAFT	OIG_VEH_DRAFT	QUAN	13	3	Maximum Vehicle Draft
45	OIG_SSTSF	☐	OIG_SSTSF	OIG_SSTSF	CHAR	1	0	TD Shipment Status (Functional)
46	LDDATE	☐	OIG_LDDATE	DATUM	DATS	8	0	Loading Date
47	LDTIME	☐	OIG_LDTIME	TIME	TIMS	6	0	Loading time
48	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
49	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
50	RTDATE	☐	OIG_RTDATE	DATUM	DATS	8	0	Date of return
51	RTTIME	☐	OIG_RTTIME	TIME	TIMS	6	0	Time of return
52	PRINTFLG	☐	OIG_PRNTFL	OIG_PRNTFL	CHAR	1	0	Output selection flag (indicates print required)
53	DDCDAT	☐	OIG_DDCDAT	DATUM	DATS	8	0	Document date in delivery confirmation
54	PSTDAT	☐	OIG_PSTDAT	DATUM	DATS	8	0	Posting date in delivery confirmation
55	MBLNRGL	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
56	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
57	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
58	VCLOSE	☐	OIG_VCLOSE	CHAR1_X	CHAR	1	0	Vehicle close flag; set confirmation to complete (status=6)
59	GLPST	☐	OIG_GLPST	CHAR1_X	CHAR	1	0	TD gain/loss postings at vehicle close
60	VBALNC	☐	OIG_VBALNC	CHAR1_X	CHAR	1	0	TD vehicle balance check against tolerance table (TOIGS5)
61	REAS_CODE	☐	OIG_REASCD	OIG_REASC	CHAR	2	0	Reason code - to group quantities in shipment process	TOIGS4
62	CHK_OVL	☐	OIG_CHKOVL	CHAR1_X	CHAR	1	0	TD check overloading
63	CRE_DATE	☐	ERSDA	DATUM	DATS	8	0	Created On
64	CRE_NAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
65	CRE_TIME	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
66	CHA_DATE	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
67	CHA_NAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
68	CHA_TIME	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
69	TPPOINT	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
70	FBSTA	☐	OIG_VFBSTA	FBSTA	CHAR	1	0	Status of shipment costing vehicle level
71	FBGST	☐	OIG_VFBGST	FBGST	CHAR	1	0	Overall status of shipment costing vehicle level
72	ARSTA	☐	OIG_VARSTA	ARSTA	CHAR	1	0	Status of shipment cost settlement vehicle level
73	ARGST	☐	OIG_VARGST	ARGST	CHAR	1	0	Overall status of shipment cost settlement vehicle level
74	SKALSM	☐	OIG_KALSM_V	KALSM	CHAR	6	0	Pricing procedure in vehicle of shipment	T683

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIGSV	CALENDAR	TFACD	IDENT
2	OIGSV	CAP_UOM	T006	MSEHI
3	OIGSV	CARRIER	LFA1	LIFNR
4	OIGSV	CLASS_GRP	TOIGVCLGR	CLASS_GRP
5	OIGSV	CLIENT	T000	MANDT
6	OIGSV	COMP_GROUP	TOIGBV	GROUPNAME
7	OIGSV	DEPOT	T001W	WERKS
8	OIGSV	DIM_UOM	T006	MSEHI
9	OIGSV	EQUIP_NR	EQUI	EQUNR
10	OIGSV	GRP_ID	TOI0_CP_GRP	GRP_ID	REF	C	CN
11	OIGSV	REAS_CODE	TOIGS4	REAS_CODE
12	OIGSV	REG_CNTRY	T005	LAND1
13	OIGSV	ROUTE	TVRO	ROUTE
14	OIGSV	SHIFT	TOIGH	SHIFT
15	OIGSV	SHNUMBER	OIGS	SHNUMBER
16	OIGSV	SKALSM	T683	KALSM
17	OIGSV	TPPOINT	TTDS	TPLST
18	OIGSV	TZONE	TTZZ	TZONE
19	OIGSV	VEHICLE	OIGV	VEHICLE	KEY	1	CN
20	OIGSV	VEH_SCREL	OIGV	VEHICLE
21	OIGSV	VEH_TYPE	TOIGV	VEH_TYPE
22	OIGSV	VOL_UOM	T006	MSEHI
23	OIGSV	WGT_UOM	T006	MSEHI
24	OIGSV	WT_UOM	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in