OIK37 SAP table for – IS OIL: Shadow table for SD document processing

Here we would like to draw your attention to OIK37 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). OIK37 is a SAP standard transp table used for storing IS OIL: Shadow table for SD document processing related data in SAP. It comes under the package OIK.

SAP OIK37 table

Table OIK37 technical data

TableOIK37
Data storingIS OIL: Shadow table for SD document processing
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBTYP : SD document category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • COUNTER : Sequence number for doc.item shadow table
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • APPLIC : OIL Application
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : TPI Tank ID
  • SOCNR : SOC: Storage object characteristic segment number
    Its data type is CHAR (Character String) with field length 20
  • SOCAM : SOC access mode
    Its data type is CHAR (Character String) with field length 2
  • OWNOBJ : OIL-BDRP: Owning object ID of BDRP sub-object
    Its data type is CHAR (Character String) with field length 20
  • SUBOBJ : OIL-BDRP: Sequence number of BDRP sub-object
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Additional vehicle related data from TPS
  • SHNUMBER : TD shipment number
    Its data type is CHAR (Character String) with field length 10
  • DISTZ : Distance
    Its data type is QUAN (Quantity field) with field length 13
  • MEDST : Unit of measure for distance
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SHIFT_STDT : Planned date for start of shift
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Additional delivery related data from TPS
  • ETA : Estimated time of arrival
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • EDA : Estimated date of arrival
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Additional order related data from TPS
  • EXT_DOC_NR : TD document number
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : TPI time window data
  • TIME_FRAME : Time frame
    Its data type is CHAR (Character String) with field length 4
  • FROMTIME : Start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TOTIME : Rota end time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TZONE : Time Zone
    Its data type is CHAR (Character String) with field length 6
  • TF_DATE : TPI Time Frame From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INVERT : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • INCLOSE : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • TO_DATE : TPI Time Frame To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : time frame window (2)
  • FROMDATE : TPI From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_WIND : Time frame
    Its data type is CHAR (Character String) with field length 4
  • TODATE : TPI To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8