BPS Currency Translation with rate from previous year

[Former Member]

Dear All,

I am trying to use the BPS currency translation function. However, I would like to use an exchange rate from the previous fiscal year, in order to reveal currency effects.

I would appreciate any help, hopefully regarding ways to mend the standard function. I am afraid a workaround with the FM CONVERT_TO_LOCAL_CURRENCY would end up in a giant crutch.

Thank you in advance,

Lars Biederstedt

[former_member93896 · Accepted solution]

Hello Lars,

a few options:

1) Upgrade to SAP NetWeaver 2004s. You can then use FOX to do the currency conversion.

2) Use a fixed date in the parameter group

3) Copy the exchange rates to a different exchange rate type and change the dates of the rate (+one year)

Regards

Marc

SAP NetWeaver RIG

[Former Member · Accepted solution]

Thank you for your answer, Marc.

I would definitely like to know more about option 1.

Option 2, a fixed data, would not work, because data had to be translated monthly, with the exchange rate from exactly one year ago. I was really surprised, that you could not enter a variable as a time reference and use offsets, like you can in queries.

I ended up using an Exit-Function with the function module convert_to_foreign_currency. Unfortunately you cannot change characteristic values with Exit-Function, so I have to repost after every currency translation.

Anyway, it works.

Best regards,

Lars

cundus AG