I have a flat file with transaction data in different currencies.
So I need to convert the data into USD based on the exchange rates
defined in the table TCURR. In the Table TCURR, we maintain the daily
rates. I got to take the posting dates as a base date in the file
to get the corresponding date exchange rates from TCURR. Use this exchange
rates in the Update rules to convert the Keyfigures to USD...
I guess we need a start routine where in we get all the unique dates in the file
and then read the table TCURR to get the exchange rates for all the dates in
the data package(file) and store them in a internal table.
use this internal table in the individual routines for the Keyfigures in
the Update rules to calculate the conversions.
Please help me with the code.
Im loading data to ODS.
you can use the function modules CONVERT_TO_LOCAL_CURRENCY or CONVERT_TO_STAT_CURRENCY in your update rule to get your amount converted.