1. Home
  2. Resources
  3. SAP Tables
  4. OIKLIDW - TAS LID Working version (NOTE: keep DB eq to DB OIKLID)

SAP Table OIKLIDW

TAS LID Working version (NOTE: keep DB eq to DB OIKLID)

OIKLIDW (TAS LID Working version (NOTE: keep DB eq to DB OIKLID)) 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 OIKLIDW to other SAP tables.

OIKLIDW table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
LIDNO LOAD ID OIK_LID CHAR 30 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
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 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
CREAAUTHOR Addresses: Created by CR_NAM CHAR 12 0
CREADATE Created on CRDATE DATS 8 0
CREATIME Calendar: Creation or change time CRTIME TIMS 6 0
CHAUTHOR Addresses: Changed by CH_NAM CHAR 12 0
CHDATE Changed On CHDATE DATS 8 0
CHTIME Calendar: Creation or change time CRTIME TIMS 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
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

OIKLIDW foreign key relationships

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