Currency Conversion Based on User Input

October 28, 2013 | 89 Views |

Ganesh Bothe

BW (SAP Business Warehouse)

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.

62 Comments

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

Nilesh Shete 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)
Bharat suryavanshi 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)
Aditya Sai 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)
Satendra Mishra 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)
varsha amritkar 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)
Raman Korrapati 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)
Laxmikant Verma 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)
Venkateswarlu Ravula 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)
kushal thakral 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)
Suman Chakravarthy K 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)
U Sethi 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)
varsha amritkar 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)
Harish Allachervu 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)
Giri Prasad 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)
Poornachandra Anjaneya 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)
Purushothama Reddy January 23, 2014 at 6:33 am

Hi Ganesh,

Nicely Formated Document. Thanks for Sharing…. 🙂

Regards,

Purushotham.

like (0)
Wasem Hassan January 23, 2014 at 10:22 am

Hi Ganesh,

its good one doc.

keep it up!!!! 🙂 🙂

Thanksfor sahring..

Regards,

Wasem

like (0)
Kavitha A 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)
Yasemin ULUTURK 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)
Saikat Pal 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)
Prasad Deshpande 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)
chandra kaliki 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)
Kavitha A 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)
Prabha S 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)
Francisco Rodríguez 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)
Vaijanath Gambhire 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)
Amit Sharma 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)
Jitendra Gupta 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)