Question Re: Table for Status change of WBS with respect to date in Enterprise Resource Planning Q&A

Table for Status change of WBS with respect to date

former_member226890 — Mon, 01 Sep 2014 07:24:16 GMT

Hi,

Please let me know the table name which shows the staus change in WBS with respective to dates.

Thanks,

Sudhindra

Re: Table for Status change of WBS with respect to date

sammar81 — Mon, 01 Sep 2014 07:41:02 GMT

Hi Sudhindra,

You can get it from change table JCDS. Just pass the OBJNR from PRPS table to get the required details.

You can check the same individually from Project Builder as well...

Cheers

Sammar

Re: Table for Status change of WBS with respect to date

former_member183424 — Mon, 01 Sep 2014 07:50:19 GMT

Go to SCN Seach and type "Status Change Log for WBS Element" and enjoy the old 133 similar discussions.

Re: Table for Status change of WBS with respect to date

former_member226890 — Mon, 01 Sep 2014 14:27:16 GMT

Hi Dev,

Thanks very much for your inputs. If you can give little more information that would help me a lot.

Actually I want to get the User status ,Date change table.Every time the user status is changed & set , I want to know the table which updates these dates.

Thanks in Advance.

Sudhindra

Re: Table for Status change of WBS with respect to date

sammar81 — Tue, 02 Sep 2014 03:35:02 GMT

Hi,

Are you new to SAP PS??

Pass the OBJNR and STAT fields in the JCDS table, for User Statuses Pass the values which are starting with E and for system statuses it will start with I.

To get your details you need to write a small query in SQVI. Join the following tables.. PRPS, JEST and JCDS.

To know the user statuses you need to pass the OBJNR for the WBS to the JEST table and keep the system inact= blank.. this will give you the current active user status.

Pass that user status to JCDS for getting the date and time of change for the particular status.

Hope it helps..

Cheers

Sammar

Re: Table for Status change of WBS with respect to date

former_member226890 — Thu, 11 Sep 2014 08:34:11 GMT

Hi Sammar,

Thanks very much for your basic inputs on delivery through project.Sorry for delay in response.

Thanks & Regards,

Sudhindra

Re: Table for Status change of WBS with respect to date

Former Member — Thu, 11 Sep 2014 13:43:07 GMT

Hi Sudhindra

fetch the object number of Project definition from PROJ table or WBS from PRPS table pass it in JCDS table . you will get the date, time , different status change, user name and the transaction used to change the status of the object.

regards

Vijay kumar hebbal