Skip to Content
avatar image
Former Member

Display Excahnge rate for that particular day in the reports

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 04, 2008 at 06:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 07:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded