SAP Table TOIJ_TKT_TYPE
OIL-TSW: Ticket type
TOIJ_TKT_TYPE (OIL-TSW: Ticket type) 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 TOIJ_TKT_TYPE to other SAP tables.
TOIJ_TKT_TYPE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| TKT_TYPE | OIL-TSW: Ticket type | OIJ_EL_TKT_TYPE | CHAR | 3 | 0 | |||||||||
| ACTAL | TSW: Actualization allowed ? | OIJ_ACTAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRCA | TSW: ProRate Calculation necessary ? | OIJ_PRCA | CHAR | 1 | 0 |
Possible values
|
||||||||
| SSCO | TSW: ShipShore Comparison allowed ? | OIJ_SSCO | CHAR | 1 | 0 |
Possible values
|
||||||||
| DCNOMI | TSW: Default Completed Nomination Item | OIJ_DCNOMI | CHAR | 1 | 0 |
Possible values
|
||||||||
| PTL | TSW: Ticket Type 'Prior to Load' | OIJ_PTL | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOV | TSW: Ticket Type 'Left on Vehicle' | OIJ_LOV | CHAR | 1 | 0 |
Possible values
|
||||||||
| TKT_QMM | OIL-TSW: Ticket quantity measuring method | OIJ_EL_TKT_QMM | CHAR | 2 | 0 |
Possible values
|
||||||||
| TKT_TYPE_PC | OIL-TSW: Ticket type | OIJ_EL_TKT_TYPE | TOIJ_TKT_TYPE | CHAR | 3 | 0 | ||||||||
| MVSCENARIO | TSW: Movement scenario number | OIJ_MVSCEN | NUMC | 2 | 0 | |||||||||
| LAYOUTSET | Screen layout set | OIJ_LAYOUTSET | TOIJ_LAYOUTSET | CHAR | 4 | 0 | ||||||||
| UOM_TC | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||
| KALSM_HEAD | Ticket Header output det. procedure | OIJ_KALSM_TKT_H | T683 | CHAR | 6 | 0 | ||||||||
| KALSM_ITEM | Ticket item output det. procedure | OIJ_KALSM_TKT_I | T683 | CHAR | 6 | 0 | ||||||||
| VAL_GROUP | Oil TSW:Ticketing validation group | OIJ_TKT_CHK_GRP | OIJ_TKT_CHK_G | CHAR | 2 | 0 | ||||||||
TOIJ_TKT_TYPE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TOIJ_TKT_TYPE | CLIENT | TOIJ_TKT_TYPE | CLIENT | T000 | Clients | MANDT |
| TOIJ_TKT_TYPE | KALSM_HEAD | TOIJ_TKT_TYPE | CLIENT | T683 | Pricing procedures | MANDT |
| TOIJ_TKT_TYPE | KALSM_HEAD | 'B' | T683 | Pricing procedures | KVEWE | |
| TOIJ_TKT_TYPE | KALSM_HEAD | 'OT' | T683 | Pricing procedures | KAPPL | |
| TOIJ_TKT_TYPE | KALSM_HEAD | TOIJ_TKT_TYPE | KALSM_HEAD | T683 | Pricing procedures | KALSM |
| TOIJ_TKT_TYPE | KALSM_ITEM | 'B' | T683 | Pricing procedures | KVEWE | |
| TOIJ_TKT_TYPE | KALSM_ITEM | 'OT' | T683 | Pricing procedures | KAPPL | |
| TOIJ_TKT_TYPE | KALSM_ITEM | TOIJ_TKT_TYPE | KALSM_ITEM | T683 | Pricing procedures | KALSM |
| TOIJ_TKT_TYPE | KALSM_ITEM | TOIJ_TKT_TYPE | CLIENT | T683 | Pricing procedures | MANDT |
| TOIJ_TKT_TYPE | LAYOUTSET | TOIJ_TKT_TYPE | CLIENT | TOIJ_LAYOUTSET | Screen layout set | MANDT |
| TOIJ_TKT_TYPE | LAYOUTSET | TOIJ_TKT_TYPE | LAYOUTSET | TOIJ_LAYOUTSET | Screen layout set | LAYOUTSET |
| TOIJ_TKT_TYPE | TKT_TYPE_PC | TOIJ_TKT_TYPE | CLIENT | TOIJ_TKT_TYPE | OIL-TSW: Ticket type | CLIENT |
| TOIJ_TKT_TYPE | TKT_TYPE_PC | TOIJ_TKT_TYPE | TKT_TYPE_PC | TOIJ_TKT_TYPE | OIL-TSW: Ticket type | TKT_TYPE |
| TOIJ_TKT_TYPE | UOM_TC | TOIJ_TKT_TYPE | CLIENT | T006 | Units of Measurement | MANDT |
| TOIJ_TKT_TYPE | UOM_TC | TOIJ_TKT_TYPE | UOM_TC | T006 | Units of Measurement | MSEHI |
| TOIJ_TKT_TYPE | VAL_GROUP | TOIJ_TKT_TYPE | VAL_GROUP | OIJ_TKT_CHK_G | Ticketing validation groups | VAL_GROUP |
