Question:
Hi Gurus,
At present i'm working with BW 3.5, can any one help me to know about currency conversions...how it will handle the fluctuating Exchange Rates. I want to generate monthly Spend Analysis Report...like spent amount on Overseas Suppliers in this month.
hope some one will come out with a solution...it will be appreciable.
Thanks in Adavance.
_________________
Adhi.
Answer:
Are you looking for a key figure for this or what?
Answer:
Not the key figure, how BW can handle this fluctuating Exchange Rates day to day, where these rates will be stored? would like to know the functionality how it happens?
Suppose i'm looking at last month report, i'll be getting consolidated figure, my frequency is Monthly. If i want to see a particular day's exchange rate in that month (assuming where the rate is high/low). how could i see that?
Regards
_________________
Adhi.
Answer:
Hi rao_velpula,
You are actually asking for two different things in the two postings.
Exchange rates are maintained in the TCURR table (you can find with SE16). There are two ways to maintain this table:
1. Your source system is R/3 and exchange rates are already maintained over here. In this case you can use the "transfer exchange rates" when right-clicking on the R/3 source systems under the "source system" button in the 'modeling' of RSA1. (Better would be of course to even schedule this task on a daily basis).
2. Your source system in not R/3...Well...I am not the one to help you out if this is the case
Next step would be to create a currency variable in your report by using RRC1. You can find excellent information on this on the sap service marketplace (How to use variables for currency conversion)
Using this document, you will be able to select what exchange rate (for a specific day) you would like to apply to the whole month.
This is also used for Actual-to-Budget conversion rates.
In the result area of the report, you can select 'currency translation -> by target currency'. This allows you to call any of the created variables as described in the document mentioned above.
Hope this helped a bit.
Edo Meinema
Answer:
to add to what Edo has already stated...........you can load your exchange rates via R/3 or directly go and maintain them in txn code OB08