Exchange Rates for Currencies in a Flat
File 
Use
With this function you can upload translation rates for currencies from a flat file into table TCURR in your BW system. This is necessary if you did not connect your BW system to an R/3 System, so that the table cannot receive input from R/3.
If you have connected an R/3 system proceed as described here: Transferring Exchange Rates for Currencies from an R/3 System.
Prerequisites
Your flat file should have the following format (corresponds to table TCURR with the MANDT field):
|
Field |
Data Type |
Length |
Decimal Places |
Meaning |
|
KURST |
CHAR |
4 |
0 |
Exchange Rate Type |
|
FCURR |
CUKY |
5 |
0 |
From currency |
|
TCURR |
CUKY |
5 |
0 |
To currency |
|
GDATU |
CHAR |
8 |
0 |
Date when the rate will be valid |
|
UKURS |
DEC |
9 |
5 |
Exchange rate |
|
FFACT |
DEC |
9 |
0 |
Factor for the units of the From currency |
|
TFACT |
DEC |
9 |
0 |
Factor for the units of the To currency |
The date (field: GDATU) must be in internal format (YYYYMMDD).
The decimal point in the UKURS field must correspond to the settings selected in Customizing (BW Customizing Implementation Guide ® Business Information Warehouse ® Connections to other Systems ® Connection between Flat File and BW ® Setting Options for Uploading Flat Files).
Example for a table with periods as decimal points:
|
KURST |
FCURR |
TCURR |
GDATU |
UKURS |
FFACT |
TFACT |
|
M |
EUR |
USD |
20020101 |
1.00010 |
0 |
0 |
|
B |
EUR |
USD |
20020112 |
0.98300 |
0 |
0 |
Example for the structure of a csv file with ‘;’ as separator
B;EUR;USD;20020112;0.98300;0;0
See also:
Uploading Exchange Rates from Flat Files