Forex Table updation

[Former Member]

Hi

Please advise me the procedure to update the forex table everyday. That means shall we have to update everyday as and when exchange rate is get changed or we can change the rate and date everyday.

Thanks and Best Regards

Shekhar

Edited by: Shekhar Yecham on Sep 16, 2008 8:40 PM

[jaybanda2]

HI there,....

Uploading Exchange Rates from Flat Files

Procedure

...

1. Choose the source system tree in the Administrator Workbench under Modeling.

2. In your source system (for example PC_FILE), choose Transfer exchange rates in the context menu. You get to the screen Transfer Translation Exchange Rate: Selection.

3. Select the place from which you wish to load your file. You differentiate between files that are on the application server and files that are on client workstations. Select your file and specify the separator to be used. Only csv files are allowed as file type.

4. Under Mode you can select if you only want to simulate the upload or if you want to update or copy the exchange rates. Existing records are updated with the Update exchange rates option. Table TCURR is first deleted and new records are then loaded with the Recopy exchange rates option.

After uploading the data from the csv file, the OLAP caches are invalidated so that the new exchange rates are used for translation.

5. Choose Execute.

If the csv file contains exchange rate types that are not present in the BW system (Table TCURV), this will be noted in the log. The entries appear as follows: exchange rate type &cv1 not in TCURV table. The data from the csv file are then written in the TCURR table. The missing entries for the TCURV can be maintained manually in IMG (BW Customizing Implementation Guide ® General Settings ® Currencies ® Check Exchange Rate Types).

http://help.sap.com/saphelp_nw04/helpdata/en/36/412ae30cb511d5b2df0050da4c74dc/content.htm

hope this helps you..

jay