Display Excahnge rate for that particular day in the reports

[Former Member]

Hello friends,

I have a requirement from the business users to display the exchange rate being used to convert USD to JPY for that particular day in the reports. Is this possible. Please give me the steps to make this solution.

Appreciate a lot

--Thanks

Simmi

[former_member204514 · Accepted solution]

Hi,

We can load these exchange rates from source systems to a direct or write optimized dso and from there we can access into the report.

load to the dso can be defined as per the requirement.

Hope it helps,

Regards,

aanand

[yogesh8984]

Hi,

What will be the source of such exchange rates in your scenario? If you want to take it from the standard tables in SAP, you can load the data from such tables to the master and then can create the report on master.

On the other hand, if you want to take it from internet, you can get the data into BI from Internet using RDA (Real Time Data Acquisition) (which can be implemented in 2004s only).

I think first option would be simpler to implement.

Regards,

Yogesh

[Former Member]

Yes Simmi this can be done by creating a currency translation in RSCUR tcode.

Provide the source as USD and target as JPY with date as current, exchange rate type as relevant and use this in the report in a formula.

Naveen.A