Skip to Content
0
Former Member
Feb 10, 2011 at 10:49 AM

Multiple currency translation in one single query execution.

80 Views

Hi folks.

I have today running in production, a report like:

The user input a period and a version (multiple single values selecion)

- Period

- Version (0VERSION)

And the report returt as follow

2010

Version A1 Q1

Key Figure 1 500BRL 400BRL

Key Figure 2 300BRL 200BRL

-


Now, the user requires a currency translation based on the version selected in the filter. I mean, for version A* use one exchange rate type.

For Q* version, use another exchange rate type...and so one...

For instance, the solution is to create a currency translation type like:

Exchange rate type from Var. and create this var as user exit with an abap that checks the version selected by the user in the

report and than return the exchange rate type based on this version...

This solution works only if the user input only one version in the filter. But, he needs to input three, four..versions and

in one execution of the report, translate the currency using a exchange rate type for each version.

Ex: Exchange Rate for version A1 (1.8USD = 1BRL) Exchange Rate for version Q1 (1.5USD = 1BRL)

Then, the report should return:

2010

Version A1 Q1

Key Figure 1 277,7USD 266,6USD

Key Figure 2 166USD 133,3USD

I know it's a little complex to describe, but if someone know how to do it, I'll aprecciate.

Best Regards,

Thiago