Financial Data of PPM item in 1 table

[former_member195427]

Hi Experts,

Quick Query- Is there a table in PPM which shows Plan, Actual, Commitment, Budget in a single table the way we see those figures in PS table COSP?

we have Budget, Actual, Commitment flowing through PS and Plan values are in PPM item. We tried to use RPM_FIDATA but it does not show PPM item plan values,it is shown in /RPM/FIN_PLAN.

Purpose: We want to compare and use periodic plan and actual values for item PPM. We can see that in 'Financial Planning' section of PPM item but unable to find these records in single PPM table the way we see it in COSP for PS.

Please suggest.

Thanks

Saurabh

[judith_gabriel]

Hi Saurabh,

When transferring financial data from ERP-system to PPM-system the data are stored in table RPM_FIDATA - based on the value type. After starting report report /rpm/fico_int_planning with "planning" the data are transferred and stored in table /RPM/FIN_PLAN. The data which are available in this table /RPM/FIN_PLAN are displayed in the frontend of financial planning. When financial planning values are directly maintained in the item - the values are stored in /RPM/FIN_PLAN.

Information are also available in the Wiki under:

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=442632811

or

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=442632823T

Regards,
Judith