Currency Conversion Based on User Input

October 28, 2013 | 318 Views |

Ganesh Bothe

bex Enterprise Data Warehousing / Business Warehouse query design

Purpose

The purpose of this document is to provide new currency translation type in the CONVERSION tab of key figure properties in query designer.

How To create

Step 1

In tcode RSCUR, create a translation type ZCALMON.

In the screen that opens up, in the EXCHANGE RATE tab, give M as the exchange rate type

Step 2

In the CURRENCY tab, give the variable name (ZCURRANALYSIS) against the OPTION button TARGET CURRENCY FROM VARIABLE in TARGET CURRENCY

Step 3

The variable ZCURRANALYSIS is defined as follows for the 0LOC_CURRENCY infoobject in query designer.

Step 4

In the TIME REFERENCE TAB, select END OF MONTH against the option button VARIABLE TIME REFERENCE and select 0CALMONTH against the option button STANDARD INFOOBJECT

Step 5

Now the currency translation type ZCALMON is available in the CONVERSION tab of key figure properties in query designer.

To report this post you need to login first.

64 Comments

You must be Logged on to comment or reply to a post.

Former Member November 12, 2013 at 11:28 am

Good Job Ganesh.

like (0)
1. Ganesh Bothe Post authorNovember 12, 2013 at 11:35 am
  
  Thanks for your feedback 🙂 .
  
  like (0)
Former Member November 22, 2013 at 11:38 am

Good job.

like (0)
1. Ganesh Bothe Post authorNovember 22, 2013 at 11:44 am
  
  Thanks Bharat 🙂
  
  like (0)
Former Member November 29, 2013 at 3:18 am

Hi Ganesh,

Great and simple.

If I want to use the exchange rate based on the payment date in cube, how to achieve it?

Its not the current date. Its like, we have to consider the payment date thats coming from record.

Please refer below thread and suggest

http://scn.sap.com/thread/3462450

like (0)
1. Ganesh Bothe Post authorDecember 3, 2013 at 10:45 am
  
  Thanks aditya for your feedback 🙂 .I will check your thread and let you know.
  
  like (0)
Former Member December 3, 2013 at 11:31 am

Nice information ……….. 🙂

Good Job.

regards,

Sm

like (0)
1. Ganesh Bothe Post authorDecember 3, 2013 at 11:48 am
  
  Thanks you satendra 🙂 .
  
  like (0)
Krishna Chaitanya December 3, 2013 at 11:37 am

Good one and great job. Thanks for sharing.

Keep it up. 🙂

Regards,

Krishna Chaitanya.

like (0)
1. Ganesh Bothe Post authorDecember 3, 2013 at 11:49 am
  
  Thanks krishna 🙂 .
  
  like (0)
Former Member December 3, 2013 at 11:49 am

Good Job.

like (0)
1. Ganesh Bothe Post authorDecember 3, 2013 at 11:51 am
  
  Thanks Varsha 🙂 .
  
  like (0)
Former Member December 3, 2013 at 11:52 am

Really useful information. thanks for sharing

like (0)
1. Ganesh Bothe Post authorDecember 3, 2013 at 3:26 pm
  
  Thanks raman for your feedback 🙂 .
  
  like (0)
Former Member December 4, 2013 at 1:46 am

Hi ganesh,

Nice information.

like (0)
1. Ganesh Bothe Post authorDecember 4, 2013 at 4:32 am
  
  Thanks Laxmikanta 🙂 .
  
  like (0)
Former Member December 4, 2013 at 6:11 am

Very informative. Thank you for sharing…

like (0)
1. Ganesh Bothe Post authorDecember 4, 2013 at 6:45 am
  
  Thanks Venkat 🙂 .
  
  like (0)
Former Member December 4, 2013 at 6:29 am

Nice Article

Thanks

like (0)
1. Ganesh Bothe Post authorDecember 4, 2013 at 6:45 am
  
  Thanks for your feedback 🙂 .
  
  like (0)
Former Member December 4, 2013 at 6:45 am

Pretty simple and gives an instant understanding 🙂

like (0)
1. Ganesh Bothe Post authorDecember 4, 2013 at 6:48 am
  
  Thanks Suman for your feedback 🙂 .
  
  like (0)
G.S Ramanjaneyulu December 4, 2013 at 7:36 am

simple and esy to follow

like (0)
1. Ganesh Bothe Post authorDecember 4, 2013 at 7:55 am
  
  Thanks G.S for Nice feedback 🙂 .
  
  like (0)
Former Member December 7, 2013 at 6:55 am

Good informative document.

Regards,

Utpal

like (0)
1. Ganesh Bothe Post authorJuly 16, 2015 at 10:12 am
  
  Thanks 🙂 .
  
  like (0)
Former Member December 8, 2013 at 4:26 pm

Good informative document.

like (0)
1. Ganesh Bothe Post authorDecember 8, 2013 at 5:41 pm
  
  Thanks varsha 🙂 .
  
  like (0)
Former Member December 8, 2013 at 7:34 pm

Once again come up with good concept keep going ganesh.. 😛

Regards,
Harish

like (0)
1. Ganesh Bothe Post authorDecember 9, 2013 at 4:18 am
  
  Thanks Harish for your feedback 🙂 .
  
  like (0)
Former Member January 22, 2014 at 11:30 am

Nice one,keep it up.

