The three records to be transferred to the transaction data table should have the following structure:
Fisc. year |
Period |
Posting date |
Sales area |
Sales |
Currency |
1995 |
001 |
1/5/95 |
B3Z |
100 |
DEM |
1995 |
001 |
1/5/95 |
A3F |
200 |
DEM |
1995 |
002 |
2/7/95 |
27A |
200 |
DEM |
The records are to be posted in USD to the transaction data table, which does not contain the posting day as a characteristic. The following possibilities arise:
Example exchange rate is 0.7 USD/DEM.
The records in the transaction data table then appear as follows:
Fiscal year |
Period |
Sales area |
Sales |
1995 |
001 |
B3Z |
70 |
1995 |
001 |
A3F |
140 |
1995 |
002 |
27A |
140 |
Sales of 350 USD for fiscal year 1995 will be displayed in the drill- down report. You can calculate this from the inverse exchange rate
1 / (0.7 USD/DEM) = (1 DEM)/(0.7 USD)
and get the value
350 USD * (1 DEM)/(0.,7 USD) = 500 DEM
i.e. the original amount.
Note that, the reverse calculation always works if you have translated with an exchange rate unique to a specific date during the data transfer.
The example exchange rate for this is:
0.6 DEM/USD for 1/31/1995
0.8 DEM/USD for 2/28/1995.
The records in the transaction data table appear as follows:
Fiscal year |
Period |
Sales area |
Sales |
1995 |
001 |
B3Z |
60 |
1995 |
001 |
A3F |
120 |
1995 |
002 |
27A |
160 |
Sales of 340 USD for fiscal year 1995 are displayed in the drill- down report. If you chose the fiscal year and the period or, alternatively, the 7-digit Period 'yyyymmm' when defining the report, then you can also calculate the original amount from the inverse exchange rate. The drill down report works with the inverse period exchange rates
1 / (0.6 USD/DEM) = (1 DEM)/(0.6 USD) and
1 / (0.8 USD/DEM) = (1 DEM)/(0.8 USD)
and calculates the value
(60 USD + 120 USD) * (1 DEM) / (0.6 USD) + ( 160 USD) *
(1 DEM) / (0.8 USD) = 500 DEM,
i.e. the original amount.
Example exchange rates for this:
0.6 DEM/USD for 1/5/1995
0.8 DEM/USD for 1/9/1995
0.8 DEM/USD for 2/7/1995.
During data transfer the posting date will be ignored as this is not contained in the transaction data table as a characteristic. (see above)
The records in the data transfer table will then appear as follows:
Fiscal year |
Period |
Sales area |
Sales |
1995 |
001 |
B3Z |
60 |
1995 |
001 |
A3F |
160 |
1995 |
002 |
27A |
160 |
Sales of 380 USD for fiscal year 1995 are displayed in the drilldown report. You cannot calculate the original amount using the inverse exchange rate, as the information about the translation date was lost during the summarization over posting date.
You can calculate the original amount approximately by translating the amount using the mixed specific date exchange rates or period end exchange rates. The latter would provide the following result:
(60 USD + 160 USD) * (1 DEM) / (0.6 USD) + ( 160 USD) *
(1 DEM) / (0.8 USD) = 566.67 DEM
that is, not the original amount of 500 DEM.