OIKTT SAP table for – TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV)

Here we would like to draw your attention to OIKTT 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). OIKTT is a SAP standard transp table used for storing TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV) related data in SAP. It comes under the package OIK.

SAP OIKTT table

Table OIKTT technical data

TableOIKTT
Data storingTPI:Trip planning times-for customer use (Enhancem.OIKSHPSV)
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SHNUMBER : TD shipment number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DLNUMBER : TD document number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LOADDATE : Planned date for start of shipment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHIFT : TD driver shift
    Its data type is CHAR (Character String) with field length 1
  • SHIPTO : Ship-to party
    Its data type is CHAR (Character String) with field length 10
  • NDRIVETIME : TPI: Non-driving time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DRIVETIME : TPI: Driving time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DISTANCE : Distance
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • DISTUOM : Unit of measure for distance
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ETA : Estimated Time of Arrival at return plant
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • EDA : Estimated date of arrival at return plant
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8