like (0)
1. Ganesh Bothe Post authorJanuary 23, 2014 at 5:46 am
  
  Hi Giri,
  
  Thanks for your feedback 🙂 .
  
  like (0)
Former Member January 23, 2014 at 5:51 am

Nice doc Ganesh. Thanks for sharing… 🙂

Regards,

poorna

like (0)
1. Ganesh Bothe Post authorJanuary 23, 2014 at 10:15 am
  
  Thanks poorna for your nice feedback 🙂 .
  
  like (0)
Former Member January 23, 2014 at 6:33 am

Hi Ganesh,

Nicely Formated Document. Thanks for Sharing…. 🙂

Regards,

Purushotham.

like (0)
Former Member January 23, 2014 at 10:22 am

Hi Ganesh,

its good one doc.

keep it up!!!! 🙂 🙂

Thanksfor sahring..

Regards,

Wasem

like (0)
Former Member January 23, 2014 at 11:39 am

Good One..

like (0)
1. Ganesh Bothe Post authorJanuary 24, 2014 at 5:00 am
  
  Thanks Reddy,waseem and kavitha for your feedback 🙂 .
  
  like (0)
Former Member January 30, 2014 at 7:29 am

Vey informative for the ones who haven’t used currency conversion. Nice work Ganesh. thank you for sharing 🙂

like (0)
1. Ganesh Bothe Post authorJanuary 30, 2014 at 1:06 pm
  
  Hi Yasemin,
  
  Thanks for your feedback 🙂 .
  
  like (0)
Kamalakar Madineni January 30, 2014 at 8:05 am

nice work,ganesh

good info ℹ ,

regards,

kamal

like (0)
1. Ganesh Bothe Post authorJanuary 31, 2014 at 6:53 am
  
  Thanks kamal 🙂 .
  
  like (0)
Former Member March 21, 2014 at 10:27 am

Good document 🙂 .

like (0)
1. Ganesh Bothe Post authorJuly 10, 2014 at 3:58 pm
  
  Thanks Saikat 🙂 .
  
  like (0)
Former Member July 10, 2014 at 6:04 am

Very useful information. Thanks Ganesh. 🙂

like (0)
1. Ganesh Bothe Post authorJuly 29, 2014 at 11:22 pm
  
  thanks
  
  like (0)
Former Member July 10, 2014 at 8:52 am

Learnt new one . Thanks Ganesh

like (0)
1. Ganesh Bothe Post authorJuly 11, 2014 at 6:54 am
  
  Hi Chandra,
  
  I am happy that you learnt from blog..thanks for your comment.
  
  like (0)
Former Member July 11, 2014 at 7:18 am

Good one 🙂

like (0)
1. Ganesh Bothe Post authorJuly 22, 2014 at 2:28 am
  
  Thanks Kavitha!
  
  like (0)
Former Member August 6, 2014 at 1:37 pm

Very useful information. Ganesh.

like (0)
1. Ganesh Bothe Post authorSeptember 22, 2014 at 10:08 am
  
  Thanks prabha 🙂 .
  
  like (0)
Former Member August 6, 2014 at 2:31 pm

Hi!, is a great doc. Thanks for sharing Ganesh!.

like (0)
1. Ganesh Bothe Post authorSeptember 15, 2014 at 6:03 am
  
  thanks for your feedback. 🙂 .
  
  like (0)
Former Member December 11, 2014 at 9:34 am

useful doc ganesh 🙂 .

like (0)
1. Ganesh Bothe Post authorDecember 16, 2014 at 4:56 am
  
  Thanks 🙂 .
  
  like (0)
Former Member February 10, 2015 at 7:10 am

Handy information. Thanks for sharing.

like (0)
1. Ganesh Bothe Post authorFebruary 11, 2015 at 5:53 am
  
  Hi Amit,
  
  Thanks for feedback 🙂 .
  
  like (0)
Former Member February 26, 2015 at 9:08 am

Useful Info Ganesh..

like (0)
1. Ganesh Bothe Post authorMarch 4, 2015 at 9:34 am
  
  Thanks jitendra!
  
  like (0)
HITESH GAVANDE March 24, 2016 at 11:37 pm

nice document Ganesh.. good work 🙂

like (0)
1. Ganesh Bothe Post authorMarch 28, 2016 at 11:53 pm
  
  Thanks Hitesh!.
  
  like (0)
Former Member September 27, 2017 at 5:50 am

Dear Ganesh, same thing I have applied in Key fig. but I am unable to convert the values MYR to BND in report output. if I ran report with out currency I can see MYR and BND values. if I enter BND in report selection I can see only BND values, but this MYR values not converted and missing in report.

Please advice.

Without Curr Selectionin variable:-

Calendar day LAND1 – Country Goods In Transit LC Val. Stck Value LC

01.06.2017 BN BN 0,00 BND 2.460.290,67 BND

MY MY 45.002,20 MYR 94.832.116,29 MYR

Result *

BND Selection in report variable:-

Calendar day LAND1 – Country Goods In Transit LC Val. Stck Value LC

01.06.2017 BN BN 0,00 BND 2.460.290,67 BND

Result 0,00 BND 2.460.290,67 BND

Thanks

vissu

like (0)
1. Ganesh Bothe Post authorOctober 25, 2017 at 10:46 pm
  
  Hi Vissu,
  
  MY to BND is updated in your tCURR table? Please check once.
  
  like (0)