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.
Good Job Ganesh.
Thanks for your feedback 🙂 .
Good job.
Thanks Bharat 🙂
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
Thanks aditya for your feedback 🙂 .I will check your thread and let you know.
Nice information ……….. 🙂
Good Job.
regards,
Sm
Thanks you satendra 🙂 .
Good one and great job. Thanks for sharing.
Keep it up. 🙂
Regards,
Krishna Chaitanya.
Thanks krishna 🙂 .
Good Job.
Thanks Varsha 🙂 .
Really useful information. thanks for sharing
Thanks raman for your feedback 🙂 .
Hi ganesh,
Nice information.
Thanks Laxmikanta 🙂 .
Very informative. Thank you for sharing…
Thanks Venkat 🙂 .
Nice Article
Thanks
Thanks for your feedback 🙂 .
Pretty simple and gives an instant understanding 🙂
Thanks Suman for your feedback 🙂 .
simple and esy to follow
Thanks G.S for Nice feedback 🙂 .
Good informative document.
Regards,
Utpal
Thanks 🙂 .
Good informative document.
Thanks varsha 🙂 .
Once again come up with good concept keep going ganesh.. 😛
Regards,
Harish
Thanks Harish for your feedback 🙂 .
Nice one,keep it up.
Hi Giri,
Thanks for your feedback 🙂 .
Nice doc Ganesh. Thanks for sharing… 🙂
Regards,
poorna
Thanks poorna for your nice feedback 🙂 .
Hi Ganesh,
Nicely Formated Document. Thanks for Sharing…. 🙂
Regards,
Purushotham.
Hi Ganesh,
its good one doc.
keep it up!!!! 🙂 🙂
Thanksfor sahring..
Regards,
Wasem
Good One..
Thanks Reddy,waseem and kavitha for your feedback 🙂 .
Vey informative for the ones who haven’t used currency conversion. Nice work Ganesh. thank you for sharing 🙂
Hi Yasemin,
Thanks for your feedback 🙂 .
nice work,ganesh
good info ℹ ,
regards,
kamal
Thanks kamal 🙂 .
Good document 🙂 .
Thanks Saikat 🙂 .
Very useful information. Thanks Ganesh. 🙂
thanks
Learnt new one . Thanks Ganesh
Hi Chandra,
I am happy that you learnt from blog..thanks for your comment.
Good one 🙂
Thanks Kavitha!
Very useful information. Ganesh.
Thanks prabha 🙂 .
Hi!, is a great doc. Thanks for sharing Ganesh!.
thanks for your feedback. 🙂 .
useful doc ganesh 🙂 .
Thanks 🙂 .
Handy information. Thanks for sharing.
Hi Amit,
Thanks for feedback 🙂 .
Useful Info Ganesh..
Thanks jitendra!
nice document Ganesh.. good work 🙂
Thanks Hitesh!.
Â
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:-
BND Selection in report variable:-
Thanks
vissu
Â
Hi Vissu,
MY to BND is updated in your  tCURR table? Please check once.