object currency not displayed for summarization report S_ALR_87015376

[Former Member]

Hello Team

The report S_ALR_87025376 is not displaying the Object Currency. All SAP standard reports show values only in Controlling Area Currency. This problem was also identified in customized reports. After analysis it has been determined that the database profiles seleceted are not getting updated. The table COEP shows Object Currency values.Ran the transaction CJEN to re-build the database profile. It did not work.

How to update the database profile inorder to update the Project Information Database so that it displays Object Currency Values?

The Database profile selected in this case is 000000001 for transaction CJH1 Inheritance Run.

REQUEST for an early update as the issue is critical.

Thank you in anticipation of a solution at the earliest

Shekhar

[Former Member · Accepted solution]

Are you sure you have mentioned the correct transaction code? The subject and the issue description both mention a different tcode. I ckecked both of them and none of them seem to exist.

Anyway whats your controlling area currency and object currency?

[Former Member · Accepted solution]

Hello Gokul

Thank you for the reply.

The Controlling Area Currency is USD(US Dollar) and the Object Currency is EUR(EURO).

The report is S_ALR_87015376 Overview: Project Hierarchies. The summarization takes place once the summarization box is flagged for all the projects and we then run CJH1 for Inheritance Run and KKRC for Summarization Run. Views are created as required depending on project type/project manager etc. The report displays the hierarchies and upon further selection provides information on projects.

There is further selections tab to select the fields for Object Currency. But upon selection the values for object currency are not getting displayed.

Regards

Veera Phani Shekhar

[Former Member · Accepted solution]

Dear Veera,

The issue you are describing is because these standard reports show in Controlling area currency by default. In order to have them show in Object Currency you must create a copy of the standard report then goto Gen. Data selection and change the currency to 20.

This is fully explained in the following WIKI and the if you wish to know how to execute the new report see the related content for additonal information where you will find another WIKI that guides you step by step.

WIKI: ht[http://wiki.sdn.sap.com/wiki/x/eYL9Cw |http://wiki.sdn.sap.com/wiki/x/eYL9Cw ]

I hope this helps you with this issue,

Kind Regards,

Brendan