OIKLID - TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)
TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) information is stored in SAP table OIKLID.
It is part of development package OIK in software component IS-OIL-DS-TAS. This development package consists of objects that can be grouped under "TAS/TPI Common Objects".
It is part of development package OIK in software component IS-OIL-DS-TAS. This development package consists of objects that can be grouped under "TAS/TPI Common Objects".
Fields for table OIKLID
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| LIDNO | LOAD ID | X | OIK_LID | CHAR | 60 | |
| LIDTYPE | LOAD ID type | OIK_LIDTYP | CHAR | 12 | OIKLT | |
| CONTRTYP | Control structure type | OIK_CNTTYP | CHAR | 2 | ||
| .INCLUDE | OIK_IF | 0 | ||||
| LIDDESC | Load ID description | OIK_LIDTXT | CHAR | 72 | ||
| LIDDEPOT | LID used at depot | OIK_LIDDEP | CHAR | 60 | ||
| LID3COD1 | 3rd party code | OIK_3RDCOD | CHAR | 60 | ||
| LIDACTIND | LID activation indicator | OIK_ACTIND | CHAR | 2 | ||
| LIDDELIND | LID deletion indicator | OIK_DELIND | CHAR | 2 | ||
| LIDBLKIND | LID blocking indicator | OIK_BLKIND | CHAR | 2 | ||
| LIDACTREAS | LID activation reason code | OIK_ACTRCD | CHAR | 4 | * | |
| LIDDELREAS | LID deletion reason code | OIK_DELRCD | CHAR | 4 | * | |
| LIDBLKREAS | LID blocking reason code | OIK_BLKRCD | CHAR | 4 | * | |
| LID3RDPRTY | 3rd-party delivery number | OIK_3RDDEL | CHAR | 60 | ||
| MATNR3RDP | 3rd party material info | OIK_MAT3RD | CHAR | 80 | ||
| MATTXT3RDP | 3rd party material text | OIK_MTXTRD | CHAR | 128 | ||
| CUST3RDP | 3rd party customer info | OIK_CST3RD | CHAR | 80 | ||
| MATNRTAS | TAS material number | OIK_MATTAS | CHAR | 80 | ||
| ADDITTAS | TAS additive number | OIK_ADDTAS | CHAR | 80 | ||
| LIDTAS | Load ID TAS | OIK_LIDTAS | CHAR | 60 | ||
| BSTYP | Purchasing Document Category | EBSTYP | CHAR | 2 | ||
| MMDOCNR | SAP MM document number for TAS | OIK_MDOCNO | CHAR | 20 | EKKO | |
| MMDITMNR | SAP MM document item for TAS | OIK_MITMNO | NUMC | 10 | EKPO | |
| TASGRP1 | TAS Group 1 | OIK_TASGRP | CHAR | 16 | TOIKTGRP | |
| TASGRP2 | TAS Group 2 | OIK_TASGR2 | CHAR | 16 | TOIKTGRP | |
| FUNCGROUP | LOAD ID function group | OIK_LIDGRP | CHAR | 12 | TOIKLIDG | |
| SDOCART | Subsequent document type | OIK_DOCART | CHAR | 8 | * | |
| TASCFLAG | Check flag for load ID | OIK_CFLAG | CHAR | 2 | ||
| KALSU | Procedure for material determination | KALSU | CHAR | 12 | * | |
| .INCLUDE | OIK_AU | 0 | ||||
| CREAAUTHOR | Addresses: Created by | CR_NAM | CHAR | 24 | ||
| CREADATE | Created On | CRDATE | DATS | 16 | ||
| CREATIME | Calendar: Creation or change time | CRTIME | TIMS | 12 | ||
| CHAUTHOR | Addresses: Changed by | CH_NAM | CHAR | 24 | ||
| CHDATE | Changed On | CHDATE | DATS | 16 | ||
| CHTIME | Calendar: Creation or change time | CRTIME | TIMS | 12 | ||
| .INCLUDE | ROIKLIDSCR | 0 | ||||
| SOLDTO | Sold-to Party | KUNAG | CHAR | 20 | KNA1 | |
| SHIPTO | Ship-to Party | KUNWE | CHAR | 20 | KNA1 | |
| VSTEL | Shipping Point / Receiving Point | VSTEL | CHAR | 8 | TVST | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
| CHARG | Batch Number | CHARG_D | CHAR | 20 | * | |
| MATKL | Material Group | MATKL | CHAR | 18 | T023 | |
| MATNR | Material Number | MATNR | CHAR | 80 | ||
| OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 4 | OIH5 | |
| TPLST | Transportation planning point | TPLST | CHAR | 8 | TTDS | |
| VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 20 | OIGV | |
| DRIVERCODE | TD driver number | OIG_DRVNMR | CHAR | 20 | OIGD | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 20 | T149D | |
| SHIFT | TD driver shift | OIG_SHIFT | CHAR | 2 | TOIGH | |
| TRIP | Trip Number | OIG_TRIP | NUMC | 10 | ||
| OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | CHAR | 4 | TVTR | |
| VSBED | Shipping Conditions | VSBED | CHAR | 4 | TVSB | |
| .INCLUDE | OIK_USRFLD | 0 | ||||
| USERFLD1 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD2 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD3 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD4 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD5 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD6 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD7 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD8 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD9 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD10 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD11 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD12 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD13 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD14 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD15 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD16 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD17 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD18 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD19 | TAS user fields | OIK_TASFLD | CHAR | 60 | ||
| USERFLD20 | TAS user fields | OIK_TASFLD | CHAR | 60 |