How to…

Upload Currency Exchange Rates from a Flat File

BUSINESS INFORMATION WAREHOUSE

ASAP “How to…” Paper

Applicable Releases: BW 2.0B, 2.1C

May 2001

SAP (SAP America, Inc. and SAP AG) assumes no responsibility for errors or omissions in these materials.

These materials are provided “as is” without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.

SAP shall not be liable for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials.

SAP does not warrant the accuracy or completeness of the information, text, graphics, links or other items contained within these materials. SAP has no control over the information that you may access through the use of hot links contained in these materials and does not endorse your use of third party web pages nor provide any warranty whatsoever relating to third party web pages.

HOW TO … UPLOAD CURRENCY EXCHANGE RATES FROM A FLAT FILE

1 Business Scenario

The main financial accounting system in the company is not an R/3 system. This means that currency exchange rates have to be loaded form a flat file.

2 The Result

The conversion rates that are loaded from the file are found in SAP BW in the TCURR table.

3 The Step-By-Step Solution

3.1 File Structure

The file must have the same structure as the TCURR table (apart from the MANDT field) meaning that the fields must be arranged in the following order:

Exchange Rate Type

From Currency

To Currency

Valid From Date

Exchange Rate

Ratio (from)

Ratio (to)

2001 SAP AMERICA, INC. AND SAP AG 1

HOW TO … UPLOAD CURRENCY EXCHANGE RATES FROM A FLAT FILE

3.2 Important Information on the File Structure

1. The last two fields are optional. The ratios are stored in the TCURR table, but are never read from this location. Instead, the ratios are always read from the TCURF table. If they have not been maintained already, the ratios must also be maintained for the currency conversion rates that are loaded from the file. You maintain the ratios in the Customizing IMG (transaction SPRO, see right). You can maintain the ratios after the file has been loaded, if you so wish.

2. In the file, the exchange rate types must begin with leading zeros if you use a numeric exchange rate type (e.g. 001 and not 1) .

The validity date must be in the YYYYMMDD format. The user settings for the date format in the system, do not apply in this case.

You must use “.” as the decimal point.

2001 SAP AMERICA, INC. AND SAP AG 2

HOW TO … UPLOAD CURRENCY EXCHANGE RATES FROM A FLAT FILE

3.3 Uploading the File

1. Go into the Administrator Workbench to the source system overview, and select a file system. The Transfer Exchange Rates option is found in the context menu.

2. You click on the Transfer Exchange Rates option to get to the screen (displayed on the right) where you specify the location of the file that you want to load. There is an option allowing you to simulate the upload first, and two options for actually loading the file into BW:

Update: The records contained in the file are updated in the TCURR table.

Transfer: The entries in the TCURR table are deleted, and replaced by the entries from the file. If you use this option, once the upload is complete, the TCURR table contains only entries from the file.

2001 SAP AMERICA, INC. AND SAP AG 3