SAP table TKO03 (Order status)
SAP table TKO03 has 3 primary key fields being CLIENT,ART,ASTNR.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| ART | Order Type | CHAR | 4 | 0 | T003O | AUFART | |
| ASTNR | Order Status | NUMC | 2 | 0 | AUFASTNR | ||
| NSTNR | Lowest Order Status | NUMC | 2 | 0 | TKO03 | AUFNSTNR | |
| HSTNR | Highest Order Status | NUMC | 2 | 0 | TKO03 | AUFHSTNR | |
| DEFST | Default Status | CHAR | 1 | 0 | AUFDEFST | ||
| PLGKZ | Identifier for Planning with Line Items | CHAR | 1 | 0 | PLGKZ | ||
| LOEKZ | Indicator "Setting Delete Flag Is Allowed" | CHAR | 1 | 0 | AUFLOEVM | ||
| VOGRP | Group of Allowed Transactions | CHAR | 4 | 0 | * | AUFVOSET | |
| PHAS0 | Phase "Order Created" | CHAR | 1 | 0 | AUFPHAS0 | ||
| PHAS1 | Phase "Order Released" | CHAR | 1 | 0 | AUFPHAS1 | ||
| PHAS2 | Phase "Order Completed" | CHAR | 1 | 0 | AUFPHAS2 | ||
| PHAS3 | Phase "Order Closed" | CHAR | 1 | 0 | AUFPHAS3 |
TKO03 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TKO03 | ART | T003O | Order Types | AUART |
| 1 TKO03 | CLIENT | T000 | Clients | MANDT |
| 0 TKO03 | HSTNR | TKO03 | Order status | CLIENT |
| 0 TKO03 | HSTNR | TKO03 | Order status | ART |
| 1 TKO03 | NSTNR | TKO03 | Order status | CLIENT |
| 1 TKO03 | NSTNR | TKO03 | Order status | ART |