OIJNE SAP table for – Nomination Events

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

SAP OIJNE table

Table OIJNE technical data

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

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • NOMTK : Nomination (technical) Key
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • NOMIT : Nomination Key Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • EVENT_NR : TD – event number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • NOMNR : Nomination number
    Its data type is CHAR (Character String) with field length 20
  • 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
  • UPDFLAG : Transaction type
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW: Nomination 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
  • PSTDTF : TD Event: Planned Start Date – From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PSTTMF : TD Event: Planned Start Time – From
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PSTDTT : TD Event: Planned Start Date – To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PSTTMT : TD Event: Planned Start Time – To
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PEDDTF : TD Event: Planned End Date – From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEDTMF : TD Event: Planned End Time – From
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PEDDTT : TD Event: Planned End Date – To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEDTMT : TD – event planned – ‘end time to’
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CRE_NAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • CRE_DATE : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRE_TIME : Entry time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHA_NAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • CHA_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHA_TIME : Time last change was made
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ASTDTF : TD – Actual Start Date of Event (From)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASTTMF : TD – Actual Start Time of Event (From)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ASTDTT : TD – Actual Start Date of Event (To)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASTTMT : TD – Actual Start Time of Event (To)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AEDDTF : TD Event actual end date from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEDTMF : TD Event actual end time from
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AEDDTT : TD Event actual end date to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEDTMT : TD Event actual end time to
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DEFAULTED : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • 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
  • DRIVER : TD driver number
    Its data type is CHAR (Character String) with field length 10
  • CPARID : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • ADD_QTY : Additional Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ADQ_UOM : UoM of Additional Quantity
    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
  • .INCLUDE : Laytime-related event information
  • LT_EVOPPOINT : Laytime start, end, influencing event flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : nomination events table berth scheduling fields
  • BERNR : Berth Number
    Its data type is CHAR (Character String) with field length 10
  • BERID : Berth identifier
    Its data type is CHAR (Character String) with field length 20