Relation b/w PRPS and RPSCO tables

[Former Member]

Hi PS Experts,

What is the Relation b/w PRPS and RPSCO tables

PRPS : WBS (Work Breakdown Structure) Element Master Data

RPSCO : Project info database: Costs, revenues, finances

Thanks in Advance,

Regards,

sudharsan.

[Former Member · Accepted solution]

Hi,

As the names suggest PRPS is table for WBS element and RPSCO stores all financial information for PS objects.

The link between 2 tables is OBJNR field. Pick up OBJNR for a WBS from PRPS table and insert in RPSCO to get related financial information.

Regards

[Former Member · Accepted solution]

Hello Sasikanth Thank u for ur information,

and i need some more information, am working on abap, now i got a requirement in PS,

i want 2 calculate the values like Planned Revenue, Planned Cost, Actuall Rev, Actuall Cost, Actuall Billing, Revenue Taken, Cost Taken, BNS and SNB.

based on i/p parameters: Company Code, Fiscal year and month.

pls let me know how to calculate the above values, its very urgent for me.

Thanks in advance,

sudharsan.

[Former Member · Accepted solution]

Hi,

There is a field 'Value Type' (WRTTP) which governs which value you want to fetch like Planned Cost etc. Browse RPSCO table in SE16N, press F4 in Value type field and select appropriate value. As you are giving objectid, I think you need not worry about company code. For period you have a field Fiscal year (GJAHR).

Regards

Edited by: Shrikant Rakate on Apr 22, 2008 8:42 AM

[Former Member · Accepted solution]

Hi Sasikanth,

actually for my report the input ia Comp Code and Fiscal year and Month,

and here what is the field for Month in RPSCO table.

here requirement is for a Perticular Comp code there may be n no of projects, here i want to display all these values for all projects in that perticular comp code, that to in monthly wise in that given year.

so plz suggest me how can i proceed?

Thanks & Regards,

sudharsan.

[Former Member · Accepted solution]

Hi,

In that case RPSCO will be of little help, try COEP.

Regards