Identification of Parent and Child WBS elements at Table level

[Former Member]

Hello Friends,

We are building a new report based on the table RPSCO for getting the overall budget values for WBS elements. we are filtering based on the value type 41 in the table. Our report works well for child WBS elements and the overall budget value is picked up correctly and it is matching with the values in S_ALR_87013558 report. But for the Parent WBS elements the values in RPSCO table sums up to 0.00 whereas in the S_ALR_87013558 report all the child values are summed up and displayed at Parent level.

How do we identify whether a wbs element contains child or not through the tables?

Any inputs on this is highly appreciated.

Regards

Surya

[MTerence · Accepted solution]

Hi Surya,

You cannot get the same in Table RPSCO, but you can pass the Object Number in Table PRPS.

In PRPS Field STUFE will represent the levels, If it is one it is Level 1... correspondingly Level 2, Level 3 and goes on.

You need to write a logic to identify the WBS element having childs.

Check this Thread, which might give some additional information

Regards

Terence

[Former Member · Accepted solution]

Hi Maria Terence,

Thanks for the link. I used the table PRHI to build my logic.

[sanjeevc]

Check Below Reports

CJI3 for actual cost

CJI5 for Commitment cost

CJ43n for wbs' level

RPSCO is the master table of storing any kind of cost.

so check with other table COSS and COOI as well.

Regards,
Sanjeev