OIJTE SAP table for – TSW Ticket Events

Here we would like to draw your attention to OIJTE 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). OIJTE is a SAP standard transp table used for storing TSW Ticket Events related data in SAP. It comes under the package OIJ.

SAP OIJTE table

Table OIJTE technical data

TableOIJTE
Data storingTSW Ticket Events
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJTE 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 OIJTE table.

  • CLIENT : 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
  • EVENT_NR : TD – event number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • TYPE : TD – event type
    Its data type is CHAR (Character String) with field length 4
  • DOC_TYPE : TD – event document type
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW: Ticket events
  • EV_SEQ : TD – event sequence number
    Its data type is CHAR (Character String) with field length 4
  • DOC_NUMBER : TD Assigned document number
    Its data type is CHAR (Character String) with field length 10
  • SHITEM : Shipment item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • STATUS : TD Event status
    Its data type is CHAR (Character String) with field length 1
  • ACTUALSTARTFROM : 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
  • ACTUALSTARTTO : 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
  • ACTUALENDFROM : 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
  • ACTUALENDTO : 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
  • CRE_NAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • CREATION : 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
  • CHA_NAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • MODIFICATION : 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
  • VEH_NR : Vehicle Sequence Number in Shipment
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TSRFO : Stage of transport sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1