Show TOC

Exchange Rates for Currencies in Flat FilesLocate this document in the navigation structure

Use

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:

Transferring Exchange Rates for Currencies from SAP Systems

Prerequisites

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 Start of the navigation path SAP NetWeaver Next navigation step Business Information Warehouse Next navigation step Connections to Other Systems Next navigation step Connection Between Flat File and BW Next navigation step Setting Options for Uploading Flat Files End of the navigation path).

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