OIKPEXORD SAP table for – Status of Orders Within Transportation Planning

Here we would like to draw your attention to OIKPEXORD 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). OIKPEXORD is a SAP standard transp table used for storing Status of Orders Within Transportation Planning related data in SAP. It comes under the package OIK.

SAP OIKPEXORD table

Table OIKPEXORD technical data

TableOIKPEXORD
Data storingStatus of Orders Within Transportation Planning
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Sales Document
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSNR : Sales Document Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • TPLST : Transportation planning point
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • STATE : Status of a document in transport planning
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZET : Time last change was made
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DTCON : Transition requirements for status sequence of deliveries
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • LOCCL1 : Location category of generalized location
    Its data type is CHAR (Character String) with field length 2
  • LOCID1 : General location number
    Its data type is CHAR (Character String) with field length 10
  • SUBID1 : Location addition for general location
    Its data type is CHAR (Character String) with field length 35
  • ADRNR1 : Address
    Its data type is CHAR (Character String) with field length 10
  • LOCCL2 : Location category of generalized location
    Its data type is CHAR (Character String) with field length 2
  • LOCID2 : General location number
    Its data type is CHAR (Character String) with field length 10
  • SUBID2 : Location addition for general location
    Its data type is CHAR (Character String) with field length 35
  • ADRNR2 : Address
    Its data type is CHAR (Character String) with field length 10
  • DPTBG : Stage: Planned date for start of shipment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPTBG : Stage: Planned shipment start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TZONBG : Time Zone
    Its data type is CHAR (Character String) with field length 6
  • DPTEN : Stage: Planned date for end of shipment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPTEN : Stage: Planned shipemnt end time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TZONEN : Time Zone
    Its data type is CHAR (Character String) with field length 6