SAP PS table to fetch Actual revenue in USD and INR

[Former Member]

Hi All,

I am not able to fetch Actual revenue from RPSCO table which is in USD.

For Example: My actual revenue against a Forex GL which is in USD is not getting fetched.

In my CJI3 report my Value/CO is Rs 150 and Value/Tcurr is Rs 100.The difference is Rs.50 in USD which is getting posted against a forex revenue GL.

I am able to fetch only Rs 100 and Rs 50 is not geting fetched from RPSCO table, I need to show actual Revenue as Rs 150.

Is there any way to fetch this data.the logic used to fetch the actual revenue is

pass PRPS-OBJNR to RPSCO-OBJNR, WRTTP = 4, VERSN=0, GJAHR<> blank,ACPOS="REVENUE" and sum of all WLP00 to WLP16

[kenmelching]

A few points.

1. Does CN41N show the correct actual revenue for the project?

2. The RPSCO table sometimes needs to be reconstructed when it gets out of sync with the CO tables. Use transaction CJEN. It should scheduled to run regularly.

3. I always tell my developers to not select from RPSCO but to use the original CO tables, COEP, COSS, or COSP.

COSS and COSP are summary tables and are the best choice for performance. COEP is the line item table and gets huge quickly.