on 10-12-2012 8:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Menaka,
Please have a look on the thread:
http://scn.sap.com/thread/2025725
Hope, it can help.
Regards
Ankur
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.