1. SAP Tutorial
  2. Oil & Gas

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

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

SAP OIK01D table

Table OIK01D technical data

TableOIK01D
Data storingIS-OIL/TAS: deactivated 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 OIK01D 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 OIK01D 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
  • TSTMP : Timestamp
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • .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

    • OIK01D related tables

    • TOIKLIDF : TD – TAS Functions
    • TOIK_RFC_ID : Oil: Mapping of RFC destinations to Oil Web App. Scenarios
    • OIKLID : TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)
    • TOIKDTD : Tabel for defaulting to dates
    • OIKSD : TAS/TPI: Shipment scheduling
    • OIKLTCGT : TD – LID Type Control Structure Texts
    • OIKPEXLOC : OIL: Status of gen. Location in ext. Transport Planning Sy
    • OIKCFW : TAS – Control Field Data
    • OIKLIDR : TD – TAS Reference Table
    • OIKTT : TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV)
    • TOIKTGRPT : TAS Group Text Defintion
    • TOIKDEFTOL : OIL-TPI: Storage of default tolerances
    • OIKLTCG : TD – LID Type Control Structure
    • OIKTPIDC : TPI Relevance Fields and Ranking (by VBTYP)
    • OIKLTC : Load ID Types
    • TOIKOWCT : Time frame text
    • TOIKCCAPGRT : OIL-TPI: Customer Capacity Group Text
    • TOIKLIDFT : TD – TAS Functions Texts
    • OIKTPIRD : TPI: SD doc. – obsolete – but needed for XPRA ROIKXTPIREL
    • OIK29C : IS-OIL/TPI: Status of processed functions – messages

    OIK01D related transaction codes under SAP package OIK

    • O4PS : Load data shipment
    • O4PQ : Distribute orders
    • O4P8 : Revise LIDs
    • O4PK : Load data pickup
    • S_SO5_65000276 : IMG activity: SIMG_TD_TPI_0008
    • O4P1 : Create LID Master Data
    • S_SO6_65000883 : LID assignment
    • S_SO5_65000274 : IMG activity: SIMG_TD_TPI_0003
    • S_SO6_65000882 : Post the goods issue for deliveries
    • O4PV : Driver Vehicle Assignment
    • O4PR : Selection without LID Type
    • S_SO5_65000271 : IMG activity: SIMG_TD_TPI_0006
    • O4PMN : TPI History Information
    • S_SO6_65000887 : Send driver idocs from change pointe
    • S_SO5_65000273 : IMG activity: SIMG_TD_TPI_0004
    • S_SO5_65000277 : IMG activity: SIMG_TD_TPI_0009
    • S_SO5_65000278 : IMG activity: SIMG_TD_TPI_0001
    • O4PI : Show LID-Details
    • O4P4 : Delete Load ID
    • O4PO : Change order and plant

    Related References

    Related Tutorials

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

    OIK01 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of IS-OIL/TAS: LID Document...

    TOIKTRVS SAP table for – LID TAS relevance determination Shipment

    TOIKTRVS table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of LID TAS relevance...

    OIKCGFP SAP table for – TAS LID-Control structure definition fields

    OIKCGFP table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of TAS LID-Control structure...

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

    OIKLIDW table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of TAS LID Working...

    TOIKTRV SAP table for – LID TAS relevance determination

    TOIKTRV table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of LID TAS relevance...

    OIK02B SAP table for – IS-OIL/TAS: Status of processed functions – messages

    OIK02B table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of IS-OIL/TAS: Status of...

    OIK04 SAP table for – IS-OIL/TAS: Idoc data segment

    OIK04 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of IS-OIL/TAS: Idoc data...

    «
    »