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 |