Show TOC

Uploading Exchange Rates from Flat FilesLocate this document in the navigation structure

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.

    Note

    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. 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 ( Start of the navigation path SAP Customizing Implementation Guide Next navigation step SAP NetWeaver SAP Business Information Warehouse Next navigation step General Settings Next navigation step Currencies Next navigation step Check Exchange Rate Types End of the navigation path).