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
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
X Yes
NULL No
PLGKZ Identifier for planning with line items PLGKZ CHAR 1 0
X Yes
NULL No
LOEKZ Indicator "Setting delete flag is allowed" AUFLOEVM CHAR 1 0
X Yes
NULL No
VOGRP Group of allowed transactions AUFVOSET CHAR 4 0
PHAS0 Phase "Order created" AUFPHAS0 CHAR 1 0
X Yes
NULL No
PHAS1 Phase "Order released" AUFPHAS1 CHAR 1 0
X Yes
NULL No
PHAS2 Phase "order completed" AUFPHAS2 CHAR 1 0
X Yes
NULL No
PHAS3 Phase "order closed" AUFPHAS3 CHAR 1 0
X Yes
NULL No

TKO03 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TKO03 ART TKO03 ART T003O Order Types AUART
TKO03 ART TKO03 CLIENT T003O Order Types CLIENT
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 ART TKO03 Order status ART
TKO03 NSTNR TKO03 NSTNR TKO03 Order status ASTNR
TKO03 NSTNR TKO03 CLIENT TKO03 Order status CLIENT