OIKTTDS SAP table for – OIL-TPI: Transportation planning point additional data

Here we would like to draw your attention to OIKTTDS 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). OIKTTDS is a SAP standard transp table used for storing OIL-TPI: Transportation planning point additional data related data in SAP. It comes under the package OIK.

SAP OIKTTDS table

Table OIKTTDS technical data

TableOIKTTDS
Data storingOIL-TPI: Transportation planning point additional data
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TPLST : Transportation planning point
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : OIL-TPI: Oil view of logical TPS via TPP
  • .INCLUDE : OIL-TPI: Common Configuration Data for External TPS
  • TPSCON : OIL-TPI: External TPS Control Settings (8-Flag String)
    Its data type is CHAR (Character String) with field length 8
  • SHTYP : OIL-TPI: Default Bulk Shipment Type for Inbound Shipments
    Its data type is CHAR (Character String) with field length 4
  • TPSTSO : OIL-TPI: Tank ID Req Mode – Sales Order
    Its data type is CHAR (Character String) with field length 1
  • TPSTSD : OIL-TPI: Tank ID Req Mode – Delivery
    Its data type is CHAR (Character String) with field length 1
  • TPSTDC : OIL-TPI: Tank ID Req Mode – Delivery Confirmation
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TPI: Units of Measure Set for External TPS
  • UOMVOL : OIL-TPI: Volume Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMMAS : OIL-TPI: Weight Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMLEN : OIL-TPI: Length Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMVFR : OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMMFR : OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMTIM : OIL-TPI: Time Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMTMP : OIL-TPI: Temperature Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UOMDIS : OIL-TPI: Distance Unit of Measure Used by External TPS
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DLOCTP : OIL-TPI: Default Receiving Location Type
    Its data type is CHAR (Character String) with field length 2
  • DABTNR : OIL-TPI: Default Contact Person Department
    Its data type is CHAR (Character String) with field length 4
  • DPARFN : OIL-TPI: Default MRN Partner Role/Relation Type
    Its data type is CHAR (Character String) with field length 4
  • IFWAIT : OIL-TPI: Interface Wait Time Between Retries (in Seconds)
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • IFRTRY : OIL-TPI: Number of Transmission Retries Before Termination
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KSCHL_O : Output type for transportation planning systems
    Its data type is CHAR (Character String) with field length 4
  • DR_VEH : OIL-TPI: Deactivate Driver/Vehicle Assignment
    Its data type is CHAR (Character String) with field length 1
  • EXT_NUM : OIL-TPI: Use External Number for Document Creation
    Its data type is CHAR (Character String) with field length 1
  • OIK_EQ_A : OIL-TPI: Check equal assignm. with loading or sched. date
    Its data type is CHAR (Character String) with field length 1
  • MAX_STAT : OIL-TPI: Max. Default Status
    Its data type is CHAR (Character String) with field length 1
  • MANETA : OIL-TPI: Manual Entry of ETA In SPW
    Its data type is CHAR (Character String) with field length 1
  • DEFTRIP : OIL-TPI: Don’t default trip sequence in SPW
    Its data type is CHAR (Character String) with field length 1
  • DISPSUM : OIL-TPI: Don’t show the quantity sum line in SPW
    Its data type is CHAR (Character String) with field length 1