OIKLIDR SAP table for – TD – TAS Reference Table

Here we would like to draw your attention to OIKLIDR 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). OIKLIDR is a SAP standard transp table used for storing TD – TAS Reference Table related data in SAP. It comes under the package OIK.

SAP OIKLIDR table

Table OIKLIDR technical data

TableOIKLIDR
Data storingTD – TAS Reference Table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TAS
SAP PackageOIK
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIKLIDR 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 OIKLIDR 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
  • 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
  • FROMDATE : Timestamp valid from
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • TODATE : Timestamp valid from
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • 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
  • DOCTYPE : SAP Document Type (TAS)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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 : 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
  • 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