Currency conversion

[#1]

In our system exchange rates are maintined from  all the currencies to USD, but non USD to non USD is not maintained. For example EUR to USD is maintained, but not EUR to GBP.  In ECC reports , EUR to GBP conversion  is happening, first by converting EUR to USD and then USD to GBP.

Can you let me know how do i do this in BW at runtime.

Regards

Madhu

[Former Member]

Hi,

For queries:

Create two currency conversion type

1. Convert everything into USD - So you receive source currency from records [here EUR] and use fixed target currency as USD

2.  Convert from USD to other currencies using the same exchange rate and fixed source currency as USD and target currency from records, here GBP -

Note: Assume you have source and target currencies are available in info provider [ EUR and GBP].

In query, you can have two CKF - [calculated key figures]

First CKF - use first conversion type to convert EUR to USD

Second CKF - > use first CFK to convert it to GBP using second conversion type.

Hope this helps

[Former Member]

Hi Arun,

Thank you for reply.

I have tried your solution, 1st step is working ( to USD) but, 2nd step is not working.

In my case, target curr. in 2nd step is also dynamic which is  maintained in infoobject. I have defined  2nd conversion type to take target currency from infoobject . Still it is not working.

2nd Conversion Type

Have you tried in your system, if not can you try and let me know.

Regards

Madhu

[Former Member]

Hi,

Did you maintain all currencies in that currency attributes? you have valid main char.s values in your info provider?

what exactly is your issue? like currency conversion is not happening or error during conversion? Please provide more details.

Also please refer this link from SAP and ensure you have followed all steps.

http://help.sap.com/saphelp_nw70/helpdata/EN/5a/8c5849b7fae266961ed707 /content.htm

or search with "Determine target currency from info objects" to get more SCN threads.

[Former Member]

Issue is, currency conversion not happening.

[Former Member]

Hi,

Did you check all of my points from that SAP HELP link? this is standard feature given by SAP and should work....

Also please ensure you have your first CKF which was converted EUR to USD in the your second CKF.

can you please provide screen shots of RSCUR and CKF just for a look?

[Former Member]

I looked at SAP help and did the same but, 2nd conversion is not happening.

As requested, attached RSCUR Screen shots.

Conversion Type1 ( to USD)

Conversion Type 2 ( USD to EUR):  Using fixed target curr (EUR) for testing purpose

1St CKF Properties Screen:

2nd CKF Definition:

2nd CKF Properties:

Message was edited by: Madhukar Balguri

[Former Member]

everything looks good...can you please paste your TCURR table entries for that exchaneg rate between EUR to USD and USD to GBP or GBP to USD?

Also did you try with "Key figures definition" in Web analyzer for that second CKF? it will show steps followed to derive that value in the query output....