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

Here we would like to draw your attention to OIK29D 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). OIK29D 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 OIK29D table

Table OIK29D technical data

TableOIK29D
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 OIK29D 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 OIK29D 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
  • SHITEM : Shipment item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • 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