Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database table for system statuses

0 Kudos

Hello,

I am looking for the database tables that contains system status CNF for pp orders (like in COOIS transaction). Passing aufk.objnr through jcds.objnr only gets me the DEL, REL, CLSD and TECO statuses...

Is there any other tables that could give me more statuses, I have tried jcds, jest and tj02t.

T1321 is another table, containing the field STTXT. But the problem with this table is that I can not seem to find a possible joining condition for this table.

The best table for me to find would be one that contains all statuses in one row, like in COOIS transaction.

1 ACCEPTED SOLUTION

DominikTylczyn
Active Contributor

Hello sandraback

One line system status of a production order that you can see in COOIS or in CO03 is not stored in a database table. It is calculated dynamically based on the JEST table:

  • JEST-OBJNR = production order number preceded with OR
  • JEST-STAT - internal code of a status

Then TJ02T stores language dependent texts of system statuses.

Best regards

Dominik Tylczynski

3 REPLIES 3

DominikTylczyn
Active Contributor

Hello sandraback

One line system status of a production order that you can see in COOIS or in CO03 is not stored in a database table. It is calculated dynamically based on the JEST table:

  • JEST-OBJNR = production order number preceded with OR
  • JEST-STAT - internal code of a status

Then TJ02T stores language dependent texts of system statuses.

Best regards

Dominik Tylczynski

Weird that sandraback had all tables but didn't find the statuses.

CO03

JEST

sandraback Last - TJ02T: