Currency translation BW currency conversion

Difficult before learning, not difficult after learning.

I have read several PDF documents to explain my understanding.

If BW has a good connection with R3 in the early stage, we will not forget to create a global setting after creating the logic system. Of course, we will not forget to create a transfer exchange rate. this is to transmit the exchange rate updated on the R3 end to BW on a regular basis to make the exchange rate conversion of the BW report data more accurate. (Schedule can be periodically executed in the background)

This is the end. This is a basis for currency conversion in BW. Other problems are caused by settings. The rate here is base.

 

The following describes how to perform currency conversion on the BW end based on the SDN experience of its predecessors.

1. Currency translation type

A translation type is a combination of exchange rate, source and target currency and time reference for conversion which are used for currency translation.

A currency conversion type is a combination of exchange rate, source currency, target currency, and conversion time settings. That is to say, in a currency conversion type, the exchange rate, source currency, target currency, and conversion time are set. Then, this currency translation type is defined in the key figure in the query. Therefore, the currency translation type will be applied during query execution. That is, currency conversion.

T-CODE: rscur create currency translation type

Click Create icon.

Input the description.

Below, there are four tabs to define the currency translation type, they are:

1) Properties

2) Exchange Rate

3) Currency

4) Time ref.

 

I will perform strate onE by onE.

First, exchange rate.

This interface determines which exchange rate the currency translation type uses.

(1) Exchange rate type-select this option. Generally, we use M (standard translation at average rate)

(2) ex. Rate type from var.-If this parameter is selected, the exchange rate is dynamic during query execution. If this option is selected, you must set a variable for infoobject 0rtype.

(3) exchange rate from infoobj-this item specifically specifies the key figure containing this exchange rate. This is in daIt can be set during ta loading. In this case, the exchange rate comes from the key figure.

(4) Inverse ex. Rate-this is used to convert currencies at the opposite exchange rate. This is required if a value has been converted and you want to see its original value.

This tab ends here.

 

2) currncy
 


(1) Source currency from DATa record-the source currency depends on the data records in key figure when the query is executed.

(2) fixed source currency-the source currency is fixed.

(3) infoobject for determining source currency-specifies an infoojbect and uses currency as its attribute. This infoojbect is placed in the column in the query. Therefore, when the query is executed, the corresponding currency will be read Based on this infoobject. (For example, the country currency)

 

Target currency

(1) target currency selection with translation-you can select the target currency when starting the query. To achieve this, you need to set the variable in the conversion of key figure.

(2) The difference between target currency from variable-and (1) is that (2) You need to input the variable name here. Of course, you still need to specify the currency translation type and variable in conversion.

(3) infoobject for determining the target currency-this is the same as setting infoobject of source currency. You must specify currency as the attribute of infoobject.

"OnLy use in transformation "If infoojbect didn't have the corresponding currency as its attribute at the time, you can check this option. Of course, this infoobject must exist in daTa source, and you also need to specify currency as attribute in this infoobject.

 

Last tab-time reference

The reference time is divided into fixed reference time and variable reference time.

Fixed time ref-fixed reference time:

(1) Current date-the exchange rate used for the current day

(2) key date-the exchange rate used is the exchange rate of the date entered by the user

(3) time reference from variable-to set a variable for infoobject 0date, the exchange rate used is the date exchange rate specified in the query design.

(4) use query key date-the exchange rate of query key date is used here for conversion.

 

Variable time reference-variable reference time:

Select from the drop-down list.

 

Standard Info Object-attaches the time feature to the selected variable time reference. Available infoojbect: (one-to-one correspondence with the following infoobject)

Start/end fiscal year (0 fiscyear)

Start/end period (0 fiscper)

Start/end calendar year (0 calyear)

Start/end calendar year/quarter (0 calquarter)

Start/end month (0 calmonth)

End of week (0 calweek)

Exact days (0 calday)

 

Special info ojbect-If this option is selected, the following standard info ojbect is not used. This depends on the entry selected by the variable time reference .()

If variable time reference specifies exact days, the following infoobject is available:

Key figure of type date

Infoobject with reference characteristic 0 date

Infoobjects with basis Characteristic 0 calday

If variable time reference specifies another feature, infoobject and the corresponding basic feature are available.

 

Infoset-this seems to be mentioned in many places. Same as standard infoobject or special infoobject.

 

If the infoojbect selected as the time reference is unique in infoset, that is, it exists only once in the entire infoset, then you can enter this infoobject in standard infoojbect or special infoobject.

 

Infoset is required only when this infoobject occurs multiple times in infoset !!! (Here, I understand that if multiple infoproviders, such as cube and DSO Based on infoset, contain this infoobject, and this infoobject is used for time reference, select infoset here. However, if you only use it once, you do not need to use infoset .)

Bytes -----------------------------------------------------------------------------------------------------------------------------

OK. Now, how to set the currency translation type is finished.

The following describes the entire process of currency translation.

1) Use infoobject to define target currencies

2) Currency translation in business Explorer

3) Currency translation during transformation

 

 

 

1) Use infoobject to define target currencies

A. Create an infoobject with primary data, such as a country, and specify 0currency as its attribute. (This infoobject is used to determine the target currency to use.) and, in the business explorer tab, enter 0currency to currency attribute.

 

B. Create a new currency translation type in rscur, and under the currncy tab, select infoobject for determining target currency in target currency, (enter infoobject name), flag use in transformation onLy.

C. Create a query. Use the infoobject as the rows of the query. In key figure's "Conversion tab", select the currency translation type created in B.

In this way, the currency is converted into a country-based target currency.

 

 

 

2) Currency translation in business Explorer

 

There are two types.

1. Set it in design query. Currency translation in query definition.

2. Set it in the query in execution. Currency translation in the executed query.

 

 

1. Set it in design query.

You can specify the currency translation type in the individual key figure or struture element. Target currency, but fixed can also be a selection variable.

 

(1) fixed target currency

A. Create currency translation type (fixed target currency, current date)

B. In query designer, specify the currency translation type in a in key figure "Conversion.

In this way, target currency is fixed.

 

(2) target currency by using a selection variable

There are two methods.

I variable in the currency translation type.

II variable in properties of the keyfigure in Bex.

 

I

A. Create a variable for 0currency. (processing by: manual input/default value; reference characteristic 0 currency; variable represents: single value; ready for input: checked)

B. Create a currency translation type, use the variable as target currency. (target currency from variable)

C. query designer, key figure uses currency translation type in B.

In this way, the variable "input target currency" is required to appear during query execution.

II

A. Create a currency translation type (target currency selection with translation), and select the required exchange rate and time ref ..

B. query designer, key figure specifies the currency translation type in.

C. Select create new variable next to the field "target currency. You will see the newly created variable in the target currency field.

In this way, the variable of the target currency is required when the query is executed. (Same as I)

 

 

2. Set it in the query in execution. Currency translation in the executed query.

See the figure.

 

 

3) Currency translation during transformation

 


OK. The currency conversion is complete. There is also a unit, to be continued.