SAP ABAP Table E3OILSV (Shipment specific vehicle data)

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	INTTAB	Structure
Structure	E3OILSV	Table Relationship Diagram
Short Description	Shipment specific vehicle data

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	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
2	COMP_GROUP	☐	OIG_VCG	OIG_VCG	CHAR	8	0	TD vehicle group	*
3	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	*
4	VEH_ID	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
5	CARRIER	☐	OIG_LIFNR	LIFNR	CHAR	10	0	TD carrier (vendor account number)	*
6	VEH_NRTUS	☐	OIG_NMRTU	OIG_NMRTU	NUMC	2	0	Number of transport units on vehicle (TD)
7	VOL_UOM	☐	OIG_VOLUOM	MEINS	UNIT	3	0	TD volume unit of measure	*
8	WGT_UOM	☐	OIG_WGTUOM	MEINS	UNIT	3	0	TD weight unit of measure	*
9	DIM_UOM	☐	OIG_DIMUOM	MEINS	UNIT	3	0	TD dimension unit of measure	*
10	VEH_MAXWGT	☐	OIG_VEHMWT	OIB_ADQNT	FLTP	16	16	TD vehicle maximum weight
11	VEH_UNLWGT	☐	OIG_VEHUWT	OIB_ADQNT	FLTP	16	16	TD vehicle unladen weight
12	VEH_MAXVOL	☐	OIG_VEHMVL	OIB_ADQNT	FLTP	16	16	TD vehicle maximum volume
13	EQUIP_NR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
14	VEH_HEIGHT	☐	OIG_VEHHEI	MENG13	QUAN	13	3	Vehicle height
15	VEH_WIDTH	☐	OIG_VEHWID	MENG13	QUAN	13	3	TD width
16	VEH_LENGTH	☐	OIG_VEHLEN	MENG13	QUAN	13	3	Vehicle length
17	ROUTE	☐	OIG_ROUTEV	ROUTE	CHAR	6	0	TD-F vehicle route	*
18	OIG_SSTSF	☐	OIG_SSTSF	OIG_SSTSF	CHAR	1	0	TD Shipment Status (Functional)
19	LDDATE	☐	OIG_LDDATE	DATUM	DATS	8	0	Loading Date
20	LDTIME	☐	OIG_LDTIME	TIME	TIMS	6	0	Loading time
21	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	*
22	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
23	RTDATE	☐	OIG_RTDATE	DATUM	DATS	8	0	Date of return
24	RTTIME	☐	OIG_RTTIME	TIME	TIMS	6	0	Time of return
25	DDCDAT	☐	OIG_DDCDAT	DATUM	DATS	8	0	Document date in delivery confirmation
26	PSTDAT	☐	OIG_PSTDAT	DATUM	DATS	8	0	Posting date in delivery confirmation
27	MBLNRGL	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
28	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
29	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
30	VCLOSE	☐	OIG_VCLOSE	CHAR1_X	CHAR	1	0	Vehicle close flag; set confirmation to complete (status=6)
31	GLPST	☐	OIG_GLPST	CHAR1_X	CHAR	1	0	TD gain/loss postings at vehicle close
32	VBALNC	☐	OIG_VBALNC	CHAR1_X	CHAR	1	0	TD vehicle balance check against tolerance table (TOIGS5)
33	REAS_CODE	☐	OIG_REASCD	OIG_REASC	CHAR	2	0	Reason code - to group quantities in shipment process	*
34	CHK_OVL	☐	OIG_CHKOVL	CHAR1_X	CHAR	1	0	TD check overloading
35	TPPOINT	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	*
36	FBSTA	☐	OIG_VFBSTA	FBSTA	CHAR	1	0	Status of shipment costing vehicle level
37	FBGST	☐	OIG_VFBGST	FBGST	CHAR	1	0	Overall status of shipment costing vehicle level
38	ARSTA	☐	OIG_VARSTA	ARSTA	CHAR	1	0	Status of shipment cost settlement vehicle level
39	ARGST	☐	OIG_VARGST	ARGST	CHAR	1	0	Overall status of shipment cost settlement vehicle level
40	ACT_WGT	☐	OIG_VACTWT	OIB_ADQNT	FLTP	16	16	Actual weight of vehicle
41	ACT_VOL	☐	OIG_VACTVL	OIB_ADQNT	FLTP	16	16	Actual volume for vehicle
42	UNL_WGT	☐	OIG_VUNWT	OIB_ADQNT	FLTP	16	16	TD vehicle unladen weight
43	MAX_WGT	☐	OIG_VMXWT	OIB_ADQNT	FLTP	16	16	TD vehicle maximum weight
44	MAX_VOL	☐	OIG_VMXVL	OIB_ADQNT	FLTP	16	16	TD vehicle maximum weight
45	VEH_TEXT	☐	OIG_VHLTXT	OIG_TEXT	CHAR	40	0	TD vehicle header text
46	SHIFT_TEXT	☐	OIG_SHIFTT	OIG_TEXT	CHAR	40	0	Shift description
47	VEH_TYTEXT	☐	OIG_VHTYTX	OIG_TEXT	CHAR	40	0	TD vehicle type text
48	TPLST_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
49	GROUPTEXT	☐	OIG_VCGT	OIG_TEXT	CHAR	40	0	TD vehicle group text
50	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
51	VEH_MODE	☐	OIG_VMOT	OIG_VMOT	CHAR	1	0	TD vehicle mode of transport
52	CARR_TEXT	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
53	VEH_STATUS	☐	OIG_VEHSTA	OIG_VEHSTA	CHAR	1	0	TD vehicle status
54	WGT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
55	VOL_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
56	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
57	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
58	OIG_GESZTD	☐	OIG_GESZTD	OIG_GESZT	QUAN	13	2	Total time for stage
59	OIG_FAHZTD	☐	OIG_FAHZTD	OIG_GESZT	QUAN	13	2	Total travel time for stage
60	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
61	STATUS	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
62	CNO_VLEVEL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

History

Last changed by/on	SAP	20110901
SAP Release Created in