OIK29 SAP table for – IS-OIL/TPI: Status of processed inbound IDoc OILSHI01

Here we would like to draw your attention to OIK29 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). OIK29 is a SAP standard transp table used for storing IS-OIL/TPI: Status of processed inbound IDoc OILSHI01 related data in SAP. It comes under the package OIK.

SAP OIK29 table

Table OIK29 technical data

TableOIK29
Data storingIS-OIL/TPI: Status of processed inbound IDoc OILSHI01
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOCNUM : IDoc number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 16
  • SEGNAM : Name of SAP segment
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • EXT_DOCNR : Sales Document
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • EXT_SHNUM : Reference Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • EXT_POSNR : Sales Document Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SEGNUM : Number of SAP segment
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • SHNUM : TD shipment number
    Its data type is CHAR (Character String) with field length 10
  • KDAUF : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • LIEFN : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • POSNR : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CD_STATUS : Segment status
    Its data type is CHAR (Character String) with field length 1
  • MSGID : Message Class
    Its data type is CHAR (Character String) with field length 20
  • MSGTY : Message Type
    Its data type is CHAR (Character String) with field length 1
  • MSGNO : Message Number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MSGV1 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV2 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV3 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV4 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZET : Entry time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6