Skip to Content
Author's profile photo Ganesh Bothe

Currency Conversion Based on User Input

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

/wp-content/uploads/2013/10/1_309553.jpg

Step  2

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

/wp-content/uploads/2013/10/2_309581.jpg

Step 3

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

/wp-content/uploads/2013/10/3_309582.jpg

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

/wp-content/uploads/2013/10/4_309583.jpg

Step 5

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

/wp-content/uploads/2013/10/5_309584.jpg

Assigned Tags

      64 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Job Ganesh.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks for your feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Good job.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Bharat 🙂

      Author's profile photo Aditya Sai
      Aditya Sai

      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

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks aditya for your feedback 🙂 .I will check your thread and let you know.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information ........... 🙂

      Good Job.

      regards,

      Sm

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks you satendra 🙂 .

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one and great job.  Thanks for sharing.

      Keep it up. 🙂

      Regards,

      Krishna Chaitanya.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks krishna 🙂 .

      Author's profile photo Former Member
      Former Member

      Good Job.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Varsha 🙂 .

      Author's profile photo CH Raman
      CH Raman

      Really useful information. thanks for sharing

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks raman for your feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Hi ganesh,

      Nice information.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Laxmikanta 🙂 .

      Author's profile photo Former Member
      Former Member

      Very informative. Thank you for sharing...

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Venkat 🙂 .

      Author's profile photo Former Member
      Former Member

      Nice Article

      Thanks

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks for your feedback 🙂 .

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Pretty simple and gives an instant understanding 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Suman for your feedback 🙂 .

      Author's profile photo G.S Ramanjaneyulu
      G.S Ramanjaneyulu

      simple and esy to follow

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks G.S for Nice feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Good informative document.

      Regards,

      Utpal

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks 🙂 .

      Author's profile photo Former Member
      Former Member

      Good informative document.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks varsha 🙂 .

      Author's profile photo Harish Allachervu
      Harish Allachervu

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

      Regards,
      Harish

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Harish for your feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Nice one,keep it up.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Hi Giri,

      Thanks for your feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Nice doc Ganesh. Thanks for sharing... 🙂

      Regards,

      poorna

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks poorna for your nice feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Hi Ganesh,

      Nicely Formated Document. Thanks for Sharing.... 🙂

      Regards,

      Purushotham.

      Author's profile photo Wasem Hassan
      Wasem Hassan

      Hi Ganesh,

      its good one doc.

      keep it up!!!! 🙂 🙂

      Thanksfor sahring..

      Regards,

      Wasem

      Author's profile photo Former Member
      Former Member

      Good One..

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Reddy,waseem and kavitha for your feedback 🙂 .

      Author's profile photo Former Member
      Former Member

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

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Hi Yasemin,

      Thanks for your feedback 🙂 .

      Author's profile photo Kamalakar Madineni
      Kamalakar Madineni

      nice work,ganesh

      good info ℹ ,

      regards,

      kamal

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks kamal 🙂 .

      Author's profile photo Former Member
      Former Member

      Good document 🙂 .

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Saikat 🙂 .

      Author's profile photo Prasad Deshpande
      Prasad Deshpande

      Very useful information. Thanks Ganesh. 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      thanks

      Author's profile photo Former Member
      Former Member

      Learnt new one . Thanks Ganesh

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Hi Chandra,

      I am happy that you learnt from blog..thanks for your comment.

      Author's profile photo Former Member
      Former Member

      Good one 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Kavitha!

      Author's profile photo Former Member
      Former Member

      Very useful information. Ganesh.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks prabha 🙂 .

      Author's profile photo Former Member
      Former Member

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

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      thanks for your feedback. 🙂 .

      Author's profile photo Former Member
      Former Member

      useful doc ganesh 🙂 .

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks 🙂 .

      Author's profile photo Amit Sharma
      Amit Sharma

      Handy information. Thanks for sharing.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Hi Amit,

      Thanks for feedback 🙂 .

      Author's profile photo Former Member
      Former Member

      Useful Info Ganesh..

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks jitendra!

      Author's profile photo HITESH GAVANDE
      HITESH GAVANDE

      nice document Ganesh.. good work 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

      Thanks Hitesh!.

      Author's profile photo Former Member
      Former Member

       

      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

       

      Author's profile photo Ganesh Bothe
      Ganesh Bothe
      Blog Post Author

       

      Hi Vissu,

      MY to BND is updated in your  tCURR table? Please check once.