Equipement User status History

[Former Member]

Hi Super Gurus,

I'm looking for having a listing for my user status equipement history.

In fact,

I have already tested the tab extras => Usage list and IH08 and IE07. the problem is that the user status is containing the last value for the user status.

Is that a problem,

- Do i need to check the tracking of changes on a specific table in SPRO ?

What i see in the Usage list for the user status :

Thank you.

Karim. Es

[Former Member · Accepted solution]

Dear Espartie A,

There are Two Ways to go about it.....

Standard:

1. You can use Action Log Option in Extras Menu in Equipment & Sort on Changed Field Column to see the Changes in User Status / System Statuses for the respective Object. (Equipment in your case).

Custom:

2. If you need a separate screen showing only User Status Data, It can be custom developed with following Logic to read the Equipment User Status Data.

1. Pass Equipment Number (EQUNR) to Table V_EQUI & Get OBJNR.
2. Pass OBJNR to Table JSTO to get Equipment Status Profile (STSMA).
3. Pass OBJNR to Table JCDS to get all Status Changes. Read field STAT (E* for User Statuses).
4. Pass STSMA & STAT values from JCDS to table TJ30T to get Status Description.

Once this small logic is coded, you can get a simple report to get user status history of any Object.

The Logic I have provided above is also available in some of Standard Function Modules as given below. You can pass OBJNR to get Status Changes Data.

/ISDFPS/JCDS_RD

Do let me know and remember to Credit points if I helped solving your Query.

Thanks.

Regards,

Avi

[sebastian_lenartowicz]

Greetings Karim,

I'm not sure I'm following your requirement here - indeed, the standard transactions will be displaying the latest, active stati for the Equipment. This is the intended, standard purpose on the ALV lists, in IE02/IE03 screens, etc.

You may access the history from the menu of the Equipment / Status Information screen for the particular Equipment. This is possible for one Equipment at a time.

Or, if you have the need to report on historic status of perhaps more than one Equipment, you may develop a query or report, looking into the data in the EQUI & JCDS tables - the latter contains the change documents for the objects status, so you can link them on the OBJNR field.

But in the standard ALV, you can't see the history and there is no configuration to enable it.

I hope this answers your doubts, or if not, then please can you share further information about your requirement?