SAP ABAP Table OIK01 (IS-OIL/TAS: LID Document Data)
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 | OIK01 | Table Relationship Diagram |
Short Description | IS-OIL/TAS: LID Document Data |
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 | .INCLUDE | 0 | 0 | IS-OIL/TAS: Key LID Document Data | |||||
3 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
4 | DOCNO | OIK_DOCNO | CHAR10 | CHAR | 10 | 0 | SAP Document Number (TAS) | * | |
5 | ITEMNO | OIK_ITEMNO | NUMC10 | NUMC | 10 | 0 | SAP document item for TAS | ||
6 | LIDNO | OIK_LID | OIK_LID | CHAR | 30 | 0 | LOAD ID | OIKLIDW | |
7 | LIDADDON | OIK_LIDADD | TEXT20 | CHAR | 20 | 0 | LOAD ID ADDON | ||
8 | LIDTYPE | OIK_LIDTYP | OIK_LIDTYP | CHAR | 6 | 0 | LOAD ID type | OIKLT | |
9 | CONTRTYP | OIK_CNTTYP | OIK_CNTTYP | CHAR | 1 | 0 | Control structure type | ||
10 | .INCLUDE | 0 | 0 | IS-OIL/TAS: explicit LID Document Data | |||||
11 | FROMDATE | OIK_VDAT | DATUM | DATS | 8 | 0 | Valid from date (TAS) | ||
12 | FROMTIME | OIK_VTIME | UZEIT | TIMS | 6 | 0 | Valid from-time (TAS) | ||
13 | TODATE | OIK_TDAT | DATUM | DATS | 8 | 0 | Valid to date (TAS) | ||
14 | TOTIME | OIK_TTIME | UZEIT | TIMS | 6 | 0 | Valid to Time TAS | ||
15 | COPY_FLAG | OIK_COPFLG | CHAR1_X | CHAR | 1 | 0 | Copy flag | ||
16 | SEND_FLAG | OIK_SNDFLG | CHAR1_X | CHAR | 1 | 0 | Flag: LID distributed | ||
17 | AUTOA_FLAG | OIK_AUAFLA | CHAR1_X | CHAR | 1 | 0 | Automatic LID assignment enabled | ||
18 | CONTRSTR | OIK_CNTSTR | OIK_CNTSTR | CHAR | 6 | 0 | Control structure | OIKLTC | |
19 | CNTRLIND | OIK_CNTIND | CHAR20 | CHAR | 20 | 0 | LID control field indicator | ||
20 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
21 | ERZEIT | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
22 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
23 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
24 | AEZEIT | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
25 | AENAME | AENAME | UNAME | CHAR | 12 | 0 | Last Changed By | ||
26 | .INCLUDE | 0 | 0 | TAS Master Data Information Fields | |||||
27 | LIDDESC | OIK_LIDTXT | TEXT36 | CHAR | 36 | 0 | Load ID description | ||
28 | LIDDEPOT | OIK_LIDDEP | CHAR30 | CHAR | 30 | 0 | LID used at depot | ||
29 | LID3COD1 | OIK_3RDCOD | TEXT30 | CHAR | 30 | 0 | 3rd party code | ||
30 | LIDACTIND | OIK_ACTIND | OIK_ACTIND | CHAR | 1 | 0 | LID activation indicator | ||
31 | LIDDELIND | OIK_DELIND | OIK_DELIND | CHAR | 1 | 0 | LID deletion indicator | ||
32 | LIDBLKIND | OIK_BLKIND | OIK_BLKIND | CHAR | 1 | 0 | LID blocking indicator | ||
33 | LIDACTREAS | OIK_ACTRCD | OIK_REACOD | CHAR | 2 | 0 | LID activation reason code | OIKLR | |
34 | LIDDELREAS | OIK_DELRCD | OIK_REACOD | CHAR | 2 | 0 | LID deletion reason code | OIKLR | |
35 | LIDBLKREAS | OIK_BLKRCD | OIK_REACOD | CHAR | 2 | 0 | LID blocking reason code | OIKLR | |
36 | LID3RDPRTY | OIK_3RDDEL | CHAR30 | CHAR | 30 | 0 | 3rd-party delivery number | ||
37 | MATNR3RDP | OIK_MAT3RD | TEXT40 | CHAR | 40 | 0 | 3rd party material info | ||
38 | MATTXT3RDP | OIK_MTXTRD | TEXT64 | CHAR | 64 | 0 | 3rd party material text | ||
39 | CUST3RDP | OIK_CST3RD | TEXT40 | CHAR | 40 | 0 | 3rd party customer info | ||
40 | MATNRTAS | OIK_MATTAS | TEXT40 | CHAR | 40 | 0 | TAS material number | ||
41 | ADDITTAS | OIK_ADDTAS | TEXT40 | CHAR | 40 | 0 | TAS additive number | ||
42 | LIDTAS | OIK_LIDTAS | TEXT30 | CHAR | 30 | 0 | Load ID TAS | ||
43 | BSTYP | EBSTYP | EBSTYP | CHAR | 1 | 0 | Purchasing Document Category | ||
44 | MMDOCNR | OIK_MDOCNO | EBELN | CHAR | 10 | 0 | SAP MM document number for TAS | EKKO | |
45 | MMDITMNR | OIK_MITMNO | EBELP | NUMC | 5 | 0 | SAP MM document item for TAS | EKPO | |
46 | TASGRP1 | OIK_TASGRP | OIK_TASGRP | CHAR | 8 | 0 | TAS Group 1 | TOIKTGRP | |
47 | TASGRP2 | OIK_TASGR2 | OIK_TASGRP | CHAR | 8 | 0 | TAS Group 2 | TOIKTGRP | |
48 | FUNCGROUP | OIK_LIDGRP | OIK_LIDGRP | CHAR | 6 | 0 | LOAD ID function group | TOIKLIDG | |
49 | SDOCART | OIK_DOCART | AUART | CHAR | 4 | 0 | Subsequent document type | TVAK | |
50 | TASCFLAG | OIK_CFLAG | OIK_CFLAG | CHAR | 1 | 0 | Check flag for load ID | ||
51 | KALSU | KALSU | KALSM | CHAR | 6 | 0 | Procedure for material determination | * | |
52 | .INCLUDE | 0 | 0 | TAS Master Data - User Fields | |||||
53 | USERFLD1 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
54 | USERFLD2 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
55 | USERFLD3 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
56 | USERFLD4 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
57 | USERFLD5 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
58 | USERFLD6 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
59 | USERFLD7 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
60 | USERFLD8 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
61 | USERFLD9 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
62 | USERFLD10 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
63 | USERFLD11 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
64 | USERFLD12 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
65 | USERFLD13 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
66 | USERFLD14 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
67 | USERFLD15 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
68 | USERFLD16 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
69 | USERFLD17 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
70 | USERFLD18 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
71 | USERFLD19 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
72 | USERFLD20 | OIK_TASFLD | TEXT30 | CHAR | 30 | 0 | TAS user fields | ||
73 | .INCLUDE | 0 | 0 | Structure for LID control field maintenance | |||||
74 | SOLDTO | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
75 | SHIPTO | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | KNA1 | |
76 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
77 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
78 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
79 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHB | |
80 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
81 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
82 | OIHANTYP | OIH_HANTYP | OIH_HANTYP | CHAR | 2 | 0 | Excise Duty Handling Type | OIH5 | |
83 | TPLST | TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | TTDS | |
84 | VEHICLE | OIG_VHLNMR | OIG_VHLNMR | CHAR | 10 | 0 | TD Vehicle Number | OIGV | |
85 | DRIVERCODE | OIG_DRVNMR | OIG_DRVNMR | CHAR | 10 | 0 | TD driver number | OIGD | |
86 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
87 | SHIFT | OIG_SHIFT | OIG_SHIFT | CHAR | 1 | 0 | TD driver shift | TOIGH | |
88 | TRIP | OIG_TRIP | OIG_TRIP | NUMC | 5 | 0 | Trip Number | ||
89 | OIC_MOT | OIC_MOT | VKTRA | CHAR | 2 | 0 | IS-OIL MAP external details mode of transport | TVTR | |
90 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | TVSB |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIK01 | BWTAR | T149D | BWTAR | |||
2 | OIK01 | CHARG | MCHB | CHARG | |||
3 | OIK01 | CLIENT | T000 | MANDT | |||
4 | OIK01 | CONTRSTR | OIKLTC | CONTRSTR | |||
5 | OIK01 | DRIVERCODE | OIGD | DRIVERCODE | |||
6 | OIK01 | FUNCGROUP | TOIKLIDG | LIDGROUP | |||
7 | OIK01 | LGORT | T001L | LGORT | |||
8 | OIK01 | LIDACTREAS | OIKLR | REACODE | |||
9 | OIK01 | LIDBLKREAS | OIKLR | REACODE | |||
10 | OIK01 | LIDDELREAS | OIKLR | REACODE | |||
11 | OIK01 | LIDNO | OIKLIDW | LIDNO | |||
12 | OIK01 | LIDTYPE | OIKLT | LIDTYPE | |||
13 | OIK01 | MATKL | T023 | MATKL | |||
14 | OIK01 | MATNR | MARA | MATNR | |||
15 | OIK01 | MMDITMNR | EKPO | EBELP | |||
16 | OIK01 | MMDOCNR | EKKO | EBELN | |||
17 | OIK01 | OIC_MOT | TVTR | VKTRA | |||
18 | OIK01 | OIHANTYP | OIH5 | HANTYP | |||
19 | OIK01 | SDOCART | TVAK | AUART | |||
20 | OIK01 | SHIFT | TOIGH | SHIFT | |||
21 | OIK01 | SHIPTO | KNA1 | KUNNR | |||
22 | OIK01 | SOLDTO | KNA1 | KUNNR | |||
23 | OIK01 | TASGRP1 | TOIKTGRP | TASGROUP | |||
24 | OIK01 | TASGRP2 | TOIKTGRP | TASGROUP | |||
25 | OIK01 | TPLST | TTDS | TPLST | |||
26 | OIK01 | VEHICLE | OIGV | VEHICLE | |||
27 | OIK01 | VSBED | TVSB | VSBED | |||
28 | OIK01 | VSTEL | TVST | VSTEL | |||
29 | OIK01 | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |