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

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.