1. SAP Tutorial
  2. Oil & Gas

OIJ_EL_TICKET_H SAP table for – Universal ticket table

Here we would like to draw your attention to OIJ_EL_TICKET_H 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_H is a SAP standard transp table used for storing Universal ticket table related data in SAP. It comes under the package OIJ_EL.

SAP OIJ_EL_TICKET_H table

Table OIJ_EL_TICKET_H technical data

TableOIJ_EL_TICKET_H
Data storingUniversal ticket 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_H 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_H 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_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
  • TICKET_TYPE : OIL-TSW: Ticket type
    Its data type is CHAR (Character String) with field length 3
  • TICKETNR : OIL-TSW: External ticket number
    Its data type is CHAR (Character String) with field length 20
  • TKTSUBRC : OIL-TSW: Ticket process return code
    Its data type is CHAR (Character String) with field length 2
  • TPLST : Transportation planning point
    Its data type is CHAR (Character String) with field length 4
  • TSYST : Transport system
    Its data type is CHAR (Character String) with field length 10
  • IDOC_NUM : IDoc number
    Its data type is NUMC (Character String with Digits Only) 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
  • CARRIER : Transport system Carrier
    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
  • INSPECTOR : Inspector
    Its data type is CHAR (Character String) with field length 10
  • SHIPPER : Shipper
    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
  • TRADER : Location Partner
    Its data type is CHAR (Character String) with field length 10

    • OIJ_EL_TICKET_H related tables

    • TOIJ_EL_MVSCENT : TSW: Movement scenario descriptions
    • TOIJ_EL_SITYPEST : TSW: Description of SITYPES
    • OIJ_EL_DEALGROUP : OIL-TSW: Deal groups (trading system)
    • OIJ_EL_DOC_EV : Rules for nomination events
    • OIJ_EL_DOC_MOT : Oil TSW: TSW Relevance of order item
    • OIJ_EL_TICKET_H : Universal ticket table
    • TOIJ_EL_LAYT : Default Laytime Term Code
    • OIJ_EL_DEALGRTX : OIL-TSW: Deal group texts (trading system)
    • TOIJ_EL_PR_RT : Prorate Calculation Routine Type
    • TOIJ_EL_EV_SD : Default events for sales documents
    • OIJ_EL_EVT_TYPE : Event date types
    • OIJ_EL_LAYT_EV : Laytime start and end events
    • OIJ_EL_TICKET_I : Universal ticket item table
    • OIJ_EL_DOC_M_MOT : OIL TSW: TSW Details / Multiple MoT’s
    • TOIJ_EL_LAYT_INF : Default laytime terms for documents
    • OIJ_EL_LAYT_INF : Laytime terms
    • OIJ_EL_CP_LOC : Charter party contract: load and discharge locations
    • OIJ_EL_DEALTYPET : OIL-TSW: Deal type texts (trading system)
    • TOIJ_EL_LAYTT : Default laytime terms text table
    • OIJ_EL_DOC_FLOW : OIL TSW: Document flow

    OIJ_EL_TICKET_H related transaction codes under SAP package OIJ_EL

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

    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_I SAP table for – Universal ticket item table

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

    OIJ_EL_EVT_TYPE SAP table for – Event date types

    OIJ_EL_EVT_TYPE table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Event date types....

    OIJHTNRT SAP table for – OIL-TSW: Ticket Number Rules Texts

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

    O4TDG SAP tcode for – OIL TSW: Maintain deal groups

    O4TDG tcode in SAP IS-OIL (Downstream in IS-OIL) module. This transaction code is used for OIL TSW: Maintain deal groups....

    OIJ_EL_DEALTYPE SAP table for – OIL-TSW: Deal types (trading system)

    OIJ_EL_DEALTYPE table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Deal types...

    OIJ_EL_EVT_TYPET SAP table for – Event date types – texts

    OIJ_EL_EVT_TYPET table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Event date types...

    «
    »