OIJEV SAP table for – TD-Vehicle ~ Berth Master Data Events

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

SAP OIJEV table

Table OIJEV technical data

TableOIJEV
Data storingTD-Vehicle ~ Berth Master Data Events
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APP_AREA : Application area
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OBJECT_ID : Object ID
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • EVENT_NR : Master Data Event number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • TYPE : Master Data Event Type
    Its data type is CHAR (Character String) with field length 4
  • DRIVERCODE : 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
  • RPART : OIL-TSW: Role partner type
    Its data type is CHAR (Character String) with field length 2
  • LOC_ID : Location ID
    Its data type is CHAR (Character String) with field length 10
  • DOC_TYPE : TD – event document type
    Its data type is CHAR (Character String) with field length 1
  • DOC_NUMBER : TD Assigned document number
    Its data type is CHAR (Character String) with field length 10
  • UPDFLAG : Transaction type
    Its data type is CHAR (Character String) with field length 1
  • EV_SEQ : TD – event sequence number
    Its data type is CHAR (Character String) with field length 4
  • STATUS : Master Data 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_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
  • CRE_NAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • 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
  • LONGTEXT : TD – event long text indicator
    Its data type is CHAR (Character String) with field length 1