Currency Conversion in PS Reporting

[Former Member]

HI Gurus,

we have an issue using STD reports in Projects system.

The problem appears if a transaction is not in a Controlling Area Currency (in our case USD), but in Local Currency - for example EUR.

If the Business have spend, for example 5000 Eur, they want to see exactly that figure in a reporting.

However, in STD Reports this amount seems to be converted into Controlling Area Currency (USD) & then back to EUR. So as the result, a different amount (not initial 5000 Eur) is reported & the user is confused.

This happens for example in S_ALR_87013557 - Financials -> Costs -> Budget-Related -> Budget/Actual/Variance

So instead of 5000 Eur, the user gets an amount of 5392Eur in reporting & becomes totally confused.

Please can you tell if there is a way of setting up a system, so that this double conversion to Controlling area currency & backwards is NOT happening, & the system just shows initial amount as it is in local currency

[Paulo_Vitoriano · Accepted solution]

Hi Daria,

In Controlling (and PS) you always have 3 currencies available in all reports: Controlling Area currency, Object currency (same as Company Code currency in your case) and Transaction currency.

Also there are user settings that can default it in most standard reports with RPP0 transaction:

The situation you describe here is not normal, and looks like you have applied additional currency conversion... or maybe just confusing lines?!  Are you sure those two figures correspond to each other?  Unlikely reason can be a system bug, so you should search for relevant OSS notes.

Regards,

[Former Member]

Hi Daria,

Tusshar has suggested an apt solution for your issue. You can go ahead and implement the required notes and your issue should be resolved.

Alternatively, you can copy the standard reports and create new ones using the report painter functionality. Once you have done that, for each of the columns in the report you can change the currency from Controlling area currency to Object Currency/Transaction Currency in the report form.

Transactions CJE1 through CJE6 should help you doing that. You can even have custom tcodes to run these copied reports For e.g. you can name the report S_ALR_87013531 as Z_S_ALR_87013531

Try it once and let us know.

Best Regards,
Gokul

[Former Member]

Hi Daria,

Please check in OB08 what is currency exchange rate maintained.

Also check following SAP note

1888213 - Values with "Object currency" are displayed incorrectly in PS reports

Following thread also can give you pointers.

Regards

Tushar

[former_member591922]

Hello Tushar/Team,

We are facing the similar issue where Reports S_ALR_87013558 values are not coming in Object currency.

Already implemented note 1888213,but what has to be done post implementation of this.

Even tried Note 1925431 which is about creating a report through report painter and adding a parameter of object currency through report painter,but problem is Remaining order plan value is coming blank after this.

Please guide on this.

Thanks

Karan Varshney

[MTerence]

Hi Karan,

Since the notes given by SAP is not resolved. Have you raised this with SAP ?

Regards

Terence