Skip to Content
author's profile photo
Former Member

Currency Conversion

Hi,

We have the following requirement from the enduser, that whenever they execute the report, there should be a variable which will ask from Currency Variable. If they select for ex. GBP, the repport should run and values should be displayed in GBP. Also, the rate of conversion will be fixed. They are ready to provide the information in flat file / table.

For Ex.

ROE of GBP = 80

ROE of USD = 45

User will provide this ROE information. Above information needs to be captured somewhere in BW.

Currently, we have all the figures in INR in the key figures

when the report is executed, report should prompt for the currency. If the user selects the USD, then ROE needs to be picked as 45 and when the GBP is selected, then ROE needs to be picked up as 80.

Request your step by step help to meet the requirement as mentioned above.

Regards

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on May 02, 2011 at 06:33 AM

    hi,

    To maintain currency conversions you must have the ADMIN rights or ask the BASIS to do it.

    Open tcode SPRO --> SAP reference IMG -->SAP Netweaver >general setting >currencies-->Enter exchange rates.

    maintain the exchange rates.

    in the query define currency variable and in KF definition use the exchange rate to display the result in the currency in the variable.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 02, 2011 at 09:16 AM

    Hello Ramesh

    I understand, that you like to have a kind of a new currency and of sure their relevant rates. In case this rates would be maintained in the source system everything would be perfect.

    So I would nevertheless maintain this rates so in you BW system in the currency customizing tables (SPRO->....)

    (->or you may convince the responsible to maintain the rates in R/3 - Treasury department?)

    The ordinary transfer of exchange rates may be setup in that way, that your own currency is not deleted

    Option: 'Update exchange rate'

    Benefit:

    - you may then use your new currency for all translation possibilities in OLAP provided in BW.

    Risk:

    -Some changes the setup of transfer of exchange rate ( what should not be)

    Thus try to set up a small example in the customizing table for your currency and you may use currency check programm RCURTEST to check correct customizing. I think it will be much faster the to create BADIS or variables or...

    Best regards

    Christian

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 11:51 PM

    Hi,

    1. In Bex analyser, every key figure property has option about conversion. Here you can create the variable.

    2. Goto RSCUR transaction, here you can create you own currency translation type. Use the variable created in Bex here in RSCUR and then user will be prompted to enter the currency in which he wants to see the report in.

    (Each key figure in your report can be converted into different currency using this option.)

    How its translated to user selected currency is maintained in the currency type you created in RSCUR.

    Hope this helps.

    Thanks,

    Naveen Rao Kattela

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 12:00 AM

    For calculating ROE based on user entry, may be its better to use formula variable and use this in you formula keyfigure.

    OR ask users to maintain new Z currency type in R/3 itself so that you will not overwrite otherwise maintained in BW.

    Thanks,

    Naveen Rao Kattela

    Add comment
    10|10000 characters needed characters exceeded