1. Home
  2. Resources
  3. SAP Tables
  4. OIKLIDR - TD - TAS Reference Table

SAP Table OIKLIDR

TD - TAS Reference Table

OIKLIDR (TD - TAS Reference Table) 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 OIKLIDR to other SAP tables.

OIKLIDR table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
LIDNO LOAD ID OIK_LID CHAR 30 0
LIDADDON LOAD ID ADDON OIK_LIDADD CHAR 20 0
LIDTYPE LOAD ID type OIK_LIDTYP OIKLT CHAR 6 0
FROMDATE Timestamp valid from OIK_VDATTS NUMC 14 0
TODATE Timestamp valid from OIK_TDATTS NUMC 14 0
DOCNO SAP Document Number (TAS) OIK_DOCNO CHAR 10 0
ITEMNO SAP document item for TAS OIK_ITEMNO NUMC 10 0
DOCTYPE SAP Document Type (TAS) OIK_DOCTYP 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
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
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 CHAR 2 0
LIDDELREAS LID deletion reason code OIK_DELRCD CHAR 2 0
LIDBLKREAS LID blocking reason code OIK_BLKRCD 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 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
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
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

OIKLIDR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIKLIDR BWTAR * T149D Global Valuation Types MANDT
OIKLIDR BWTAR OIKLIDR BWTAR T149D Global Valuation Types BWTAR
OIKLIDR CHARG OIKLIDR CHARG MCHB Batch Stocks CHARG
OIKLIDR CHARG * MCHB Batch Stocks MANDT
OIKLIDR CHARG OIKLIDR MATNR MCHB Batch Stocks MATNR
OIKLIDR CHARG OIKLIDR WERKS MCHB Batch Stocks WERKS
OIKLIDR CHARG OIKLIDR LGORT MCHB Batch Stocks LGORT
OIKLIDR CLIENT OIKLIDR CLIENT T000 Clients MANDT
OIKLIDR DRIVERCODE * OIGD TD Driver CLIENT
OIKLIDR DRIVERCODE OIKLIDR DRIVERCODE OIGD TD Driver DRIVERCODE
OIKLIDR FUNCGROUP * TOIKLIDG TD - TAS Function group CLIENT
OIKLIDR FUNCGROUP OIKLIDR FUNCGROUP TOIKLIDG TD - TAS Function group LIDGROUP
OIKLIDR LGORT * T001L Storage Locations MANDT
OIKLIDR LGORT OIKLIDR WERKS T001L Storage Locations WERKS
OIKLIDR LGORT OIKLIDR LGORT T001L Storage Locations LGORT
OIKLIDR LIDTYPE OIKLIDR CLIENT OIKLT TAS Load ID Types CLIENT
OIKLIDR LIDTYPE OIKLIDR LIDTYPE OIKLT TAS Load ID Types LIDTYPE
OIKLIDR LIDTYPE OIKLIDR CONTRTYP OIKLT TAS Load ID Types CONTRTYP
OIKLIDR MATKL * T023 Material Groups MANDT
OIKLIDR MATKL OIKLIDR MATKL T023 Material Groups MATKL
OIKLIDR MATNR OIKLIDR MATNR MARA General Material Data MATNR
OIKLIDR MATNR * MARA General Material Data MANDT
OIKLIDR MMDITMNR OIKLIDR MMDITMNR EKPO Purchasing Document Item EBELP
OIKLIDR MMDITMNR OIKLIDR CLIENT EKPO Purchasing Document Item MANDT
OIKLIDR MMDITMNR OIKLIDR MMDOCNR EKPO Purchasing Document Item EBELN
OIKLIDR MMDOCNR OIKLIDR CLIENT EKKO Purchasing Document Header MANDT
OIKLIDR MMDOCNR OIKLIDR MMDOCNR EKKO Purchasing Document Header EBELN
OIKLIDR OIC_MOT * TVTR Routes: Modes of Transport MANDT
OIKLIDR OIC_MOT OIKLIDR OIC_MOT TVTR Routes: Modes of Transport VKTRA
OIKLIDR OIHANTYP * OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
OIKLIDR OIHANTYP OIKLIDR OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
OIKLIDR SHIFT OIKLIDR SHIFT TOIGH TD Shift Table SHIFT
OIKLIDR SHIFT * TOIGH TD Shift Table CLIENT
OIKLIDR SHIPTO * KNA1 General Data in Customer Master MANDT
OIKLIDR SHIPTO OIKLIDR SHIPTO KNA1 General Data in Customer Master KUNNR
OIKLIDR SOLDTO * KNA1 General Data in Customer Master MANDT
OIKLIDR SOLDTO OIKLIDR SOLDTO KNA1 General Data in Customer Master KUNNR
OIKLIDR TASGRP1 OIKLIDR CLIENT TOIKTGRP TAS-Group Definition CLIENT
OIKLIDR TASGRP1 OIKLIDR TASGRP1 TOIKTGRP TAS-Group Definition TASGROUP
OIKLIDR TASGRP2 OIKLIDR TASGRP2 TOIKTGRP TAS-Group Definition TASGROUP
OIKLIDR TASGRP2 OIKLIDR CLIENT TOIKTGRP TAS-Group Definition CLIENT
OIKLIDR TPLST * TTDS Organizational Unit: Transportation Scheduling Point MANDT
OIKLIDR TPLST OIKLIDR TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
OIKLIDR VEHICLE * OIGV TD Vehicle Header CLIENT
OIKLIDR VEHICLE OIKLIDR VEHICLE OIGV TD Vehicle Header VEHICLE
OIKLIDR VSBED * TVSB Shipping Conditions MANDT
OIKLIDR VSBED OIKLIDR VSBED TVSB Shipping Conditions VSBED
OIKLIDR VSTEL * TVST Organizational Unit: Shipping Points MANDT
OIKLIDR VSTEL OIKLIDR VSTEL TVST Organizational Unit: Shipping Points VSTEL
OIKLIDR WERKS * T001W Plants/Branches MANDT
OIKLIDR WERKS OIKLIDR WERKS T001W Plants/Branches WERKS