Latest system status of WBS using SAP tables

[former_member402478]

Hi All,

At WBS level , we have three system status in active mode : REL  BUDG  AVAC

To track the latest status using tables, i am using PRPS - JEST - TJ02T. From these tables i can see all the system status(which mentioned above), but how to track which one is latest, could any one please help me ..

Regards,

Vikas Jain

[former_member209919]

Hi Vikas,

instead os check in JEST table uses table JCDS for your purpose.

Regards

[former_member402478]

Hello Sara,

Thanks for the answer. From JCDS we can see all the status as shown below.

Status	ChN	Date	Time	I	I/U
I0001	1	29.11.2011	13:24:38		I
I0001	2	01.12.2011	9:59:31	X	U
I0002	1	01.12.2011	9:59:31		I
I0005	1	01.12.2011	5:32:20		I
I0067	1	01.12.2011	5:32:20		I
I0093	1	13.02.2012	7:38:45		I
I0093	2	13.02.2012	7:40:16	X	U

I0005 is the recently updated status, how to track it, could you please help.

Regards,

Vikas

[Former Member]

Hi,

From the table above filter out the entries for change number 2, which are usually the inactive status'. Then you can filter out the entries based on time and date. However, there might be an instance when you may find 2 status with the same time and date stamp. You need to decide on which status you are concerned about and pick it.

Regards,

Gokul

[former_member195427]

Hi Vikas,

              In SE38 run program RBSVCDOC , give object number of WBS elements from PRPS table and execute. It will show you all status changes in WBS element/s. Clicking on the soft button 'History' will show you the status changes date-wise. The top one will be the latest.

Regards

Ankur

[former_member402478]

Hi Ankur,

Thanks for the response. From this program i can track all the active/Inactive status, but i want to track recent status only.

For example: REL  BUDG  AVAC

here AVAC is the latest updated status. It has to be display.

Regards,

Vikas