You use this function to upload exchange rates for currencies into table TCURR in your BI system from a flat file. This is necessary if your BI system is not connected to an SAP system and the table cannot receive input from an SAP system.
If your BI system is connected to an SAP system, proceed as described in:
Transferring Exchange Rates for Currencies from SAP Systems
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 → SAP NetWeaver → Business Information Warehouse → Connections to Other Systems → Connection Between Flat File and BI → 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
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:
Uploading Exchange Rates from Flat Files