topic Re: Finding the previous active user status in Application Development and Automation Discussions

Finding the previous active user status

Former Member — Thu, 26 May 2011 10:34:00 GMT

Hi,

Can anyone tell me how I can find the previous active user status for a work order. The criteria is, I want to find only the previous active user status with a status number. Please help

Re: Finding the previous active user status

Former Member — Thu, 26 May 2011 11:23:59 GMT

Hi,

you can find the valid ststus in JEST and the history in JCDS. Hope this helps.

Regards,

Klaus

Re: Finding the previous active user status

Former Member — Thu, 26 May 2011 11:25:12 GMT

Hi Joshi,

You can get the same from the table JCDS

Pass OR<order no> as object, User status starts with 'E' and the field CHGNR will give you the sequence no

so you can easily detrmine which was the last user status active.

Hope this solve your problem

Regards

Bikas

Re: Finding the previous active user status

Former Member — Thu, 26 May 2011 11:25:26 GMT

Hi,

you can find in info type 0000 field massn. check the info type.

Ram.

Re: Finding the previous active user status

Former Member — Thu, 26 May 2011 11:39:46 GMT

Yes I know JCDS table will give the history of all the user statuses for a particular object number. But if i have activated an order using the user status with status number and user status without status number, then both gets saved in the JCDS table and I need only the status with a status number. Actually my requirement is to perform an operation only if the previous active user status is different from the current one. JCDS table gives only the status number and not the status profile. If you take this user status and check in TJ30T table, you may be able to find many user status texts associated with it. So I will not be able to compare the current user status with the previous user status incase, both have the same status numbers. Hope I have made myself clear. Is there any function module to find this out.

Re: Finding the previous active user status

Former Member — Thu, 26 May 2011 12:38:11 GMT

Hi,

Can anybody please help me out find the exact user status which encounters the above criteria.

Re: Finding the previous active user status

Former Member — Tue, 07 Jun 2011 04:37:36 GMT

Hi,

to get the Status Profile look in table JSTO with OBJNR of your work order. In tables TJ30 and TJ30T you can find out the meaning and description of the status depending on this status profile ...

Regards,

Klaus