1. SAP Tutorial
  2. Oil & Gas

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

    • OIK01 related tables

    • TOIKOWCT : Time frame text
    • TOIKGRTYPE : OIL-TPI: Allowed Group Types
    • OIK37 : IS OIL: Shadow table for SD document processing
    • OIKTTDSTX : OIL-TPI: Text IDs per TPP and interface type
    • TOIKCCAPGR : OIL-TPI: Customer Capacity Group
    • TOIKDEFTOL : OIL-TPI: Storage of default tolerances
    • TOIKUSF : TAS User Field Definition
    • OIKTPIRD : TPI: SD doc. – obsolete – but needed for XPRA ROIKXTPIREL
    • TOIKLIDG : TD – TAS Function group
    • OIKLR : TAS Reason Definition
    • TOIKOWC : Time windows
    • OIKVD : TPI: Vehicle/Driver assignment
    • OIKLT : TAS Load ID Types
    • OIK29 : IS-OIL/TPI: Status of processed inbound IDoc OILSHI01
    • TOIKLRSS : Customizing table: Items for Select LID’s to release
    • OIKCFW : TAS – Control Field Data
    • OIKTPIPD : TPI Rel.Fields – obsolete – but needed for XPRA ROIKXTPIREL
    • OIKSD : TAS/TPI: Shipment scheduling
    • OIK29A : IS-OIL/TPI: Status of processed functions
    • OIKEDPP1 : OIL-TPI: Configuration data for EDP logical system

    OIK01 related transaction codes under SAP package OIK

    • S_SO5_65000274 : IMG activity: SIMG_TD_TPI_0003
    • O4P8 : Revise LIDs
    • O5PL : TPI Customized Message Handling
    • S_SO6_65000884 : Select rack meters from change point
    • O4P9 : Transport Planning System Interface
    • S_SO6_65000882 : Post the goods issue for deliveries
    • O4PMN : TPI History Information
    • O4P0 : Terminal Automation Interface
    • O4PS : Load data shipment
    • O4PW : IDOC via Changepointer for OILDVA
    • O4PP : Shipment planning
    • O4PO : Change order and plant
    • O4P5 : Display released LID’s
    • O4PH : Display Load information
    • O4P4 : Delete Load ID
    • O4PX : Shipment Planning Workbench
    • O4PN : Skip shipment inbound process
    • O4PI : Show LID-Details
    • S_SO5_65000273 : IMG activity: SIMG_TD_TPI_0004
    • O4P7 : Release LIDs

    Related References

    Related Tutorials

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

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

    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...

    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...

    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...

    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...

    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...

    «
    »