Database table for system statuses

[former_member1276306]

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.

[DominikTylczyn]

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

[Sandra_Rossi]

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

CO03

JEST

[Sandra_Rossi]

sandraback Last - TJ02T: