1. Home
  2. Resources
  3. SAP Tables
  4. OIK01D - IS-OIL/TAS: deactivated LID Document Data

SAP Table OIK01D

IS-OIL/TAS: deactivated LID Document Data

OIK01D (IS-OIL/TAS: deactivated LID Document Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIK01D to other SAP tables.

OIK01D table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
DOCNO SAP Document Number (TAS) OIK_DOCNO CHAR 10 0
ITEMNO SAP document item for TAS OIK_ITEMNO NUMC 10 0
LIDNO LOAD ID OIK_LID OIKLIDW CHAR 30 0
LIDADDON LOAD ID ADDON OIK_LIDADD CHAR 20 0
LIDTYPE LOAD ID type OIK_LIDTYP OIKLT CHAR 6 0
CONTRTYP Control structure type OIK_CNTTYP CHAR 1 0
A Pickup
B Shipment - Load Confirmation
D Shipment - Load- / Delivery Confirmation
E Shipment - Delivery Confirmation
F Transfer postings
G Inventory count
C Direct entry to reference table
TSTMP Timestamp OIK_TSTMP NUMC 14 0
FROMDATE Valid from date (TAS) OIK_VDAT DATS 8 0
FROMTIME Valid from-time (TAS) OIK_VTIME TIMS 6 0
TODATE Valid to date (TAS) OIK_TDAT DATS 8 0
TOTIME Valid to Time TAS OIK_TTIME TIMS 6 0
COPY_FLAG Copy flag OIK_COPFLG CHAR 1 0
NULL Not Selected
X Selected
SEND_FLAG Flag: LID distributed OIK_SNDFLG CHAR 1 0
NULL Not Selected
X Selected
AUTOA_FLAG Automatic LID assignment enabled OIK_AUAFLA CHAR 1 0
NULL Not Selected
X Selected
CONTRSTR Control structure OIK_CNTSTR OIKLTC CHAR 6 0
CNTRLIND LID control field indicator OIK_CNTIND CHAR 20 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time, at Which Record Was Added ERZEIT TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of Change AEZEIT TIMS 6 0
AENAME Last changed by AENAME CHAR 12 0
LIDDESC Load ID description OIK_LIDTXT CHAR 36 0
LIDDEPOT LID used at depot OIK_LIDDEP CHAR 30 0
LID3COD1 3rd party code OIK_3RDCOD CHAR 30 0
LIDACTIND LID activation indicator OIK_ACTIND CHAR 1 0
NULL newly created
A activated
D deactivated
R revised for update
LIDDELIND LID deletion indicator OIK_DELIND CHAR 1 0
NULL not marked for deletion
D marked for deletion
LIDBLKIND LID blocking indicator OIK_BLKIND CHAR 1 0
NULL not blocked
B blocked
LIDACTREAS LID activation reason code OIK_ACTRCD OIKLR CHAR 2 0
LIDDELREAS LID deletion reason code OIK_DELRCD OIKLR CHAR 2 0
LIDBLKREAS LID blocking reason code OIK_BLKRCD OIKLR CHAR 2 0
LID3RDPRTY 3rd-party delivery number OIK_3RDDEL CHAR 30 0
MATNR3RDP 3rd party material info OIK_MAT3RD CHAR 40 0
MATTXT3RDP 3rd party material text OIK_MTXTRD CHAR 64 0
CUST3RDP 3rd party customer info OIK_CST3RD CHAR 40 0
MATNRTAS TAS material number OIK_MATTAS CHAR 40 0
ADDITTAS TAS additive number OIK_ADDTAS CHAR 40 0
LIDTAS Load ID TAS OIK_LIDTAS CHAR 30 0
BSTYP Purchasing Document Category EBSTYP CHAR 1 0
A Request for Quotation
F Purchase Order
K Contract
L Scheduling Agreement
MMDOCNR SAP MM document number for TAS OIK_MDOCNO EKKO CHAR 10 0
MMDITMNR SAP MM document item for TAS OIK_MITMNO EKPO NUMC 5 0
TASGRP1 TAS Group 1 OIK_TASGRP TOIKTGRP CHAR 8 0
TASGRP2 TAS Group 2 OIK_TASGR2 TOIKTGRP CHAR 8 0
FUNCGROUP LOAD ID function group OIK_LIDGRP TOIKLIDG CHAR 6 0
SDOCART Subsequent document type OIK_DOCART TVAK CHAR 4 0
TASCFLAG Check flag for load ID OIK_CFLAG CHAR 1 0
NULL no check
E error
I information
W warning
KALSU Procedure for material determination KALSU CHAR 6 0
USERFLD1 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD2 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD3 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD4 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD5 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD6 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD7 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD8 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD9 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD10 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD11 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD12 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD13 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD14 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD15 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD16 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD17 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD18 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD19 TAS user fields OIK_TASFLD CHAR 30 0
USERFLD20 TAS user fields OIK_TASFLD CHAR 30 0
SOLDTO Sold-to party KUNAG KNA1 CHAR 10 0
SHIPTO Ship-to party KUNWE KNA1 CHAR 10 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHB CHAR 10 0
MATKL Material Group MATKL T023 CHAR 9 0
MATNR Material Number MATNR MARA CHAR 18 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
VEHICLE TD Vehicle Number OIG_VHLNMR OIGV CHAR 10 0
DRIVERCODE TD driver number OIG_DRVNMR OIGD CHAR 10 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
SHIFT TD driver shift OIG_SHIFT TOIGH CHAR 1 0
TRIP Trip Number OIG_TRIP NUMC 5 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT TVTR CHAR 2 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 0

OIK01D foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIK01D BWTAR OIK01D BWTAR T149D Global Valuation Types BWTAR
OIK01D BWTAR * T149D Global Valuation Types MANDT
OIK01D CHARG OIK01D MATNR MCHB Batch Stocks MATNR
OIK01D CHARG OIK01D WERKS MCHB Batch Stocks WERKS
OIK01D CHARG OIK01D LGORT MCHB Batch Stocks LGORT
OIK01D CHARG OIK01D CHARG MCHB Batch Stocks CHARG
OIK01D CHARG * MCHB Batch Stocks MANDT
OIK01D CLIENT OIK01D CLIENT T000 Clients MANDT
OIK01D CONTRSTR OIK01D CONTRTYP OIKLTC Load ID Types CONTRTYP
OIK01D CONTRSTR OIK01D CONTRSTR OIKLTC Load ID Types CONTRSTR
OIK01D CONTRSTR OIK01D CLIENT OIKLTC Load ID Types CLIENT
OIK01D CONTRSTR OIK01D LIDTYPE OIKLTC Load ID Types LIDTYPE
OIK01D DRIVERCODE OIK01D DRIVERCODE OIGD TD Driver DRIVERCODE
OIK01D DRIVERCODE * OIGD TD Driver CLIENT
OIK01D FUNCGROUP * TOIKLIDG TD - TAS Function group CLIENT
OIK01D FUNCGROUP OIK01D FUNCGROUP TOIKLIDG TD - TAS Function group LIDGROUP
OIK01D LGORT * T001L Storage Locations MANDT
OIK01D LGORT OIK01D WERKS T001L Storage Locations WERKS
OIK01D LGORT OIK01D LGORT T001L Storage Locations LGORT
OIK01D LIDACTREAS OIK01D CLIENT OIKLR TAS Reason Definition CLIENT
OIK01D LIDACTREAS 'A' OIKLR TAS Reason Definition REATYPE
OIK01D LIDACTREAS OIK01D LIDACTREAS OIKLR TAS Reason Definition REACODE
OIK01D LIDBLKREAS 'B' OIKLR TAS Reason Definition REATYPE
OIK01D LIDBLKREAS OIK01D LIDBLKREAS OIKLR TAS Reason Definition REACODE
OIK01D LIDBLKREAS OIK01D CLIENT OIKLR TAS Reason Definition CLIENT
OIK01D LIDDELREAS OIK01D CLIENT OIKLR TAS Reason Definition CLIENT
OIK01D LIDDELREAS 'D' OIKLR TAS Reason Definition REATYPE
OIK01D LIDDELREAS OIK01D LIDDELREAS OIKLR TAS Reason Definition REACODE
OIK01D LIDNO OIK01D CLIENT OIKLIDW TAS LID Working version (NOTE: keep DB eq to DB OIKLID) CLIENT
OIK01D LIDNO OIK01D LIDNO OIKLIDW TAS LID Working version (NOTE: keep DB eq to DB OIKLID) LIDNO
OIK01D LIDTYPE OIK01D CLIENT OIKLT TAS Load ID Types CLIENT
OIK01D LIDTYPE OIK01D LIDTYPE OIKLT TAS Load ID Types LIDTYPE
OIK01D LIDTYPE OIK01D CONTRTYP OIKLT TAS Load ID Types CONTRTYP
OIK01D MATKL * T023 Material Groups MANDT
OIK01D MATKL OIK01D MATKL T023 Material Groups MATKL
OIK01D MATNR * MARA General Material Data MANDT
OIK01D MATNR OIK01D MATNR MARA General Material Data MATNR
OIK01D MMDITMNR * EKPO Purchasing Document Item MANDT
OIK01D MMDITMNR OIK01D MMDOCNR EKPO Purchasing Document Item EBELN
OIK01D MMDITMNR OIK01D MMDITMNR EKPO Purchasing Document Item EBELP
OIK01D MMDOCNR OIK01D MMDOCNR EKKO Purchasing Document Header EBELN
OIK01D MMDOCNR * EKKO Purchasing Document Header MANDT
OIK01D OIC_MOT * TVTR Routes: Modes of Transport MANDT
OIK01D OIC_MOT OIK01D OIC_MOT TVTR Routes: Modes of Transport VKTRA
OIK01D OIHANTYP * OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
OIK01D OIHANTYP OIK01D OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
OIK01D SDOCART OIK01D CLIENT TVAK Sales Document Types MANDT
OIK01D SDOCART OIK01D SDOCART TVAK Sales Document Types AUART
OIK01D SHIFT * TOIGH TD Shift Table CLIENT
OIK01D SHIFT OIK01D SHIFT TOIGH TD Shift Table SHIFT
OIK01D SHIPTO OIK01D SHIPTO KNA1 General Data in Customer Master KUNNR
OIK01D SHIPTO * KNA1 General Data in Customer Master MANDT
OIK01D SOLDTO * KNA1 General Data in Customer Master MANDT
OIK01D SOLDTO OIK01D SOLDTO KNA1 General Data in Customer Master KUNNR
OIK01D TASGRP1 OIK01D CLIENT TOIKTGRP TAS-Group Definition CLIENT
OIK01D TASGRP1 OIK01D TASGRP1 TOIKTGRP TAS-Group Definition TASGROUP
OIK01D TASGRP2 OIK01D CLIENT TOIKTGRP TAS-Group Definition CLIENT
OIK01D TASGRP2 OIK01D TASGRP2 TOIKTGRP TAS-Group Definition TASGROUP
OIK01D TPLST * TTDS Organizational Unit: Transportation Scheduling Point MANDT
OIK01D TPLST OIK01D TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
OIK01D VEHICLE * OIGV TD Vehicle Header CLIENT
OIK01D VEHICLE OIK01D VEHICLE OIGV TD Vehicle Header VEHICLE
OIK01D VSBED * TVSB Shipping Conditions MANDT
OIK01D VSBED OIK01D VSBED TVSB Shipping Conditions VSBED
OIK01D VSTEL OIK01D VSTEL TVST Organizational Unit: Shipping Points VSTEL
OIK01D VSTEL * TVST Organizational Unit: Shipping Points MANDT
OIK01D WERKS * T001W Plants/Branches MANDT
OIK01D WERKS OIK01D WERKS T001W Plants/Branches WERKS