1. Home
  2. Resources
  3. SAP Tables
  4. ROIJ_EL_TICKET_I - IS-OIL TSW: Structure ticket item

SAP Table ROIJ_EL_TICKET_I

IS-OIL TSW: Structure ticket item

ROIJ_EL_TICKET_I (IS-OIL TSW: Structure ticket item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIJ_EL_TICKET_I to other SAP tables.

Source: ROIJ_EL_TICKET_I (IS-OIL TSW: Structure ticket item)

ROIJ_EL_TICKET_I table fields

Field Data element Checktable Datatype Length Decimals
TICKETNR OIL-TSW: External ticket number OIJ_TKTNR CHAR 20 0
TICKET_TYPE OIL-TSW: Ticket type OIJ_EL_TKT_TYPE CHAR 3 0
MANDT Client MANDT T000 CLNT 3 0
TICKET_KEY OIL-TSW: Ticket key OIJ_EL_TKT_KEY OIJ_EL_TICKET_H CHAR 20 0
TICKET_ITEM OIL-TSW: Ticket item number OIJ_EL_TKT_POSNR NUMC 6 0
TICKET_VERSION OIL-TSW: Ticket version OIJ_EL_TKT_VERSION NUMC 3 0
TICKET_PURPOSE OIL-TSW: Ticket Purpose OIJ_EL_TKT_PURPOSE CHAR 1 0
1 Field ticket
2 Correction
3 Final confirmation
4 Internally generated for posting
5 Reversal
EXT_POSNR External position number OIJ_EL_EXT_POS CHAR 6 0
STATUS Nomination Item status OIJ_ISTAT CHAR 1 0
1 Planned
2 Scheduled
3 Accepted
4 Confirmed
5 Partially complete
6 Complete
7 Rejected
8 Dummy
9 Received
A Sent
B Checked
C Processed
SUBSTATUS Nomination Item sub-status OIJ_SSTAT CHAR 1 0
1 Original
2 2nd run
3 3rd run
4 Positive
5 Negative
6 Complete
7 Part1
8 Part2
9 Part3
A Partially complete
B Complete
C Planned
D Scheduled
E Confirmed
F Rejected
SITYP Schedule type OIJ_SITYP TOIJ_EL_SITYPES CHAR 2 0
TKTSUBRC OIL-TSW: Ticket process return code OIJ_TKTRC CHAR 2 0
00 Ticket Actualization Process Completed
01 Nomination not found
02 Nomination item not found
03 Wrong Carrier
04 Carrier not found
05 Wrong Shipper
06 Shipper not found
07 Wrong Tankage
08 Tankage not found
09 Wrong Consignee
10 Consignee not found
11 Nomination Item Status Rejected
12 Nomination Item Status Complete
13 Nomination Item: Confirmation missing
14 Posting of ticket quantity would exceed scheduled quantitiy
15 Wrong Transport System
16 Transport system not found
17 Wrong Location
18 Location not found
19 Wrong Purchase order
20 Purchase Order: Item number missing
21 Purchase order: Item quantity exceeds tolerance
22 Wrong Sales order
23 Sales order: Item number missing
24 Sales order: Item quantity exceeds tolerance
25 Error while Posting Shipping Notification
26 Error while Creating Shipment
27 Load confirmation posted
28 Reservation posted
29 Ticket: Nomination Number missing
30 Nomination Number not unique
31 Nomination Item not unique
32 Nomination Item: Copy not unique
33 Nomination Item: SITYP missing
34 Nomination Item: Wrong SITYP
35 Material Number missing
36 Wrong Material Number
37 Ticket: Quantity missing
38 Movement Scenario not found
39 Unit of Measure missing
40 Ticket: End Date missing
41 TD vehicle number missing in nomination
42 TD shipment Type missing in nomination
43 TD Transportation planning point missing in nomination
44 Plant and Storage Location for movement destination missing
45 Unit Conversion: required Fields not filled
46 Unit Conversion: Default values for material not found
47 Unit Conversion: Calculation Error
48 Other uncomplete similar Ticket found: complete this first
49 Plant and Storage Location for movement origin missing
50 Ticket saved - no validation performed
51 Error occurred in carrier ticket customer function.
52 Error while Posting Load Confirmation
53 Error while Posting Reservation
54 Error while Posting Delivery
55 Error while Posting Delivery Confirmation
56 Error while Update Nomination (Act. Qty.)
57 Error while Changing Shipment
58 Shipping notification posted
59 Shipment posted
60 Delivery posted
61 Delivery Confirmation posted
62 Nomination updated
63 Shipment Change posted
64 Sales Order : Shipping Point missing
65 Failure while Locking Nomination
69 Posting Date is not valid
70 Cannot actualize a ticket for a future date or time.
71 Purchase Order : Del. Date < Ticket End Date
72 Sales Order : Del. Date > Ticket End Date
73 Error while Posting Goods Receipt
74 Error while Posting Billing Document
75 Error while Create Ticket : Duplicate Record found
76 Error while actualizing. For details look up error log.
77 Nomination/Item currently locked by other user
78 Partially posted
80 Error while validating. For details look up error log.
87 Error while updating database table
95 Validation failed
96 Ticket abandonned by user
98 Ticket Validated and Saved
99 Initial
1A Ticket corrupted
MVSCENARIO TSW: Movement scenario number OIJ_MVSCEN TOIJ_EL_MVSCEN NUMC 2 0
NOMNR Nomination number OIJ_NOMNR CHAR 20 0
NOMTK Nomination (technical) Key OIJ_NOMTK OIJNOMH CHAR 20 0
NOMIT Nomination Key Item OIJ_ITEM OIJNOMI NUMC 10 0
RECEIVER Location Partner OIJ_PARTNR CHAR 10 0
LOCID Location ID OIJ_LOCID OIJLOC CHAR 10 0
TANKNR Sequence number of tank assigned to a business location OIJ_BSEQNR CHAR 10 0
VEHICLE TD Vehicle Number OIG_VHLNMR OIGV CHAR 10 0
MENGE Scheduled qty OIJ_MENGE QUAN 13 3
GROSQUAN Scheduled qty OIJ_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
TANKAGE Tankage Partner OIJ_TANKAGE CHAR 10 0
SUPPLIER Location Partner OIJ_PARTNR CHAR 10 0
CONSIGNE Consignee Partner OIJ_CONSIGNEE CHAR 10 0
AGREED_QTY agreed qty. between ship. measr. and shore measrd. quants. OIJ_AGGRDQTY QUAN 13 3
AGREED_QTY_UOM Loaded/Discharged Material UOM OIJ_LDUOM UNIT 3 0
SHIP_QTY ship measured ld/disc. material quantity OIJ_SHIPQTY QUAN 13 3
SHIP_QTY_UOM Loaded/Discharged Material UOM OIJ_LDUOM UNIT 3 0
MTTMP Oil/Gas Material Temperature: Observed Quantity OIB_MTTMP FLTP 16 16
MTTEH Oil/Gas Material Temperature Unit: Observed Quantity OIB_MTTEH T006 UNIT 3 0
O_API_GRAV Oil/Gas Test Density OIB_TDICH FLTP 16 16
API_GRT_D Oil/Gas Test Density OIB_TDICH FLTP 16 16
TSTMP Oil/Gas Test Temperature: Observed Density OIB_TSTMP FLTP 16 16
TSTEH Test Temperature Unit (Density): Measurement OIB_TSTEH T006 UNIT 3 0
TDICH Oil/Gas Test Density OIB_TDICH FLTP 16 16
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time of creation OI0_ERTIM TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of day the record was changed OI0_AETIM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BLOIND Blocking indicator OIJ_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
BUDAT Posting Date in the Document BUDAT DATS 8 0
CLOSE_NOMIT IS OIL TSW: Indicator close nomination OIJ_EL_CLOSE_NOMIT CHAR 1 0
X Close nomination item
NULL space
EVENTTYPE TSW event date type OIJ_EVENTTYPE OIJ_EL_EVT_TYPE CHAR 16 0
EVENT_DATE OIL-TSW: Event date OIJ_EVENT_DATE DATS 8 0
GMMNR GMM: Number of general meter OII_GMMNR CHAR 20 0
O_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
O_METEV GMM: History record type OII_METEV CHAR 2 0
C_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
C_METEV GMM: History record type OII_METEV CHAR 2 0
STOPRDG GMM: End counter reading OII_ENCOUN NUMC 12 0
STM_QUANTITY Stop meter calculation Quantity OIJ_STM_QUANT QUAN 13 3
STM_UOM Stop meter calculation UOM OIJ_STM_UOM UNIT 3 0
SOCNR SOC: Storage object characteristic segment number OII_SOCNR CHAR 20 0
O_DIP_READ Open dip reading OIJ_O_DIP_READ QUAN 13 3
O_DIP_READ_UOM Length UoM (Oil BDRP) OII_LENUN UNIT 3 0
O_ETMSTM Tank dip time stamp OIB_TMSTM NUMC 14 0
O_SOCEV Events in silo management tank dips OIB_DIP_EVENTKEY CHAR 2 0
NULL Height entry Standard Dip
O Opening dip Height entry
C Closing dip Height entry
Q Quantity entry Standard Dip
QO Opening dip Quantity entry
QC Closing dip Quantity entry
M Mass entry Standard Dip
MO Opening dip Mass entry
MC Closing dip Mass entry
C_DIP_READ Close Dip reading OIJ_C_DIP_READ QUAN 13 3
C_DIP_READ_UOM Length UoM (Oil BDRP) OII_LENUN UNIT 3 0
C_ETMSTM Tank dip time stamp OIB_TMSTM NUMC 14 0
C_SOCEV Events in silo management tank dips OIB_DIP_EVENTKEY CHAR 2 0
NULL Height entry Standard Dip
O Opening dip Height entry
C Closing dip Height entry
Q Quantity entry Standard Dip
QO Opening dip Quantity entry
QC Closing dip Quantity entry
M Mass entry Standard Dip
MO Opening dip Mass entry
MC Closing dip Mass entry
STOPDIP Tank dip, total height OII_TOTALHEIGHT QUAN 13 3
STOPDIP_UOM Length UoM (Oil BDRP) OII_LENUN UNIT 3 0
STP_GAU_QUAN Stop gauge calculation - Quantity OIJ_STG_QUAN QUAN 13 3
STP_GAU_UOM Stop gauge calculation UOM OIJ_STG_UOM UNIT 3 0
GAU_QUANTITY Calculated Gauge Quantity OIJ_GAU_QUAN QUAN 13 3
GAU_UOM Gauge Calculation UoM OIJ_GAU_UOM UNIT 3 0
SHTYPE TD shipment type OIG_TDSTYP TOIGS CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
CHARG_O Batch origin Location OIJ_CHARGO MCH1 CHAR 10 0
WERKS_O Plant WERKS_D T001W CHAR 4 0
LGORT_O Storage Location LGORT_D T001L CHAR 4 0
CHARG_D Batch destination Location OIJ_CHARGD MCH1 CHAR 10 0
WERKS_D Plant WERKS_D T001W CHAR 4 0
LGORT_D Storage Location LGORT_D T001L CHAR 4 0
TIME_ST_LOAD_STA Time at which data was created (date and time) TMSTMP CHAR 14 0
TIME_ST_LOAD_END Time at which data was created (date and time) TMSTMP CHAR 14 0
TIME_ST_LED_OT Time at which data was created (date and time) TMSTMP CHAR 14 0
CHARG_D_CREATE Destination Batch create new flag OIJ_CHARG_D_C CHAR 1 0
X Yes
NULL No
OIB_BLTIME Posting time in the document OIB_BLTIME TIMS 6 0
CHARG_L Batch load OIJ_CHARGL CHAR 10 0
CHARG_L_CREATE Load Batch create new flag OIJ_CHARG_L_C CHAR 1 0
X Yes
NULL No
SHTYP Shipment type SHTYP TVTK CHAR 4 0
MENGE_PAR Scheduled Parallel quantity OIJ_MENGE_PAR QUAN 13 3
UNIT_I_PAR Parallel Unit of measure OIJ_UNIT_PAR UNIT 3 0
RAILCARQTY Number of Railcars OIJ_RU_RAILQTY INT4 10 0
LDPLT Loading plant OIG_LDPLT CHAR 4 0
ITPLT In-Transit Plant OIG_ITPLT CHAR 4 0
ITSTLC In-Transit Storage Location OIG_ITSTLC CHAR 4 0
ITBTCH In-Transit Batch OIG_ITBTCH CHAR 10 0
CARRIER Transport system Carrier OIJ_CARRNR CHAR 10 0

ROIJ_EL_TICKET_I foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIJ_EL_TICKET_I CHARG_D ROIJ_EL_TICKET_I CHARG_D MCH1 Batches (if Batch Management Cross-Plant) CHARG
ROIJ_EL_TICKET_I CHARG_D ROIJ_EL_TICKET_I MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
ROIJ_EL_TICKET_I CHARG_D ROIJ_EL_TICKET_I MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
ROIJ_EL_TICKET_I CHARG_O ROIJ_EL_TICKET_I MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
ROIJ_EL_TICKET_I CHARG_O ROIJ_EL_TICKET_I MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
ROIJ_EL_TICKET_I CHARG_O ROIJ_EL_TICKET_I CHARG_O MCH1 Batches (if Batch Management Cross-Plant) CHARG
ROIJ_EL_TICKET_I EVENTTYPE ROIJ_EL_TICKET_I EVENTTYPE OIJ_EL_EVT_TYPE Event date types EVENTTYPE
ROIJ_EL_TICKET_I EVENTTYPE ROIJ_EL_TICKET_I MANDT OIJ_EL_EVT_TYPE Event date types MANDT
ROIJ_EL_TICKET_I LGORT_D ROIJ_EL_TICKET_I MANDT T001L Storage Locations MANDT
ROIJ_EL_TICKET_I LGORT_D ROIJ_EL_TICKET_I WERKS_D T001L Storage Locations WERKS
ROIJ_EL_TICKET_I LGORT_D ROIJ_EL_TICKET_I LGORT_D T001L Storage Locations LGORT
ROIJ_EL_TICKET_I LGORT_O ROIJ_EL_TICKET_I LGORT_O T001L Storage Locations LGORT
ROIJ_EL_TICKET_I LGORT_O ROIJ_EL_TICKET_I WERKS_O T001L Storage Locations WERKS
ROIJ_EL_TICKET_I LGORT_O ROIJ_EL_TICKET_I MANDT T001L Storage Locations MANDT
ROIJ_EL_TICKET_I LOCID ROIJ_EL_TICKET_I LOCID OIJLOC Location table LOCID
ROIJ_EL_TICKET_I LOCID ROIJ_EL_TICKET_I MANDT OIJLOC Location table MANDT
ROIJ_EL_TICKET_I MANDT ROIJ_EL_TICKET_I MANDT T000 Clients MANDT
ROIJ_EL_TICKET_I MATNR ROIJ_EL_TICKET_I MANDT MARA General Material Data MANDT
ROIJ_EL_TICKET_I MATNR ROIJ_EL_TICKET_I MATNR MARA General Material Data MATNR
ROIJ_EL_TICKET_I MEINS ROIJ_EL_TICKET_I MANDT T006 Units of Measurement MANDT
ROIJ_EL_TICKET_I MEINS ROIJ_EL_TICKET_I MEINS T006 Units of Measurement MSEHI
ROIJ_EL_TICKET_I MTTEH SYST MANDT T006 Units of Measurement MANDT
ROIJ_EL_TICKET_I MTTEH ROIJ_EL_TICKET_I MTTEH T006 Units of Measurement MSEHI
ROIJ_EL_TICKET_I MVSCENARIO ROIJ_EL_TICKET_I MVSCENARIO TOIJ_EL_MVSCEN TSW: Define Movement scenarios MVSCENARIO
ROIJ_EL_TICKET_I MVSCENARIO ROIJ_EL_TICKET_I MANDT TOIJ_EL_MVSCEN TSW: Define Movement scenarios CLIENT
ROIJ_EL_TICKET_I NOMIT ROIJ_EL_TICKET_I NOMIT OIJNOMI Nomination Item NOMIT
ROIJ_EL_TICKET_I NOMIT ROIJ_EL_TICKET_I NOMTK OIJNOMI Nomination Item NOMTK
ROIJ_EL_TICKET_I NOMIT ROIJ_EL_TICKET_I MANDT OIJNOMI Nomination Item MANDT
ROIJ_EL_TICKET_I NOMTK ROIJ_EL_TICKET_I MANDT OIJNOMH Nomination Header MANDT
ROIJ_EL_TICKET_I NOMTK ROIJ_EL_TICKET_I NOMTK OIJNOMH Nomination Header NOMTK
ROIJ_EL_TICKET_I SHTYP ROIJ_EL_TICKET_I SHTYP TVTK Shipment Types SHTYP
ROIJ_EL_TICKET_I SHTYP ROIJ_EL_TICKET_I MANDT TVTK Shipment Types MANDT
ROIJ_EL_TICKET_I SHTYPE ROIJ_EL_TICKET_I SHTYPE TOIGS TD Shipment Types SHTYP
ROIJ_EL_TICKET_I SHTYPE ROIJ_EL_TICKET_I MANDT TOIGS TD Shipment Types CLIENT
ROIJ_EL_TICKET_I SITYP ROIJ_EL_TICKET_I SITYP TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
ROIJ_EL_TICKET_I SITYP ROIJ_EL_TICKET_I MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
ROIJ_EL_TICKET_I TICKET_KEY ROIJ_EL_TICKET_I MANDT OIJ_EL_TICKET_H Universal ticket table MANDT
ROIJ_EL_TICKET_I TICKET_KEY ROIJ_EL_TICKET_I TICKET_KEY OIJ_EL_TICKET_H Universal ticket table TICKET_KEY
ROIJ_EL_TICKET_I TICKET_KEY ROIJ_EL_TICKET_I TICKET_VERSION OIJ_EL_TICKET_H Universal ticket table TICKET_VERSION
ROIJ_EL_TICKET_I TICKET_KEY ROIJ_EL_TICKET_I TICKET_PURPOSE OIJ_EL_TICKET_H Universal ticket table TICKET_PURPOSE
ROIJ_EL_TICKET_I TSTEH SYST MANDT T006 Units of Measurement MANDT
ROIJ_EL_TICKET_I TSTEH ROIJ_EL_TICKET_I TSTEH T006 Units of Measurement MSEHI
ROIJ_EL_TICKET_I VEHICLE ROIJ_EL_TICKET_I VEHICLE OIGV TD Vehicle Header VEHICLE
ROIJ_EL_TICKET_I VEHICLE ROIJ_EL_TICKET_I MANDT OIGV TD Vehicle Header CLIENT
ROIJ_EL_TICKET_I VSTEL ROIJ_EL_TICKET_I VSTEL TVST Organizational Unit: Shipping Points VSTEL
ROIJ_EL_TICKET_I VSTEL ROIJ_EL_TICKET_I MANDT TVST Organizational Unit: Shipping Points MANDT
ROIJ_EL_TICKET_I WERKS_D ROIJ_EL_TICKET_I WERKS_D T001W Plants/Branches WERKS
ROIJ_EL_TICKET_I WERKS_D ROIJ_EL_TICKET_I MANDT T001W Plants/Branches MANDT
ROIJ_EL_TICKET_I WERKS_O ROIJ_EL_TICKET_I WERKS_O T001W Plants/Branches WERKS
ROIJ_EL_TICKET_I WERKS_O ROIJ_EL_TICKET_I MANDT T001W Plants/Branches MANDT