Uploading Exchange Rates from Flat Files 

Procedure

...

       1.      In the Data Warehousing Workbench under Modeling, choose the source system tree.

       2.      In the context menu of your source system (for example PC_FILE), choose Transfer Exchange Rates. The Transfer Exchange Rates: Selection screen appears.

       3.      Select where you want to load your file from. You differentiate between files that are on the application server and files that are on client workstations. Select your file and specify the separator that is being used. Only CSV files are allowed as the file type.

       4.      Under Mode you can select whether you want to simulate upload or update or copy the exchange rates. With the Update exchange rates option, existing records are updated. With the Recopy exchange rates option, table TCURR is deleted before new records are loaded.

After the data has been uploaded from the CSV file, the OLAP caches are invalidated so that the system uses the new exchange rates during translation.

       5.      Choose   Execute.

If the CSV file contains exchange rate types that do not exist in the BI system (table TCURV), this will be noted in the log. Entries are displayed as follows: exchange rate type &cv1 not in TCURV table. The data from the CSV file is then written to the TCURR table. The missing entries for TCURV can be maintained manually in the IMG (SAP Customizing Implementation Guide → SAP NetWeaver SAP Business Information Warehouse → General Settings  → Currencies→ Check Exchange Rate Types).