1. SAP Tutorial
  2. Oil & Gas

OIJ_EL_TICKET_I SAP table for – Universal ticket item table

Here we would like to draw your attention to OIJ_EL_TICKET_I table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJ_EL_TICKET_I is a SAP standard transp table used for storing Universal ticket item table related data in SAP. It comes under the package OIJ_EL.

SAP OIJ_EL_TICKET_I table

Table OIJ_EL_TICKET_I technical data

TableOIJ_EL_TICKET_I
Data storingUniversal ticket item table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ_EL
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJ_EL_TICKET_I Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJ_EL_TICKET_I table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TICKET_KEY : OIL-TSW: Ticket key
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • TICKET_ITEM : OIL-TSW: Ticket item number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • TICKET_VERSION : OIL-TSW: Ticket version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • TICKET_PURPOSE : OIL-TSW: Ticket Purpose
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EXT_POSNR : External position number
    Its data type is CHAR (Character String) with field length 6
  • STATUS : Nomination Item status
    Its data type is CHAR (Character String) with field length 1
  • SUBSTATUS : Nomination Item sub-status
    Its data type is CHAR (Character String) with field length 1
  • SITYP : Schedule type
    Its data type is CHAR (Character String) with field length 2
  • TKTSUBRC : OIL-TSW: Ticket process return code
    Its data type is CHAR (Character String) with field length 2
  • MVSCENARIO : TSW: Movement scenario number
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NOMNR : Nomination number
    Its data type is CHAR (Character String) with field length 20
  • NOMTK : Nomination (technical) Key
    Its data type is CHAR (Character String) with field length 20
  • NOMIT : Nomination Key Item
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • RECEIVER : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    Its data type is CHAR (Character String) with field length 10
  • TANKNR : Sequence number of tank assigned to a business location
    Its data type is CHAR (Character String) with field length 10
  • VEHICLE : TD Vehicle Number
    Its data type is CHAR (Character String) with field length 10
  • MENGE : Scheduled qty
    Its data type is QUAN (Quantity field) with field length 13
  • GROSQUAN : Scheduled qty
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • TANKAGE : Tankage Partner
    Its data type is CHAR (Character String) with field length 10
  • SUPPLIER : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • CONSIGNE : Consignee Partner
    Its data type is CHAR (Character String) with field length 10
  • AGREED_QTY : agreed qty. between ship. measr. and shore measrd. quants.
    Its data type is QUAN (Quantity field) with field length 13
  • AGREED_QTY_UOM : Loaded/Discharged Material UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SHIP_QTY : ship measured ld/disc. material quantity
    Its data type is QUAN (Quantity field) with field length 13
  • SHIP_QTY_UOM : Loaded/Discharged Material UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : OIL-TSW: Data for QCI
  • MTTMP : Oil/Gas Material Temperature: Observed Quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTTEH : Oil/Gas Material Temperature Unit: Observed Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • O_API_GRAV : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • API_GRT_D : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • TSTMP : Oil/Gas Test Temperature: Observed Density
    Its data type is FLTP (Floating point number) with field length 16
  • TSTEH : Test Temperature Unit (Density): Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TDICH : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLOSE_NOMIT : IS OIL TSW: Indicator close nomination
    Its data type is CHAR (Character String) with field length 1
  • EVENTTYPE : TSW event date type
    Its data type is CHAR (Character String) with field length 16
  • EVENT_DATE : OIL-TSW: Event date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Meter Details in Ticket Item
  • GMMNR : GMM: Number of general meter
    Its data type is CHAR (Character String) with field length 20
  • O_ITMSTM : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • O_METEV : GMM: History record type
    Its data type is CHAR (Character String) with field length 2
  • C_ITMSTM : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • C_METEV : GMM: History record type
    Its data type is CHAR (Character String) with field length 2
  • STOPRDG : GMM: End counter reading
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • STM_QUANTITY : Stop meter calculation Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • STM_UOM : Stop meter calculation UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Tank details structure
  • SOCNR : SOC: Storage object characteristic segment number
    Its data type is CHAR (Character String) with field length 20
  • O_DIP_READ : Open dip reading
    Its data type is QUAN (Quantity field) with field length 13
  • O_DIP_READ_UOM : Length UoM (Oil BDRP)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • O_ETMSTM : Tank dip time stamp
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • O_SOCEV : Events in silo management tank dips
    Its data type is CHAR (Character String) with field length 2
  • C_DIP_READ : Close Dip reading
    Its data type is QUAN (Quantity field) with field length 13
  • C_DIP_READ_UOM : Length UoM (Oil BDRP)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • C_ETMSTM : Tank dip time stamp
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • C_SOCEV : Events in silo management tank dips
    Its data type is CHAR (Character String) with field length 2
  • STOPDIP : Tank dip, total height
    Its data type is QUAN (Quantity field) with field length 13
  • STOPDIP_UOM : Length UoM (Oil BDRP)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • STP_GAU_QUAN : Stop gauge calculation – Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • STP_GAU_UOM : Stop gauge calculation UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GAU_QUANTITY : Calculated Gauge Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • GAU_UOM : Gauge Calculation UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SHTYPE : TD shipment type
    Its data type is CHAR (Character String) with field length 4
  • VSTEL : Shipping Point/Receiving Point
    Its data type is CHAR (Character String) with field length 4
  • CHARG_O : Batch origin Location
    Its data type is CHAR (Character String) with field length 10
  • WERKS_O : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT_O : Storage location
    Its data type is CHAR (Character String) with field length 4
  • CHARG_D : Batch destination Location
    Its data type is CHAR (Character String) with field length 10
  • WERKS_D : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT_D : Storage location
    Its data type is CHAR (Character String) with field length 4
  • TIME_ST_LOAD_STA : Time at which data was created (date and time)
    Its data type is CHAR (Character String) with field length 14
  • TIME_ST_LOAD_END : Time at which data was created (date and time)
    Its data type is CHAR (Character String) with field length 14
  • TIME_ST_LED_OT : Time at which data was created (date and time)
    Its data type is CHAR (Character String) with field length 14
  • CHARG_D_CREATE : Destination Batch create new flag
    Its data type is CHAR (Character String) with field length 1
  • OIB_BLTIME : Posting time in the document
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHARG_L : Batch load
    Its data type is CHAR (Character String) with field length 10
  • CHARG_L_CREATE : Load Batch create new flag
    Its data type is CHAR (Character String) with field length 1

    • OIJ_EL_TICKET_I related tables

    • OIJ_EL_DOC_FLOW : OIL TSW: Document flow
    • TOIJ_EL_INCOMP : IS-OIL TSW: Activate incompletion for sales and purchasing
    • TOIJ_EL_DOC_SET : Oil TSW: Control document flow and error log
    • OIJ_EL_DEALTYPE : OIL-TSW: Deal types (trading system)
    • TOIJ_EL_LAYT_EV : Default laytime terms for documents
    • TOIJ_EL_LAYT_INF : Default laytime terms for documents
    • TOIJ_EL_LAYTT : Default laytime terms text table
    • OIJ_EL_DOC_EV : Rules for nomination events
    • OIJ_EL_CP_LOC : Charter party contract: load and discharge locations
    • TOIJ_EL_LAYT : Default Laytime Term Code
    • OIJ_EL_DOC_MOT : Oil TSW: TSW Relevance of order item
    • OIJ_EL_DEALTYPET : OIL-TSW: Deal type texts (trading system)
    • OIJ_EL_TCKET_UOM : Universal ticket additional units of measure
    • OIJ_EL_TICKET_H : Universal ticket table
    • TOIJ_EL_MS_GROUP : Oil TSW: Assign function groups to movement scenarios
    • OIJ_EL_ERROR_LOG : OIL-TSW: Error log for ticketing process
    • OIJ_EL_EVT_TYPE : Event date types
    • TOIJ_EL_MVSCEN : TSW: Define Movement scenarios
    • OIJ_EL_LAYT_INF : Laytime terms
    • OIJ_EL_DOC_I_REF : Document item reference to nomination

    OIJ_EL_TICKET_I related transaction codes under SAP package OIJ_EL

    • O4TDG : OIL TSW: Maintain deal groups
    • O4TAPN : Automatically process nominations
    • O4TSW_PD : Production data
    • O5V1 : Number range maintenance: OIJ_EL_TKT

    Related References

    Related Tutorials

    OIJ_EL_TCKET_UOM SAP table for – Universal ticket additional units of measure

    OIJ_EL_TCKET_UOM table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Universal ticket additional...

    OIJ_EL_TICKET_H SAP table for – Universal ticket table

    OIJ_EL_TICKET_H table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Universal ticket table....

    OIJ_EL_TKT_I_O2 SAP table for – Appendix: TSW Ticket item – Additional Quantities

    OIJ_EL_TKT_I_O2 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Appendix: TSW Ticket...

    OIJ_EL_TKT_I_O1 SAP table for – Appendix: TSW Ticket item – Conversion Parameters

    OIJ_EL_TKT_I_O1 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Appendix: TSW Ticket...

    OIJHCT01 SAP table for – OIL-TSW: Ticket Holding Table (Draft version 1) – OBSOLETE

    OIJHCT01 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Ticket Holding...

    OIJBRDDOC SAP table for – Rundown item / document X-ref table for Batch – WILL EXPIR

    OIJBRDDOC table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Rundown item /...

    OIJHUOM SAP table for – OIL-TSW: Ticket additional units of measure

    OIJHUOM table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Ticket additional...

    «
    »