Which table contains the status for WBS elemnts

[Former Member]

Hi Experts ,

Could some one provide information regarding :-

While we check WBS element in t-code :CJ03 for every WBS there are some status fields indicating REL / PLN etc.

At the table level i m unable to find this status field.

Aldready Checked in master data table PRPS and PROJ also PRHI but it doesnot exsist in any of them.

Is this populated though some other functonality or its stored in some database table : corresponding to WBS elements

Any help is beneficial

P.S : The answer to the above was not found in any exsusting thread here . So before Locking the thread please do provide the reason and tehn lock

Thanks

Kylie

[muthusamy_sankaran]

Hi,

First go to PRPS table input the WBS Element number and get the object number

Input this object number in JEST table and get the system status

Input the system status in TJ02T table ,u will get the WBS Element status

OR

use can use below function module to read the status

STATUS_READ

Regards,

Sankaran

Edited by: Sankaran M on Sep 14, 2010 4:57 PM

[Former Member]

Thanks for your help.

Well can you/anybody also guide on the below scenario :-

Our requiremnet is to send valid WBS elements <master data> from SAPR/3 to third part system

Do we need to check the Deletion flag (PRPS-loevm) = space and then check the statuses for these wbs elements

by retrieving details from the above mentioned tables and then send ?

Do we need to check the Project details associated (PROJ - available) and then consider its corresponding WBS elements (PRPS) and then send the data to third party system ?

Well i know this is best dealt by dealt at functional point of view since i m a technical abaper i had the question for the experts of Project Systems .

Any information will help in analysis.

Thanks

Kylietisha

[muthusamy_sankaran]

>

> 
> Do we need to check the Project details associated (PROJ - available) and then consider its corresponding WBS elements (PRPS) and then send the data to third party system ?
> 
> Thanks
> Kylietisha

As per my knowledge, this is the best method to retrive the correct data

check the Project details associated (PROJ - available) and then consider its corresponding WBS elements (PRPS)

Regards,

Sankaran

[Former Member]

well thanks for your reply ,

But , the field PSPNR of PROJ when applied to POSID of PRPS it provides the detail about one WBS Element only

whereas there can be multiple WBS element for a single project definition .

On the other hand , if the third party system needs to WBS elemnts master data then its required to send all the available created WBS elements .

As per my analysis there cannot be a WBS creation in Project System without a Project Definition.

So even if we donot check teh exsistence of teh project definition associated with WBS then also the data should be fine. What do you suggest on this ?

Since i dont find an appropriate field to provide Project Definition number in table PRPS or which field in PRPS can relate to PROJ ?

Because a project can have multipleWBS elements assigned (can you approve this ?)

Eg :

In CJ03 : Project Definition = M.9995 on checking the WBS assigned follwing are the WBS elements

WBS :- M.9995.1

M.9995.2

Now which field in PRPS can enlist me all theWBS for a projcet : Suppose the Project :M.9995then i need all the WBS associated at the table level . I m asking this question since i dont think there is such a field . As PRPS-PoSID = PROJ-PSPID only this relation exsists.

Please verify the above understanding , it will be very beneficial as a knowledge of PS . Could somebody suggest on the above assumption

Thnaks

Kylietisha

Edited by: kylietisha on Sep 19, 2010 7:18 AM

[Former Member]

Post it in a proper forum, you will get good number of replies.

[Former Member]

Hi,

As Mr. Ahmed rightly points out, this query needs to be in PS forum & not in PP forum.

Anyways for this case, you will need to refer to PRHI table to get the hierarchy of your project. Once you're able to understand the entries in the table you should be able to pull the info you need.

Regards,

Vivek

[Former Member]

Well tahnks for your suggestions.

Issue has been resolved .

Closing this thread

[former_member834630]

Similar you can check below table to get the date wise change status:

Go to PRPS table,

Get the Object number = OBJNR based on last changed on.

Then go to JCDS table,

pass the Object number = PRPS-OBJNR and pass the date as well. Get list of Status - JCDS-STAT

Then go to TJ02T, pass the status codes: TJ02T-ISTAT = JCDS-STAT, enter the language =EN and fetch the status and description of that particular entry.

[Former Member]

resolved myself

[manojk4]

can u provide the table names please