SAP ABAP Table OIKLIDW (TAS LID Working version (NOTE: keep DB eq to DB OIKLID))
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK (Package) TAS/TPI Common Objects
⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
⤷ OIK (Package) TAS/TPI Common Objects
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIKLIDW | Table Relationship Diagram |
Short Description | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LIDNO | OIK_LID | OIK_LID | CHAR | 30 | 0 | LOAD ID | ||
3 | LIDTYPE | OIK_LIDTYP | OIK_LIDTYP | CHAR | 6 | 0 | LOAD ID type | OIKLT | |
4 | CONTRTYP | OIK_CNTTYP | OIK_CNTTYP | CHAR | 1 | 0 | Control structure type | ||
5 | .INCLUDE | 0 | 0 | TAS Master Data Information Fields | |||||
6 | LIDDESC | OIK_LIDTXT | TEXT36 | CHAR | 36 | 0 | Load ID description | ||
7 | LIDDEPOT | OIK_LIDDEP | CHAR30 | CHAR | 30 | 0 | LID used at depot | ||
8 | LID3COD1 | OIK_3RDCOD | TEXT30 | CHAR | 30 | 0 | 3rd party code | ||
9 | LIDACTIND | OIK_ACTIND | OIK_ACTIND | CHAR | 1 | 0 | LID activation indicator | ||
10 | LIDDELIND | OIK_DELIND | OIK_DELIND | CHAR | 1 | 0 | LID deletion indicator | ||
11 | LIDBLKIND | OIK_BLKIND | OIK_BLKIND | CHAR | 1 | 0 | LID blocking indicator | ||
12 | LIDACTREAS | OIK_ACTRCD | OIK_REACOD | CHAR | 2 | 0 | LID activation reason code | OIKLR | |
13 | LIDDELREAS | OIK_DELRCD | OIK_REACOD | CHAR | 2 | 0 | LID deletion reason code | OIKLR | |
14 | LIDBLKREAS | OIK_BLKRCD | OIK_REACOD | CHAR | 2 | 0 | LID blocking reason code | OIKLR | |
15 | LID3RDPRTY | OIK_3RDDEL | CHAR30 | CHAR | 30 | 0 | 3rd-party delivery number | ||
16 | MATNR3RDP | OIK_MAT3RD | TEXT40 | CHAR | 40 | 0 | 3rd party material info | ||
17 | MATTXT3RDP | OIK_MTXTRD | TEXT64 | CHAR | 64 | 0 | 3rd party material text | ||
18 | CUST3RDP | OIK_CST3RD | TEXT40 | CHAR | 40 | 0 | 3rd party customer info | ||
19 | MATNRTAS | OIK_MATTAS | TEXT40 | CHAR | 40 | 0 | TAS material number | ||
20 | ADDITTAS | OIK_ADDTAS | TEXT40 | CHAR | 40 | 0 | TAS additive number | ||
21 | LIDTAS | OIK_LIDTAS | TEXT30 | CHAR | 30 | 0 | Load ID TAS | ||
22 | BSTYP | EBSTYP | EBSTYP | CHAR | 1 | 0 | Purchasing Document Category | ||
23 | MMDOCNR | OIK_MDOCNO | EBELN | CHAR | 10 | 0 | SAP MM document number for TAS | EKKO | |
24 | MMDITMNR | OIK_MITMNO | EBELP | NUMC | 5 | 0 | SAP MM document item for TAS | EKPO | |
25 | TASGRP1 | OIK_TASGRP | OIK_TASGRP | CHAR | 8 | 0 | TAS Group 1 | TOIKTGRP | |
26 | TASGRP2 | OIK_TASGR2 | OIK_TASGRP | CHAR | 8 | 0 | TAS Group 2 | TOIKTGRP | |
27 | FUNCGROUP | OIK_LIDGRP | OIK_LIDGRP | CHAR | 6 | 0 | LOAD ID function group | TOIKLIDG | |
28 | SDOCART | OIK_DOCART | AUART | CHAR | 4 | 0 | Subsequent document type | * | |
29 | TASCFLAG | OIK_CFLAG | OIK_CFLAG | CHAR | 1 | 0 | Check flag for load ID | ||
30 | KALSU | KALSU | KALSM | CHAR | 6 | 0 | Procedure for material determination | * | |
31 | .INCLUDE | 0 | 0 | User Audit | |||||
32 | CREAAUTHOR | CR_NAM | USERNAME | CHAR | 12 | 0 | Addresses: Created by | ||
33 | CREADATE | CRDATE | DATUM | DATS | 8 | 0 | Created on | ||
34 | CREATIME | CRTIME | UZEIT | TIMS | 6 | 0 | Calendar: Creation or change time | ||
35 | CHAUTHOR | CH_NAM | USERNAME | CHAR | 12 | 0 | Addresses: Changed by | ||
36 | CHDATE | CHDATE | DATUM | DATS | 8 | 0 | Changed On | ||
37 | CHTIME | CRTIME | UZEIT | TIMS | 6 | 0 | Calendar: Creation or change time | ||
38 | .INCLUDE | 0 | 0 | Structure for LID control field maintenance | |||||
39 | SOLDTO | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
40 | SHIPTO | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | KNA1 | |
41 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
42 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
43 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
44 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHB | |
45 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
46 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
47 | OIHANTYP | OIH_HANTYP | OIH_HANTYP | CHAR | 2 | 0 | Excise Duty Handling Type | OIH5 | |
48 | TPLST | TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | TTDS | |
49 | VEHICLE | OIG_VHLNMR | OIG_VHLNMR | CHAR | 10 | 0 | TD Vehicle Number | OIGV | |
50 | DRIVERCODE | OIG_DRVNMR | OIG_DRVNMR | CHAR | 10 | 0 | TD driver number | OIGD | |
51 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
52 | SHIFT | OIG_SHIFT | OIG_SHIFT | CHAR | 1 | 0 | TD driver shift | TOIGH | |
53 | TRIP | OIG_TRIP | OIG_TRIP | NUMC | 5 | 0 | Trip Number | ||
54 | OIC_MOT | OIC_MOT | VKTRA | CHAR | 2 | 0 | IS-OIL MAP external details mode of transport | TVTR | |
55 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | TVSB | |
56 | .INCLUDE | 0 | 0 | TAS Master Data - User Fields | |||||
57 | USERFLD1 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
58 | USERFLD2 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
59 | USERFLD3 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
60 | USERFLD4 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
61 | USERFLD5 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
62 | USERFLD6 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
63 | USERFLD7 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
64 | USERFLD8 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
65 | USERFLD9 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
66 | USERFLD10 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
67 | USERFLD11 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
68 | USERFLD12 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
69 | USERFLD13 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
70 | USERFLD14 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
71 | USERFLD15 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
72 | USERFLD16 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
73 | USERFLD17 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
74 | USERFLD18 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
75 | USERFLD19 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
76 | USERFLD20 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIKLIDW | BWTAR | T149D | BWTAR | |||
2 | OIKLIDW | CHARG | MCHB | CHARG | |||
3 | OIKLIDW | CLIENT | T000 | MANDT | |||
4 | OIKLIDW | DRIVERCODE | OIGD | DRIVERCODE | |||
5 | OIKLIDW | FUNCGROUP | TOIKLIDG | LIDGROUP | |||
6 | OIKLIDW | LGORT | T001L | LGORT | |||
7 | OIKLIDW | LIDACTREAS | OIKLR | REACODE | 1 | CN | |
8 | OIKLIDW | LIDBLKREAS | OIKLR | REACODE | 1 | CN | |
9 | OIKLIDW | LIDDELREAS | OIKLR | REACODE | 1 | CN | |
10 | OIKLIDW | LIDTYPE | OIKLT | LIDTYPE | |||
11 | OIKLIDW | MATKL | T023 | MATKL | |||
12 | OIKLIDW | MATNR | MARA | MATNR | |||
13 | OIKLIDW | MMDITMNR | EKPO | EBELP | |||
14 | OIKLIDW | MMDOCNR | EKKO | EBELN | |||
15 | OIKLIDW | OIC_MOT | TVTR | VKTRA | |||
16 | OIKLIDW | OIHANTYP | OIH5 | HANTYP | |||
17 | OIKLIDW | SHIFT | TOIGH | SHIFT | |||
18 | OIKLIDW | SHIPTO | KNA1 | KUNNR | |||
19 | OIKLIDW | SOLDTO | KNA1 | KUNNR | |||
20 | OIKLIDW | TASGRP1 | TOIKTGRP | TASGROUP | |||
21 | OIKLIDW | TASGRP2 | TOIKTGRP | TASGROUP | |||
22 | OIKLIDW | TPLST | TTDS | TPLST | |||
23 | OIKLIDW | VEHICLE | OIGV | VEHICLE | |||
24 | OIKLIDW | VSBED | TVSB | VSBED | |||
25 | OIKLIDW | VSTEL | TVST | VSTEL | |||
26 | OIKLIDW | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |