Mapping the Currency Type and Currency Key

In contrast to R/3, the values of the individual posting periods and currency types (transaction currency, object currency, and controlling area currency) are extracted to SAP BW in individual data records rather than as a single block. The currency type (0CURTYPE) then indicates the fields of the R/3 totals records from which the values were read.

Currency Type	Description	Fields in R/3 Totals Record
00	Transaction currency	WTG*
10	Currency of company code (object currency)	WOG*
20	Controlling area currency	WKG*
70	Object currency	WOG*

Extraction therefore results in a maximum multiplication of the selected R/3 totals records by a factor of 48 = 3 * 16 = number of currency types * number of periods (12 + 4 special periods). Zero values (both the cost amount and the quantity are zero) are not transferred.

The quantities are transferred with each currency type. When defining queries, you must therefore also specify a restriction for quantity columns on a currency type. The simplest is to add the currency type as a filter parameter for the entire query.

Restricting the currency type to the values required in BW significantly improves performance during extraction.

Costs in object currency are transferred with currency type 10 as a default, regardless of whether selection in the InfoPackage is on currency type 70 or 10. If necessary, this default setting can be changed from 10 to 70 in the control table BWOM_SETTINGS (parameter OBJCURTYPE).

The currency key 0CURRENCY is determined based on the currency type:

Currency Type	Determination of Currency Key
00	Taken directly from the data record read (COSP-TWAER, COSS-TWAER etc.)
10	Determined from the object number of the record from the master data.
20	The controlling area is determined from the object number of the record read. The currency of the controlling area is then determined.
70	See currency type 10