SAP Table TKO03
Order status
TKO03 (Order status) 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 TKO03 to other SAP tables.
TKO03 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CLIENT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
ART
Order Type
|
AUFART | T003O |
CHAR
|
4 | 0 | |||||||
|
ASTNR
Order status
|
AUFASTNR |
NUMC
|
2 | 0 | ||||||||
|
NSTNR
Lowest order status
|
AUFNSTNR | TKO03 |
NUMC
|
2 | 0 | |||||||
|
HSTNR
Highest order status
|
AUFHSTNR | TKO03 |
NUMC
|
2 | 0 | |||||||
|
DEFST
Default status
|
AUFDEFST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PLGKZ
Identifier for planning with line items
|
PLGKZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LOEKZ
Indicator "Setting delete flag is allowed"
|
AUFLOEVM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
VOGRP
Group of allowed transactions
|
AUFVOSET |
CHAR
|
4 | 0 | ||||||||
|
PHAS0
Phase "Order created"
|
AUFPHAS0 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PHAS1
Phase "Order released"
|
AUFPHAS1 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PHAS2
Phase "order completed"
|
AUFPHAS2 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PHAS3
Phase "order closed"
|
AUFPHAS3 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
TKO03 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TKO03 | ART | TKO03 | CLIENT |
T003O
Order Types
|
CLIENT |
| TKO03 | ART | TKO03 | ART |
T003O
Order Types
|
AUART |
| TKO03 | CLIENT | TKO03 | CLIENT |
T000
Clients
|
MANDT |
| TKO03 | HSTNR | TKO03 | CLIENT |
TKO03
Order status
|
CLIENT |
| TKO03 | HSTNR | TKO03 | ART |
TKO03
Order status
|
ART |
| TKO03 | HSTNR | TKO03 | HSTNR |
TKO03
Order status
|
ASTNR |
| TKO03 | NSTNR | TKO03 | CLIENT |
TKO03
Order status
|
CLIENT |
| TKO03 | NSTNR | TKO03 | ART |
TKO03
Order status
|
ART |
| TKO03 | NSTNR | TKO03 | NSTNR |
TKO03
Order status
|
ASTNR |