User/System Statuses of PM Orders

[Former Member]

Hi,

Can anyone tell me where in which table(s) user and system statuses of PM orders are stored? E.g. TECO etc.

Thanks,

Richard

[Former Member · Accepted solution]

Hi Richard,

You can check table TJ30 for user status & TJ02 for system status.

Check TJ30T & TJ02T for texts of user & system statuses respectively.

Reward if useful.

Regards

Sayee

[Former Member · Accepted solution]

Thanks very much Sayee, that'll be very useful in the future. However, I didn't make myself very clear. What I really need to know is where the statuses of a particular order are stored i.e. if I have an order number, where can I find data which specifies which user statuses are active for it?

Thanks!

[Former Member · Accepted solution]

Richard,

You can use table JEST to get active user status of the PM order. You will need to input the object number of the order which you can get from table AUFK.

Hope it helps,

PJ

[Former Member]

hI,

Check the table TJ20T or use the FM STATUS_TEXT_EDIT tO GET THE Status.

Regards

[Former Member]

Hi,

User statuses are not in tables but in Structures ex: CNJ_STAT.

Thanks

Jagdish