OIK01 SAP table for – IS-OIL/TAS: LID Document Data

Here we would like to draw your attention to OIK01 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). OIK01 is a SAP standard transp table used for storing IS-OIL/TAS: LID Document Data related data in SAP. It comes under the package OIK.

SAP OIK01 table

Table OIK01 technical data

TableOIK01
Data storingIS-OIL/TAS: LID Document Data
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : IS-OIL/TAS: Key LID Document Data
    Its a key field.
  • VBTYP : SD document category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DOCNO : SAP Document Number (TAS)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ITEMNO : SAP document item for TAS
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • LIDNO : LOAD ID
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • LIDADDON : LOAD ID ADDON
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • LIDTYPE : LOAD ID type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • CONTRTYP : Control structure type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : IS-OIL/TAS: explicit LID Document Data
  • FROMDATE : Valid from date (TAS)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FROMTIME : Valid from-time (TAS)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TODATE : Valid to date (TAS)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TOTIME : Valid to Time TAS
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • COPY_FLAG : Copy flag
    Its data type is CHAR (Character String) with field length 1
  • SEND_FLAG : Flag: LID distributed
    Its data type is CHAR (Character String) with field length 1
  • AUTOA_FLAG : Automatic LID assignment enabled
    Its data type is CHAR (Character String) with field length 1
  • CONTRSTR : Control structure
    Its data type is CHAR (Character String) with field length 6
  • CNTRLIND : LID control field indicator
    Its data type is CHAR (Character String) with field length 20
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time, at Which Record Was Added
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of Change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAME : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : TAS Master Data Information Fields
  • LIDDESC : Load ID description
    Its data type is CHAR (Character String) with field length 36
  • LIDDEPOT : LID used at depot
    Its data type is CHAR (Character String) with field length 30
  • LID3COD1 : 3rd party code
    Its data type is CHAR (Character String) with field length 30
  • LIDACTIND : LID activation indicator
    Its data type is CHAR (Character String) with field length 1
  • LIDDELIND : LID deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • LIDBLKIND : LID blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • LIDACTREAS : LID activation reason code
    Its data type is CHAR (Character String) with field length 2
  • LIDDELREAS : LID deletion reason code
    Its data type is CHAR (Character String) with field length 2
  • LIDBLKREAS : LID blocking reason code
    Its data type is CHAR (Character String) with field length 2
  • LID3RDPRTY : 3rd-party delivery number
    Its data type is CHAR (Character String) with field length 30
  • MATNR3RDP : 3rd party material info
    Its data type is CHAR (Character String) with field length 40
  • MATTXT3RDP : 3rd party material text
    Its data type is CHAR (Character String) with field length 64
  • CUST3RDP : 3rd party customer info
    Its data type is CHAR (Character String) with field length 40
  • MATNRTAS : TAS material number
    Its data type is CHAR (Character String) with field length 40
  • ADDITTAS : TAS additive number
    Its data type is CHAR (Character String) with field length 40
  • LIDTAS : Load ID TAS
    Its data type is CHAR (Character String) with field length 30
  • BSTYP : Purchasing Document Category
    Its data type is CHAR (Character String) with field length 1
  • MMDOCNR : SAP MM document number for TAS
    Its data type is CHAR (Character String) with field length 10
  • MMDITMNR : SAP MM document item for TAS
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • TASGRP1 : TAS Group 1
    Its data type is CHAR (Character String) with field length 8
  • TASGRP2 : TAS Group 2
    Its data type is CHAR (Character String) with field length 8
  • FUNCGROUP : LOAD ID function group
    Its data type is CHAR (Character String) with field length 6
  • SDOCART : Subsequent document type
    Its data type is CHAR (Character String) with field length 4
  • TASCFLAG : Check flag for load ID
    Its data type is CHAR (Character String) with field length 1
  • KALSU : Procedure for material determination
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : TAS Master Data – User Fields
  • USERFLD1 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD2 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD3 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD4 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD5 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD6 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD7 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD8 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD9 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD10 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD11 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD12 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD13 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD14 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD15 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD16 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD17 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD18 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD19 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • USERFLD20 : TAS user fields
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Structure for LID control field maintenance
  • SOLDTO : Sold-to party
    Its data type is CHAR (Character String) with field length 10
  • SHIPTO : Ship-to party
    Its data type is CHAR (Character String) with field length 10
  • VSTEL : Shipping Point/Receiving Point
    Its data type is CHAR (Character String) with field length 4
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its data type is CHAR (Character String) with field length 4
  • CHARG : Batch Number
    Its data type is CHAR (Character String) with field length 10
  • MATKL : Material Group
    Its data type is CHAR (Character String) with field length 9
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • OIHANTYP : Excise Duty Handling Type
    Its data type is CHAR (Character String) with field length 2
  • TPLST : Transportation planning point
    Its data type is CHAR (Character String) with field length 4
  • VEHICLE : TD Vehicle Number
    Its data type is CHAR (Character String) with field length 10
  • DRIVERCODE : TD driver number
    Its data type is CHAR (Character String) with field length 10
  • BWTAR : Valuation type
    Its data type is CHAR (Character String) with field length 10
  • SHIFT : TD driver shift
    Its data type is CHAR (Character String) with field length 1
  • TRIP : Trip Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • OIC_MOT : IS-OIL MAP external details mode of transport
    Its data type is CHAR (Character String) with field length 2
  • VSBED : Shipping conditions
    Its data type is CHAR (Character String) with field length 2