E3OILSV SAP (Shipment specific vehicle data) Structure details

Dictionary Type: Structure
Description: Shipment specific vehicle data




ABAP Code to SELECT data from E3OILSV
Related tables to E3OILSV
Access table E3OILSV




Structure field list including key, data, relationships and ABAP select examples

E3OILSV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Shipment specific vehicle data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_E3OILSV TYPE E3OILSV.

The E3OILSV table consists of various fields, each holding specific information or linking keys about Shipment specific vehicle data data available in SAP. These include COMP_GROUP (TD vehicle group), VEH_TYPE (TD vehicle type), VEH_ID (TD vehicle identifier), CARRIER (TD carrier (vendor account number)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP E3OILSV structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
VEHICLETD Vehicle Number OIG_VHLNMRCHAR10Assigned to domainALPHAOIG_VHLNMROIV
COMP_GROUPTD vehicle group OIG_VCGCHAR8Assigned to domainALPHAOIG_VCGOI9
VEH_TYPETD vehicle type OIG_VHLTYPCHAR4Assigned to domainOIG_VHLTYPOIE
VEH_IDTD vehicle identifier OIG_VEHIDCHAR18OIG_LICNMR
CARRIERTD carrier (vendor account number) OIG_LIFNRCHAR10Assigned to domainALPHALIFNR
VEH_NRTUSNumber of transport units on vehicle (TD) OIG_NMRTUNUMC2OIG_NMRTU
VOL_UOMTD volume unit of measure OIG_VOLUOMUNIT3Assigned to domainCUNITMEINS
WGT_UOMTD weight unit of measure OIG_WGTUOMUNIT3Assigned to domainCUNITMEINS
DIM_UOMTD dimension unit of measure OIG_DIMUOMUNIT3Assigned to domainCUNITMEINS
VEH_MAXWGTTD vehicle maximum weight OIG_VEHMWTFLTP16(16) OIB_ADQNT
VEH_UNLWGTTD vehicle unladen weight OIG_VEHUWTFLTP16(16) OIB_ADQNT
VEH_MAXVOLTD vehicle maximum volume OIG_VEHMVLFLTP16(16) OIB_ADQNT
EQUIP_NREquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
VEH_HEIGHTVehicle height OIG_VEHHEIQUAN13(3) MENG13
VEH_WIDTHTD width OIG_VEHWIDQUAN13(3) MENG13
VEH_LENGTHVehicle length OIG_VEHLENQUAN13(3) MENG13
ROUTETD-F vehicle route OIG_ROUTEVCHAR6Assigned to domainROUTE
OIG_SSTSFTD Shipment Status (Functional) OIG_SSTSFCHAR1OIG_SSTSF
LDDATELoading Date OIG_LDDATEDATS8DATUM
LDTIMELoading time OIG_LDTIMETIMS6TIME
SHIFTTD driver shift OIG_SHIFTCHAR1Assigned to domainOIG_SHIFT
TRIPTrip Number OIG_TRIPNUMC5OIG_TRIP
RTDATEDate of return OIG_RTDATEDATS8DATUM
RTTIMETime of return OIG_RTTIMETIMS6TIME
DDCDATDocument date in delivery confirmation OIG_DDCDATDATS8DATUM
PSTDATPosting date in delivery confirmation OIG_PSTDATDATS8DATUM
MBLNRGLNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
VCLOSEVehicle close flag; set confirmation to complete (status=6) OIG_VCLOSECHAR1CHAR1_X
GLPSTTD gain/loss postings at vehicle close OIG_GLPSTCHAR1CHAR1_X
VBALNCTD vehicle balance check against tolerance table (TOIGS5) OIG_VBALNCCHAR1CHAR1_X
REAS_CODEReason code - to group quantities in shipment process OIG_REASCDCHAR2Assigned to domainOIG_REASC
CHK_OVLTD check overloading OIG_CHKOVLCHAR1CHAR1_X
TPPOINTTransportation planning point TPLSTCHAR4Assigned to domainTPLSTTDP
FBSTAStatus of shipment costing vehicle level OIG_VFBSTACHAR1FBSTA
FBGSTOverall status of shipment costing vehicle level OIG_VFBGSTCHAR1FBGST
ARSTAStatus of shipment cost settlement vehicle level OIG_VARSTACHAR1ARSTA
ARGSTOverall status of shipment cost settlement vehicle level OIG_VARGSTCHAR1ARGST
ACT_WGTActual weight of vehicle OIG_VACTWTFLTP16(16) OIB_ADQNT
ACT_VOLActual volume for vehicle OIG_VACTVLFLTP16(16) OIB_ADQNT
UNL_WGTTD vehicle unladen weight OIG_VUNWTFLTP16(16) OIB_ADQNT
MAX_WGTTD vehicle maximum weight OIG_VMXWTFLTP16(16) OIB_ADQNT
MAX_VOLTD vehicle maximum weight OIG_VMXVLFLTP16(16) OIB_ADQNT
VEH_TEXTTD vehicle header text OIG_VHLTXTCHAR40OIG_TEXT
SHIFT_TEXTShift description OIG_SHIFTTCHAR40OIG_TEXT
VEH_TYTEXTTD vehicle type text OIG_VHTYTXCHAR40OIG_TEXT
TPLST_TEXTDescription BEZEI20CHAR20TEXT20
GROUPTEXTTD vehicle group text OIG_VCGTCHAR40OIG_TEXT
EQKTXDescription of technical object KTX01CHAR40TEXT40
VEH_MODETD vehicle mode of transport OIG_VMOTCHAR1OIG_VMOT
CARR_TEXTName 1 NAME1_GPCHAR35NAME
VEH_STATUSTD vehicle status OIG_VEHSTACHAR1OIG_VEHSTA
WGT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
VOL_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
DISTZDistance DISTZQUAN13(3) MENG13
MEDSTUnit of measure for distance MEDSTUNIT3Assigned to domainCUNITMEINS
OIG_GESZTDTotal time for stage OIG_GESZTDQUAN13(2) OIG_GESZT
OIG_FAHZTDTotal travel time for stage OIG_FAHZTDQUAN13(2) OIG_GESZT
MEIZTUnit of measure for travelling times MEIZTUNIT3Assigned to domainCUNITMEINS
STATUSTransaction type TRTYPCHAR1TRTYP
CNO_VLEVELSingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP structure E3OILSV using ABAP code?

As E3OILSV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on E3OILSV as there is no data to select.

How to access SAP table E3OILSV

Within an ECC or HANA version of SAP you can also view further information about E3OILSV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!