Currencies

[Former Member]

I have to create USD and EUR currency key figures and populate them via the value and translation (I have the KURST value) of local currency. Has someone done this and could they advise? Thanks

[edwin_harpino · Accepted solution]

hi Niten,

try convert in update rules with code or in query with steps in 'how to currency' ...

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING

DATE = COMM_STRUCTURE-[date for exchange rate]

FOREIGN_CURRENCY = 'USD'

LOCAL_AMOUNT = COMM_STRUCTURE-[your local currency keyfigure]

LOCAL_CURRENCY = COMM_STRUCTURE-[currency used]

IMPORTING

FOREIGN_AMOUNT = RESULT

EXCEPTIONS

NO_RATE_FOUND = 1

OVERFLOW = 2

NO_FACTORS_FOUND = 3

NO_SPREAD_FOUND = 4

DERIVED_2_TIMES = 5

OTHERS = 6.

IF SY-SUBRC <> 0.

RESULT = 0.

ENDIF.

or use other code as mentioned here

hope this helps.

[Former Member · Accepted solution]

Thanks for that, I like the FM 'CONVERT_TO_FOREIGN_CURRENCY'. Would you have the full title of the How to currency and will search on the web

[former_member188975 · Accepted solution]

Hi Niten,

See if these are useful:

How to use variables in currency conversion

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/287bab90-0201-0010-f48e-cc5...

How to use variable time reference in currency conversion

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/462fe790-0201-0010-3ca4-adf...

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a682de07211d2acb80000e829fbfe/content.htm

[Former Member · Accepted solution]

Thanks for that not able to open one of the links, but my ideal scenario is to write the logic in the UR. Hence if there is a How to guide for the FM that Edwin has mentioned that would be ideal

[former_member188975 · Accepted solution]

Hi Niten,

Not sure if there is an How to with the code, but if you look at the link posted by Edwin, it is directed to a thread where I have provided the complete code for curr conv in the update rules (I have used this code in numerous places)

[Former Member · Accepted solution]

thanks for that, will do and post questions otherwise if I have an issue. Have awarded points

[Former Member]

Hi,

You can maintain currency translation by transaction 'ob08'.

regards,

Pinaki