cancel
Showing results for 
Search instead for 
Did you mean: 

How to show current currency rates in a query?

Former Member
0 Kudos

Hello!

I want to get a query like this:

Input fields:

- Currency (e.g. USD)

- Period (e.g. 001.2008 - 003.2008)

Output table:

-


RUB-------EUR

Jan 2008---24.2--


0.8

Feb 2008--23.5--


0.9

Mar 2008--25.6--


0.7

I use 0CURRENCY and 0FISCPER charasteritics to form this table, but what key figures should I use to get this vlaues?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Is this query needed for end users ?

if not, just go into your SPRO, and check the Currency conversion rates.

If yes, maybe you should create an ODS feeded by TCURR and relative tables.

Former Member
0 Kudos

Yes, exactly. For end users

Former Member
0 Kudos

So, just create an ODS, filled by an infoset based on TCURR and relevant TCUR* tables. You'll after be able to report on it.

Former Member
0 Kudos

Oh... can anybody give me a steb-by-step instruction or links where I can see how I should do it? I'd be really pleased for this!