Add Exchange rate type to Selection Screen in BEx

[Former Member]

BW Experts,

Business raised a request to add Exchange Rate Type(KURST) from TCURR table in the selection screen of BEx so that they can select the required rate and target currency for a particular key figure.

In Query Designer we can provide variable for currency by going into the context menu of key figure but not sure how to provide a variable on Currency Conversion Key.

Please suggest.

Thanks in advance.

-Bobby.

[Former Member · Accepted solution]

Hi there,

You can create a variable for exchange rate type in RSCUR transaction, for a conversion type that you can affect in the BEx query designer for particular key figures.

Therefore when a user executes the query for those key figures that have the currency type defined over RSCUR transaction they will also have a variable for exchange rate type.

Diogo.

[Former Member · Accepted solution]

Diogo,

Thanks for quick response. This variable is showing all curr rate types from TCURR. BEx users are interested to see a small subset of that. Is there any way to accomplish this?

Thanks,

Bobby.

[Former Member · Accepted solution]

Hi there,

You could with user exit define a variable ready for imput but in step 1 prefill the variable with only those values, but this would still when the user executes when pressing F4 be able to check all that. Nevertheless that variable would be prefilled with the values you wish in user exit.

Another option is to mark 0RTYPE in RSD1 as authorization relevant and manage different authorization values for the users. This way you could when the user presses F4 see only values he/she is authorized.

Diogo.