SAP table OIJ_EL_TICKET_I (Universal ticket item table)

SAP table OIJ_EL_TICKET_I has 5 primary key fields being MANDT,TICKET_KEY,TICKET_ITEM,TICKET_VERSION,TICKET_PURPOSE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TICKET_KEY OIL-TSW: Ticket key CHAR 20 0 OIJ_EL_TICKET_H OIJ_EL_TKT_KEY
TICKET_ITEM OIL-TSW: Ticket item number NUMC 6 0 OIJ_EL_TKT_POSNR
TICKET_VERSION OIL-TSW: Ticket version NUMC 3 0 OIJ_EL_TKT_VERSION
TICKET_PURPOSE OIL-TSW: Ticket Purpose CHAR 1 0 OIJ_EL_TKT_PURPOSE
1 Field ticket
2 Correction
3 Final confirmation
4 Internally generated for posting
5 Reversal
EXT_POSNR External position number CHAR 6 0 OIJ_EL_EXT_POS
STATUS Nomination Item status CHAR 1 0 OIJ_ISTAT
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 CHAR 1 0 OIJ_SSTAT
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 CHAR 2 0 TOIJ_EL_SITYPES OIJ_SITYP
TKTSUBRC OIL-TSW: Ticket process return code CHAR 2 0 OIJ_TKTRC
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
1A Ticket corrupted
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
MVSCENARIO TSW: Movement scenario number NUMC 2 0 TOIJ_EL_MVSCEN OIJ_MVSCEN
NOMNR Nomination number CHAR 20 0 OIJ_NOMNR
NOMTK Nomination (technical) Key CHAR 20 0 OIJNOMH OIJ_NOMTK
NOMIT Nomination Key Item NUMC 10 0 OIJNOMI OIJ_ITEM
RECEIVER Location Partner CHAR 10 0 OIJ_PARTNR
LOCID Location ID CHAR 10 0 OIJLOC OIJ_LOCID
TANKNR Sequence number of tank assigned to a business location CHAR 10 0 OIJ_BSEQNR
VEHICLE TD Vehicle Number CHAR 10 0 OIGV OIG_VHLNMR
MENGE Scheduled qty QUAN 13 3 OIJ_MENGE
GROSQUAN Scheduled qty QUAN 13 3 OIJ_MENGE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MATNR Material Number CHAR 40 0 MARA MATNR
TANKAGE Tankage Partner CHAR 10 0 OIJ_TANKAGE
SUPPLIER Location Partner CHAR 10 0 OIJ_PARTNR
CONSIGNE Consignee Partner CHAR 10 0 OIJ_CONSIGNEE
AGREED_QTY agreed qty. between ship. measr. and shore measrd. quants. QUAN 13 3 OIJ_AGGRDQTY
AGREED_QTY_UOM Loaded/Discharged Material UOM UNIT 3 0 OIJ_LDUOM
SHIP_QTY ship measured ld/disc. material quantity QUAN 13 3 OIJ_SHIPQTY
SHIP_QTY_UOM Loaded/Discharged Material UOM UNIT 3 0 OIJ_LDUOM
MTTMP Oil/Gas Material Temperature: Observed Quantity FLTP 16 16 OIB_MTTMP
MTTEH Oil/Gas Material Temperature Unit: Observed Quantity UNIT 3 0 T006 OIB_MTTEH
O_API_GRAV Oil/Gas Test Density FLTP 16 16 OIB_TDICH
API_GRT_D Oil/Gas Test Density FLTP 16 16 OIB_TDICH
TSTMP Oil/Gas Test Temperature: Observed Density FLTP 16 16 OIB_TSTMP
TSTEH Test Temperature Unit (Density): Measurement UNIT 3 0 T006 OIB_TSTEH
TDICH Oil/Gas Test Density FLTP 16 16 OIB_TDICH
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZEIT Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BLOIND Blocking indicator CHAR 1 0 OIJ_BLOIND
DELIND Deletion indicator CHAR 1 0 OIJ_DELIND
TKTSELECT Flag to Set Tickets Selectable CHAR 1 0 OIJ_TKTSELECT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
CLOSE_NOMIT IS OIL TSW: Indicator close nomination CHAR 1 0 OIJ_EL_CLOSE_NOMIT
space
X Close nomination item
EVENTTYPE TSW event date type CHAR 16 0 OIJ_EL_EVT_TYPE OIJ_EVENTTYPE
EVENT_DATE OIL-TSW: Event date DATS 8 0 OIJ_EVENT_DATE
GMMNR GMM: Number of general meter CHAR 20 0 * OII_GMMNR
O_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
O_METEV GMM: History record type CHAR 2 0 * OII_METEV
C_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
C_METEV GMM: History record type CHAR 2 0 * OII_METEV
STOPRDG GMM: End counter reading NUMC 12 0 OII_ENCOUN
STM_QUANTITY Stop meter calculation Quantity QUAN 13 3 OIJ_STM_QUANT
STM_UOM Stop meter calculation UOM UNIT 3 0 * OIJ_STM_UOM
SOCNR SOC: Storage object characteristic segment number CHAR 20 0 * OII_SOCNR
O_DIP_READ Open dip reading QUAN 13 3 OIJ_O_DIP_READ
O_DIP_READ_UOM Length UoM (Oil BDRP) UNIT 3 0 * OII_LENUN
O_ETMSTM Tank dip time stamp NUMC 14 0 OIB_TMSTM
O_SOCEV Events in silo management tank dips CHAR 2 0 OIB_DIP_EVENTKEY
Height entry Standard Dip
C Closing dip Height entry
M Mass entry Standard Dip
MC Closing dip Mass entry
MO Opening dip Mass entry
O Opening dip Height entry
Q Quantity entry Standard Dip
QC Closing dip Quantity entry
QO Opening dip Quantity entry
C_DIP_READ Close Dip reading QUAN 13 3 OIJ_C_DIP_READ
C_DIP_READ_UOM Length UoM (Oil BDRP) UNIT 3 0 * OII_LENUN
C_ETMSTM Tank dip time stamp NUMC 14 0 OIB_TMSTM
C_SOCEV Events in silo management tank dips CHAR 2 0 OIB_DIP_EVENTKEY
Height entry Standard Dip
C Closing dip Height entry
M Mass entry Standard Dip
MC Closing dip Mass entry
MO Opening dip Mass entry
O Opening dip Height entry
Q Quantity entry Standard Dip
QC Closing dip Quantity entry
QO Opening dip Quantity entry
STOPDIP Tank dip, total height QUAN 13 3 OII_TOTALHEIGHT
STOPDIP_UOM Length UoM (Oil BDRP) UNIT 3 0 * OII_LENUN
STP_GAU_QUAN Stop gauge calculation - Quantity QUAN 13 3 OIJ_STG_QUAN
STP_GAU_UOM Stop gauge calculation UOM UNIT 3 0 * OIJ_STG_UOM
GAU_QUANTITY Calculated Gauge Quantity QUAN 13 3 OIJ_GAU_QUAN
GAU_UOM Gauge Calculation UoM UNIT 3 0 * OIJ_GAU_UOM
SHTYPE TD shipment type CHAR 4 0 TOIGS OIG_TDSTYP
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
CHARG_O Batch origin Location CHAR 10 0 MCH1 OIJ_CHARGO
WERKS_O Plant CHAR 4 0 T001W WERKS_D
LGORT_O Storage location CHAR 4 0 T001L LGORT_D
CHARG_D Batch destination Location CHAR 10 0 MCH1 OIJ_CHARGD
WERKS_D Plant CHAR 4 0 T001W WERKS_D
LGORT_D Storage location CHAR 4 0 T001L LGORT_D
TIME_ST_LOAD_STA Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP
TIME_ST_LOAD_END Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP
TIME_ST_LED_OT Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP
CHARG_D_CREATE Destination Batch create new flag CHAR 1 0 OIJ_CHARG_D_C
OIB_BLTIME Posting time in the document TIMS 6 0 OIB_BLTIME
CHARG_L Batch load CHAR 10 0 OIJ_CHARGL
CHARG_L_CREATE Load Batch create new flag CHAR 1 0 OIJ_CHARG_L_C
SHTYP Shipment type CHAR 4 0 TVTK SHTYP
MENGE_PAR Scheduled Parallel quantity QUAN 13 3 OIJ_MENGE_PAR
UNIT_I_PAR Parallel Unit of measure UNIT 3 0 * OIJ_UNIT_PAR
RAILCARQTY Number of Railcars INT4 10 0 OIJ_RU_RAILQTY
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_TKTITM_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC 10 0 OIJ07_EXTN

OIJ_EL_TICKET_I foreign key relationships

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