how to do Currency conversion on Billing date in Bex query

[Former Member]

Hi All,

My scenario is have to do currency conversion to USD from transaction currency at Bex level using Billing date .

For each records there will be one billing date based on that date conversion should be done .  this can be done in back-end using function module . but it should required at Bex level . could please share your inputs how it could be done .

Thanks in advance

Srinivas

[Former Member · Accepted solution]

I got it . thank you

[Former Member]

You have the create a currency translation type (transaction RSCUR).

It's pretty simple to configure, for your requirement pay attention to the last tab 'Time reference'. Choose 'Variable Timereference' and select your billing date infoobject in 'special infoobject'.

This currency translation type can then be used in your query designer on the conversion tab of the desired KF