cancel
Showing results for 
Search instead for 
Did you mean: 

Actual Cost for Project in report

Former Member
0 Kudos

Good Afternoon PS Gurus,

Please help me out with the new requirement

I have requirement with many things in which one column is to sow Actual Cost for Project in report.

Logic which I gave is

From COEP table, AUFK (Enter the WBS numbers), which were taken from PRPS table AFKO, Network, get routing operations (AUFPL) AFVC (enter AUFPL), get object number (OBJNR) Activity number COEP (enter OBJNR), get the cost

This requirement is working fine for 80% of the projects, but not for all.

Customized report actual value is not matching with CJI3 Actual values

Example:

I debugged the CODE & found there is 20000 INR & the same seen in COEP table, but CJI3 value is 80000INR.

My customized report actual column should match with CJI3 report , but this is not happening for few projects.

Please throw light in this issue.

Have a G8 weekend.

Thanks & Regards

MM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Gurus,

Thanks for the response.

CO Order values were not captured Hence logic need to added for this requirement.

Any comments on this.

Thanks

MM

Former Member
0 Kudos

What do you exactly mean by CO order values?? Are these Internal Orders??

Also, did you try running CJEN for the said project?

Former Member
0 Kudos

Hello Gokul,

They are internal order's.

Any idea how to get the actual data from IO's.

Thanks

MM

Former Member
0 Kudos

Are the internal orders assigned to Project objects?? If yes, please check table COEP, COBK, COVP.

Former Member
0 Kudos

Hello  Gokul,

from COAS we need to get the order number .

Internal order number need to be passed in RPSCO with value type 4 & ledger as project currency

i gave this to ABAP team. It worked when i checked.

I will update u later

Thanks a lot again Gokul.

MM

former_member183901
Active Participant
0 Kudos

Hi Menaka,

As per the business process what components are there as Actual Costs. There can not be such a huge difference in values from CJI3 to COEP table. Elaborate the actual cost components that have been booked so that forum can understand the issue properly.

Check by restricting the Posting Date in CJI3 or select Cost Elements which are at par with COEP.

Regards,

MRD

Former Member
0 Kudos

Hi Menaka,

Why dont you try using the RPSCO table to fetch the values? It would be much better if you use RPSCO table for this.

In order to fetch actual costs for WBS just enter the OBJNR for the said WBS in RPSCO, filter it for value type 4 and you should get the desired values.

For activities, get the list of WBS elements from the PRPS table, pass them in the AFVC table to get the list of activities in the project, get the OBJNR's for these activities, input them in the RPSCO table, filter it for value type 4 and you should get actual costs for activities.

Hope this helps. If you need something else let us know.

Regards,

Gokul

Former Member
0 Kudos

Hello Gokul,

Thanks for your reply.

Even i am seeing the same value in RPSCO with value 4.

It's  20000 INR. The same was seen @ COEP.

which is worng as per CJI3 value is 80000INR.

Please help.

Thanks

MM

former_member195427
Active Contributor
0 Kudos

Hi Menaka,

                Please have a look on the thread:

http://scn.sap.com/thread/2025725

Hope, it can help.

Regards

Ankur