Skip to Content

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

To report this post you need to login first.

64 Comments

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

  1. vissu marni

    Β 

    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

    Β 

    (0) 

Leave a Reply