Project actual cost

[Former Member]

Hi experts,

I would like to select project actual cost (like in CJ74), I found RPSCO table, but there is no connection to posting date. Anyone knows form which tables CJ74 is selecting data? Thank you in advance.

Best regards,

Paweł Smuda

[Former Member · Accepted solution]

Hi Pawel,

Why would you want to select the actual cost data from RPSCO table only based on the posting date?

You will get all the required (costs, revenues) data from the RPSCO table. Try to use some other input criteria to fetch data from the RPSCO table. I am sure you will get it. Else, let me know for which object you would like to fetch the data and i would help you with the logic.

For e.g. If actual cost is posted on a WBS element input the OBJNR of the said WBS into the RPSCO table, choose value type as 4, debit type as 1 and execute it. You will get the required data.

If actual cost is posted on an activity, follow this logic,

In PRPS enter the project number and get a list of all the WBS elements in the project. Copy these WBS elements and input them in the AFVC table. This will list out all the activities in the project. Copy all the OBJNR's of these activities and input them in the RPSCO table with value type as 4 and debit type as 1. You will get the required data.

Hope this helps.

Regards,

Gokul

[Former Member · Accepted solution]

Thank you Gokul, it is very helpful, but I have to include posting date in selection screen and somehow filter data regarding to it. I can't find connection between RPSCO and COBK(?) where posting date is.

I saw that standard report like CJI3 or CJ74 is using logical database approach, but it seems too complicate in this case to implement it.

BR

Pawel Smuda

[former_member195427]

Hi,

    Check with COES,COEP and COSP .

Also check tables VSRPSCO_CN , VSPRPS_CN ,  EVOP_VS .

Regards

Ankur

[Former Member]

Hi,

See this- http://scn.sap.com/thread/813209

Regards,

Pranav

[Former Member]

Hi Pawel,

Try with COSS & COSK tabels.

Regards,

Sumanth