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
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
In the CURRENCY tab, give the variable name (ZCURRANALYSIS) against the OPTION button TARGET CURRENCY FROM VARIABLE in TARGET CURRENCY
The variable ZCURRANALYSIS is defined as follows for the 0LOC_CURRENCY infoobject in query designer.
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
Now the currency translation type ZCALMON is available in the CONVERSION tab of key figure properties in query designer.