You use this function to upload exchange rates for currencies into table TCURR in your BW system from a flat file. This is necessary if your BW system is not connected to an SAP system and the table cannot receive input from an SAP system.
If your BW system is connected to an SAP system, proceed as described in:
Your flat file should have the following format (corresponds to table TCURR without CLIENT 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 character in the UKURS field has to correspond to the settings selected in Customizing (SAP Customizing Implementation Guide
).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 structure of a CSV file with ';' as separator: M;EUR;USD;20020101;1.00010;0;0
B;EUR;USD;20020112;0.98300;0;0
See also: