Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Currency Translation

Hi,

I have a DSO where the data is getting loaded from R/3 say DSO1. And for theDSO2 the data is coming from DSO1. Then i have a cube where the source is DSO2. The data which is coming from r/3 have data i.e amount in different currencies. I want to convert that data into a single currency ie YUSD.

My question is can we do currency transaltion at the first DSO. If not then, can we do it second DSO? If yes, then how, by a routine or can be done thru any function module? If yes, then which is the function module which supports currency translation?

We can also do currency translation at the cube level by using currency translation type. But will it be the same as the one which can be done at DSO level thru routine or function module?

We have done the currency translation at the query level, but we require at the Multiprovider level itself.

Can anyone please provide some inputs?

replied

Hi

Goto -> RSCUR

Enter the Conversion type as Z_____

Clk Create

Then in Exchange rate tab ->Select the Exchange Rate type as maintained in R3

then in Currncy tab choose the target curency that u want

then in Time Ref tab choose Variable Time Refervnce select the

period that u want to take (begin or end ..) for 0FISCPER

Then save the settings

Now i dont think u require any routine for conversion anymore

Try with this, then ask if any further queries

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question