Application of exchange rate variables in report

Abstract: This article describes how to implement multiple typesExchange rate conversionAnd how to achieve exchange rate conversion in multiple time periods.

Involved T-CODE: rrc1, rrc2, rrc3

You may be familiar with this function when using exchange rate conversion in report. However, as the number of projects increases significantly and the degree of improvement, some personalized requirements emerge. For example, during this time, I encountered several problems that have special requirements on the exchange rate, and found related solutions through understanding the query and exchange rate variables.

Let me describe the problem first.

Question 1: dwhd should make an actual forecast table. Actual data adopts the current standard exchange rate, but forecast data uses the exchange rate provided by the user, because the provided exchange rate is for the future period, it may be inconsistent with the actual exchange rate or cannot be requested, so we hope ourReportsTo meet such functional requirements.

Question 2: The mm section needs to add the amount of the previous month in a report to compare with the data of this month, and the exchange rate should be converted according to the actual month.

Before solving the problem, we need to know a few knowledge points.

1. Currency conversion type:CurrencyConversion type, that is, rules for currency conversion. Currency conversion involves several key issues: A. Exchange rate B. Source currency C. Target currency D. Exchange rate time

2. Currency conversion key: the encoding of the currency conversion type.

3. target currency variable: if the target c currency is set to "SEL. of targ. currency with translation, you can set the target currency variable in the report, allowing users to change the target currency

 

After analyzing the above two problems, we can roughly Attribute Problem 1 to how to achieve multi-currency conversion, and question 2 to how to implement multi-time conversion.

After the above analysis, let's take a look at it one by one.

First, in the query, each key figure can convert the exchange rate as long as it is the amount field. If it is not the amount field, the "calculated key figure" (ckf) or "restricted key figure" (rkf) can also achieve exchange rate conversion. Therefore, ckf or rkf can be used to convert multiple exchange rates of a key figure. For example, set amount and "actual" to rkf "actual data", and set amount and "forecast" to rkf "forecast data ", then we can set two exchange rate conversion types. In fact, this knowledge point can solve problem 1. In addition, the user has a special note that forecast has its own set of exchange rates, so we must take this situation into consideration. Of course, the method is also very simple. We are setting exchange
It is necessary to customize some types to distinguish the standard "M" type.

 

Problem 2 may focus on switching the exchange rate to the previous month (or not the current month ). Let's take a look at the content in Section 1 that sets the D exchange rate conversion time.

1. fixed time ref. (fixed time)

I. Current date (current system time)

II. Key date (set a value)

Iii. Time Based from variable (set the time variable, which must be placed under the calendar)

2. Variable time ref. (Change Time)

I. Standard infoobject (Standard Time object in the current report)

Ii. Special infoobject (processing objects that are not accurate to the day, such as 0 fiscper)

In case of II, a specific time point is required.

3. query key date

By listing the above attributes, We can find two solutions

1. Use 1-III to set a time variable so that you can flexibly obtain the time.

2. Use 3. because the report does not actually use the key date, you can use the key date to pass the time.

After the final trade-offs, we chose solution 1 because it is more reasonable and professional. At the same time, you only need to set the time variable type to "customer exit", you can useCodeTo set the time.

Lei 20090831