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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
LIDDELIND | LID deletion indicator | OIK_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
LIDBLKIND | LID blocking indicator | OIK_BLKIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |