OIKVD SAP table for – TPI: Vehicle/Driver assignment

Here we would like to draw your attention to OIKVD 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). OIKVD is a SAP standard transp table used for storing TPI: Vehicle/Driver assignment related data in SAP. It comes under the package OIK.

SAP OIKVD table

Table OIKVD technical data

TableOIKVD
Data storingTPI: Vehicle/Driver assignment
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOADDATE : Planned date for start of shipment
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHIFT : TD driver shift
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DRIVERCODE : TD driver number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VEHICLE : TD Vehicle Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • TPLST : Transportation planning point
    Its data type is CHAR (Character String) with field length 4
  • SH_LENGTH : Overall Shift length
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • START_TIME : Start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • WORK_TIME : Maximum work time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • SHIFT_DATE : Shift date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRIVERHOUR : Maximum drive time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6