Loading exchange rates from flat files

[Former Member]

We need to load at least two sets of exchange rates from flat files, and then use these exchange rates in the queries using currency conversion keys.

Where can I find information on the format of these files? I suppose the file needs information on both the 'from' currency, the 'to' currency, exchange rate and date/period, but I have so far not succeeded in creating a working test file.

We are using BW 3.5.

[edwin_harpino · Accepted solution]

hi,

take a look 'how to upload currency exchange rate from flat file ' (id requiered).

https://websmp201.sap-ag.de/~sapdownload/011000358700002766032003E/HowToUpldCurrencyFlatFile.pdf

if you do not have id, let's know your email, can send you. hope this helps.

[edwin_harpino · Accepted solution]

hi,

the file only contains 4 pages :

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)

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.

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.