OIJ_EL_TICKET_I

Universal ticket item table | #transactional | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
TICKET_KEY FK OIL-TSW: Ticket key
TICKET_ITEM OIL-TSW: Ticket item number
TICKET_VERSION OIL-TSW: Ticket version
TICKET_PURPOSE OIL-TSW: Ticket Purpose Show values
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Scheduled qty
GROSQUAN Scheduled qty
📏 Loaded/Discharged Material UOM (AGREED_QTY_UOM):
AGREED_QTY agreed qty. between ship. measr. and shore measrd. quants.
📏 Loaded/Discharged Material UOM (SHIP_QTY_UOM):
SHIP_QTY ship measured ld/disc. material quantity
📏 Stop meter calculation UOM (STM_UOM):
STM_QUANTITY Stop meter calculation Quantity
📏 Length UoM (Oil BDRP) (O_DIP_READ_UOM):
O_DIP_READ Open dip reading
📏 Length UoM (Oil BDRP) (C_DIP_READ_UOM):
C_DIP_READ Close Dip reading
📏 Length UoM (Oil BDRP) (STOPDIP_UOM):
STOPDIP Tank dip, total height
📏 Stop gauge calculation UOM (STP_GAU_UOM):
STP_GAU_QUAN Stop gauge calculation - Quantity
📏 Gauge Calculation UoM (GAU_UOM):
GAU_QUANTITY Calculated Gauge Quantity
📏 Parallel Unit of measure (UNIT_I_PAR):
MENGE_PAR Scheduled Parallel quantity
Column Name Description
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
BUDAT Posting Date in the Document
EVENT_DATE OIL-TSW: Event date
OIB_BLTIME Posting time in the document
_DATAAGING Data Filter Value for Data Aging
Column Name Description
TICKET_PURPOSE OIL-TSW: Ticket Purpose Show values
STATUS Nomination Item status Show values
SUBSTATUS Nomination Item sub-status Show values
TKTSUBRC OIL-TSW: Ticket process return code Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
TKTSELECT Flag to Set Tickets Selectable Show values
CLOSE_NOMIT IS OIL TSW: Indicator close nomination Show values
O_SOCEV Events in silo management tank dips Show values
C_SOCEV Events in silo management tank dips Show values
CHARG_D_CREATE Destination Batch create new flag Show values
CHARG_L_CREATE Load Batch create new flag Show values
Column Name Description Domain name
EXT_POSNR External position number CHAR6
NOMNR Nomination number OIJ_NOMNR
RECEIVER Location Partner OIJ_PARTNR
TANKNR Sequence number of tank assigned to a business location OII_SEQNR
TANKAGE Tankage Partner OIJ_PARTNR
SUPPLIER Location Partner OIJ_PARTNR
CONSIGNE Consignee Partner OIJ_PARTNR
MTTMP Oil/Gas Material Temperature: Observed Quantity TEMP_VALUE
O_API_GRAV Oil/Gas Test Density OIB_DICHT
API_GRT_D Oil/Gas Test Density OIB_DICHT
TSTMP Oil/Gas Test Temperature: Observed Density TEMP_VALUE
TDICH Oil/Gas Test Density OIB_DICHT
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
GMMNR GMM: Number of general meter OII_GMMNR
O_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
O_METEV GMM: History record type OII_METEV
C_ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
C_METEV GMM: History record type OII_METEV
STOPRDG GMM: End counter reading OII_MCOUNT
SOCNR SOC: Storage object characteristic segment number OII_SOCNR
O_ETMSTM Tank dip time stamp OII_TIMEST
C_ETMSTM Tank dip time stamp OII_TIMEST
TIME_ST_LOAD_STA Time at Which Data Was Created (Date and Time) CHAR14
TIME_ST_LOAD_END Time at Which Data Was Created (Date and Time) CHAR14
TIME_ST_LED_OT Time at Which Data Was Created (Date and Time) CHAR14
CHARG_L Batch load CHARG
RAILCARQTY Number of Railcars INT4_NOS
DUMMY_TKTITM_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC10
Master Data Relations Join Conditions
Batch destination Location
  • Material Number
  • Client
  • Batch destination Location
  • OIJ_EL_TICKET_I.MATNR == MCH1.MATNR
  • OIJ_EL_TICKET_I.MANDT == MCH1.MANDT
  • OIJ_EL_TICKET_I.CHARG_D == MCH1.CHARG
Batch origin Location
  • Material Number
  • Client
  • Batch origin Location
  • OIJ_EL_TICKET_I.MATNR == MCH1.MATNR
  • OIJ_EL_TICKET_I.MANDT == MCH1.MANDT
  • OIJ_EL_TICKET_I.CHARG_O == MCH1.CHARG
TSW event date type
  • TSW event date type
  • Client
Storage location
  • Storage location
  • Client
  • Plant
  • OIJ_EL_TICKET_I.LGORT_D == T001L.LGORT
  • OIJ_EL_TICKET_I.MANDT == T001L.MANDT
  • OIJ_EL_TICKET_I.WERKS_D == T001L.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • OIJ_EL_TICKET_I.LGORT_O == T001L.LGORT
  • OIJ_EL_TICKET_I.MANDT == T001L.MANDT
  • OIJ_EL_TICKET_I.WERKS_O == T001L.WERKS
Location ID
  • OIJ_EL_TICKET_I.MANDT == OIJLOC.MANDT
  • OIJ_EL_TICKET_I.LOCID == OIJLOC.LOCID
Client OIJ_EL_TICKET_I.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIJ_EL_TICKET_I.MATNR == MARA.MATNR
  • OIJ_EL_TICKET_I.MANDT == MARA.MANDT
Base Unit of Measure
  • OIJ_EL_TICKET_I.MANDT == T006.MANDT
  • OIJ_EL_TICKET_I.MEINS == T006.MSEHI
Oil/Gas Material Temperature Unit: Observed Quantity
  • OIJ_EL_TICKET_I.MANDT == T006.MANDT
  • OIJ_EL_TICKET_I.MTTEH == T006.MSEHI
TSW: Movement scenario number
  • TSW: Movement scenario number
  • Client
Shipment type
  • OIJ_EL_TICKET_I.MANDT == TVTK.MANDT
  • OIJ_EL_TICKET_I.SHTYP == TVTK.SHTYP
TD shipment type
  • OIJ_EL_TICKET_I.MANDT == TOIGS.CLIENT
  • OIJ_EL_TICKET_I.SHTYPE == TOIGS.SHTYP
Schedule type
Test Temperature Unit (Density): Measurement
  • OIJ_EL_TICKET_I.MANDT == T006.MANDT
  • OIJ_EL_TICKET_I.TSTEH == T006.MSEHI
TD Vehicle Number
  • OIJ_EL_TICKET_I.MANDT == OIGV.CLIENT
  • OIJ_EL_TICKET_I.VEHICLE == OIGV.VEHICLE
Shipping Point / Receiving Point
  • OIJ_EL_TICKET_I.MANDT == TVST.MANDT
  • OIJ_EL_TICKET_I.VSTEL == TVST.VSTEL
Plant
  • OIJ_EL_TICKET_I.MANDT == T001W.MANDT
  • OIJ_EL_TICKET_I.WERKS_D == T001W.WERKS
Plant
  • OIJ_EL_TICKET_I.MANDT == T001W.MANDT
  • OIJ_EL_TICKET_I.WERKS_O == T001W.WERKS