SAP Table ROIKLIDW

TAS LID Communication structure

ROIKLIDW (TAS LID Communication structure) 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 ROIKLIDW to other SAP tables.

ROIKLIDW 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
CONTRSTR Control structure OIK_CNTSTR OIKLTC CHAR 6 0
LIDACTREAT TAS Load ID reason code text OIK_REATXT CHAR 36 0
LIDDELREAT TAS Load ID reason code text OIK_REATXT CHAR 36 0
LIDBLKREAT TAS Load ID reason code text OIK_REATXT CHAR 36 0
LIDACTINDT LID indicator text OIK_INDTXT CHAR 36 0
LIDDELINDT LID indicator text OIK_INDTXT CHAR 36 0
LIDBLKINDT LID indicator text OIK_INDTXT CHAR 36 0

ROIKLIDW foreign key relationships

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