topic Re: Database table for system statuses in Application Development and Automation Discussions

Database table for system statuses

former_member1276306 — Wed, 01 Feb 2023 09:21:19 GMT

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.

Re: Database table for system statuses

Dominik_Tylczynski — Wed, 01 Feb 2023 09:34:39 GMT

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

Re: Database table for system statuses

Sandra_Rossi — Wed, 01 Feb 2023 10:01:52 GMT

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

CO03

JEST

Re: Database table for system statuses

Sandra_Rossi — Wed, 01 Feb 2023 10:02:40 GMT

sandraback Last - TJ02T: