E3OILU1 SAP (OIL-TSW Carrier Ticket Information) Structure details

Dictionary Type: Structure
Description: OIL-TSW Carrier Ticket Information




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




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

E3OILU1 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 "OIL-TSW Carrier Ticket Information" 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_E3OILU1 TYPE E3OILU1.

The E3OILU1 table consists of various fields, each holding specific information or linking keys about OIL-TSW Carrier Ticket Information data available in SAP. These include MONTK (Nomination (technical) Key), NOMIT (Nomination Key Item), TICKETNR (OIL-TSW: External ticket number), TICKETTYPE (Character Field Length = 10).. 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 E3OILU1 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
NOMNRNomination number OIJ_NOMNRCHAR20OIJ_NOMNROIO
MONTKNomination (technical) Key OIJ_NOMTKCHAR20Assigned to domainALPHAOIJ_NOMTK
NOMITNomination Key Item OIJ_ITEMNUMC10Assigned to domainOIJ_ITEM
TICKETNROIL-TSW: External ticket number OIJ_TKTNRCHAR20Assigned to domainALPHAOIJ_TKTNROIU
TICKETTYPECharacter Field Length = 10 CHAR10CHAR10CHAR10
SITYPSchedule type OIJ_SITYPCHAR2TOIJ_EL_SITYPESOIJ_SITYP
RTYPEOIL-TSW: Role type OIJ_RTYPECHAR6Assigned to domainOIJ_RTYPE
TKT_YEARYear for which levy is to be carried out JAHRNUMC4GJAHRGJAHR
TKT_MONTHCalendar month OIJ_MONTHNUMC2AM_MONAT
VERSIONOIL-TSW: External ticket number OIJ_TKTNRCHAR20Assigned to domainALPHAOIJ_TKTNROIU
LOCIDLocation ID OIJ_LOCIDCHAR10Assigned to domainOIJ_LOCIDOIX
LOCNAMLocation name (used by system owner) OIJ_LOCNAMCHAR60OIJ_LOCNAM
TSYSTTransport system OIJ_TSYSTCHAR10Assigned to domainOIJ_TSYSTOIW
TSNAMOIL-TSW: Transport system name OIJ_TSNAMCHAR60OIJ_TSNAM
CARRIERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
SHIPPERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
SUPPLIERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
CONSIGNELocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
RECEIVERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
CARRNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
SHIPPNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
SUPPNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
CONSINAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
RECNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
NETQUANTField of length 16 CHAR16CHAR16CHAR16
UOM3-Byte field CHAR3CHAR3CHAR3
MATNR_IMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
START_DATEDate DATUMDATS8DATUM
START_TIMETime in CHAR Format TIMECHAR6CHAR6
END_DATEDate DATUMDATS8DATUM
END_TIMETime in CHAR Format TIMECHAR6CHAR6
O_API_GRAVField of length 16 CHAR16CHAR16CHAR16
API_GRT_DField of length 16 CHAR16CHAR16CHAR16
TSTMPField of length 16 CHAR16CHAR16CHAR16
TSTEH3-Byte field CHAR3CHAR3CHAR3
DIS_MET_FField of length 16 CHAR16CHAR16CHAR16
COM_COR_FField of length 16 CHAR16CHAR16CHAR16
VOL_WATERField of length 16 CHAR16CHAR16CHAR16
AVG_PR_PSIField of length 16 CHAR16CHAR16CHAR16
PRS_COR_FField of length 16 CHAR16CHAR16CHAR16
OBS_TEMPOIL overall: Character field of 23 length OIJ_CHAR23CHAR23CHAR23
AVG_TEMPOIL overall: Character field of 23 length OIJ_CHAR23CHAR23CHAR23
MTTEH3-Byte field CHAR3CHAR3CHAR3
TMP_COR_FField of length 16 CHAR16CHAR16CHAR16
METER_FAC1Field of length 16 CHAR16CHAR16CHAR16
DIST_FAC1Field of length 16 CHAR16CHAR16CHAR16
METER_FAC2Field of length 16 CHAR16CHAR16CHAR16
DIST_FAC2Field of length 16 CHAR16CHAR16CHAR16
METER_FAC3Field of length 16 CHAR16CHAR16CHAR16
DIST_FAC3Field of length 16 CHAR16CHAR16CHAR16
METER_FAC4Field of length 16 CHAR16CHAR16CHAR16
DIST_FAC4Field of length 16 CHAR16CHAR16CHAR16
GROSS_QTY17-Char. Field CHAR17CHAR17CHAR17
SHIPTONAMEData Element Type CHAR Length 35 CHAR35CHAR35CHAR35
TANKAGECharacter Field Length = 10 CHAR10CHAR10CHAR10
TANK_CODENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
METER_NBR1Character Field Length = 10 CHAR10CHAR10CHAR10
PROVERRPT1Character field, 8 characters long CHAR8CHAR8CHAR8
METER_NBR2Character Field Length = 10 CHAR10CHAR10CHAR10
PROVERRPT2Character field, 8 characters long CHAR8CHAR8CHAR8
METER_NBR3Character Field Length = 10 CHAR10CHAR10CHAR10
PROVERRPT3Character field, 8 characters long CHAR8CHAR8CHAR8
METER_NBR4Character Field Length = 10 CHAR10CHAR10CHAR10
PROVERRPT4Character field, 8 characters long CHAR8CHAR8CHAR8
TY_CODECharacter Field Length = 10 CHAR10CHAR10CHAR10
TARIFF_NBRCharacter Field Length = 10 CHAR10CHAR10CHAR10
METER_NBRCharacter Field Length = 10 CHAR10CHAR10CHAR10
METER_FACField of length 16 CHAR16CHAR16CHAR16
BEGIN_READTime in CHAR Format TIMECHAR6CHAR6
END_READTime in CHAR Format TIMECHAR6CHAR6

Key field Non-key field



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

As E3OILU1 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 E3OILU1 as there is no data to select.

How to access SAP table E3OILU1

Within an ECC or HANA version of SAP you can also view further information about E3OILU1 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!