OIKLIDW SAP table for – TAS LID Working version (NOTE: keep DB eq to DB OIKLID)

Here we would like to draw your attention to OIKLIDW 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). OIKLIDW is a SAP standard transp table used for storing TAS LID Working version (NOTE: keep DB eq to DB OIKLID) related data in SAP. It comes under the package OIK.

SAP OIKLIDW table

Table OIKLIDW technical data

TableOIKLIDW
Data storingTAS LID Working version (NOTE: keep DB eq to DB OIKLID)
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LIDNO : LOAD ID
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • LIDTYPE : LOAD ID type
    Its data type is CHAR (Character String) with field length 6
  • CONTRTYP : Control structure type
    Its data type is CHAR (Character String) with field length 1
  • .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 : User Audit
  • CREAAUTHOR : Addresses: Created by
    Its data type is CHAR (Character String) with field length 12
  • CREADATE : Created on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATIME : Calendar: Creation or change time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHAUTHOR : Addresses: Changed by
    Its data type is CHAR (Character String) with field length 12
  • CHDATE : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHTIME : Calendar: Creation or change time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .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
  • .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