微信搜索公众号:SAP中文学习网交流平台      SAP技术千人群: SAP中文学习网技术群      SAP技术交流2群:SAP技术交流2群      SAP新人群:SAP中文学习网新人群     

SAP中文学习网

应用COPA获利能力分析模块时,有没有被汇率计算弄晕过?来看看这

来源: 互联网TAG标签: sap fico 作者:SAP中文学习网-Summer 点击:
 
Skip to end of metadata
 
Go to start of metadata
 

Purpose

You create an Invoice in SD (Sales and Distribution), system posts correct exchange rate in FI (Financials) but the exchange rate does not match in COPA (Controlling Profitability Analysis). This Wiki explains how system calculates exchange rate in COPA and how you should check this in system.

Overview

It is not clear how system determines a different exchange rate compared to SD and FI.  It is expected that exchange rate remains same across SD, FI and COPA. However the exchange rate calculation works in a different way than in other modules. Hence minor exchange rate difference can be expected. For dealing with these minor differences Note 106094 can referred.

Explanation of system behavior

Pre-Conditions

According to SAP Note 429517 system checks for the following pre-conditions before calculation of exchange rate in COPA -

  • Condition category - Statistical / Non-Statistical
  • Currency - Operating Concern Currency / Company Code Currency / Transaction Currency
  • Exchange rate Date for translation in billing document - VBRK-KURRF DAT

Exchange Rate Determination

As explained above, system uses the above conditions to determine the exchange rates in COPA. As explained in SAP Note: 429517 there are different ways COPA calculates the exchange rate depending upon the currencies. For example -

Translation for statistical conditions and for follow-up posting of billing documents into the Profitability Analysis (KE4S) -

1.  Determination of the value in operating concern currency

    a) Transaction currency = operating concern currency

       There is no translation. The value of the transaction currency is copied.

    b) Transaction currency = company code currency <> operating concern
       currency

       Translation from transaction currency into operating concern currency with exchange rate type 'M'.

    c) Three different currencies

       If the exchange rate for translation into company code currency in the billing document (VBRK-KURRF) does not differ from the exchange rate of type 'M', the system translates transaction currency of type 'M' directly into the operating concern currency. Otherwise it translates with VBRK-KURRF into company code currency and then from the just determined value with exchange rate type 'M' into operating concern currency.

2.  Determination of the value in company code currency (provided the update of company code currency is activated in CO-PA)

    a) Transaction currency = company code currency

       There is no translation. The value of the transaction currency is copied.

    b) Transaction currency < > company code currency

       If no exchange rate was fixed on the billing document (VBRK-KURRF), the system translates from transaction currency with exchange rate type 'M' into company code currency. Otherwise it translates with VBRK-KURRF into company code currency.

Exchange Rate Determination in Case of KE21N

When a COPA document is created with transaction KE21N, the leading ledger is always the operating concern currency.

we convert from operating concern currency to company code currency by inversing the original rate that was used. However since we store only 2 decimal places during the conversion there will be rounding differences. This is an issue specially when Company code and Document currency are same. Let's discuss this behavior with an example -

Sales Order - 1234

Document currency - CZK

Company Code Currency - CZK

Operating Concern currency - USD

Exchange rate - 20.391

Condition Value - 192390.15

When a COPA document is created with reference to Sales order 1234, the conversion takes place as below -

The condition value will be converted to USD from CZK using exchange rate /20.391

192390.15 / 20.391 = 9435.052228924526

However since only 2 decimal places are stored we store 9435.05 USD

When you convert back to CZK 9435.05 X 20.391 = 192390.10

If you do 9435.052228924526 x 20.391 = 192390.15

As mentioned above we convert from operating concern currency to company code currency by inversing the original rate that was use and since only 2 decimal places are considered, rounding differences are inevitable

This is standard system behavior and will not be changed.

Conclusion

 To verify whether the exchange rate used is correct, transaction EWCT can be used. The date field in Transaction EWCT should contain the value VBRK-KURRF DAT as shown in the illustration below.

In this transaction the correct exchange rate available according to the exchange rate date can be found and compared to the exchange rate posted in COPA document. However we must consider that there can be minor difference due to the difference in the way exchange rate is calculated in SD, FI and COPA.


(编辑:cindy liu )
顶一下
(2)
40%
踩一下
(3)
60%
------分隔线----------------------------
您有可能感兴趣的文章