Sales and procurement business foreign currency exchange rate handling

The multi-currency feature of SAP is a major selling point. The SAP butcher has written several articles about the exchange rate. Unfortunately, I am not a financial engineer. I don't know much about it. The following only lists the exchange rate issues I have encountered about the mm and SD modules.

1. Currency:
Local currency, company code currency, account currency, price currency, document currency, posting currency, group currency, parallel currency, and so on. No.

2. Exchange rate is the Conversion Relationship between different currencies. The business module involves currency and exchange rate, such as the pricing currency at the time of pricing, the document currency in the document, the accounting currency for financial accounting, and the standard currency set by the company. Their relationships are as follows:

• Pricing: the conversion from pricing currency to document currency;
• Transfer Time: the conversion from the document currency to the standard currency;
• Pay-as-you-go: the conversion from payment currency to standard currency;

3. In extreme cases, there may be a business scenario where the sales or procurement business is priced in US dollars, orders are signed in euros, financial accounting is conducted in the standard currency pound, and payment is made in RMB. The foreign currency exchange rate conversion is required for each two steps.

4. There are multiple types of conversions between different currencies, such as the purchase exchange rate, sell exchange rate, and intermediate exchange rate,
SAP
Define it as the exchange rate type. Exchange rate type
Ob07
Maintenance.
SAP
The medium MM and SD modules mainly involve the following exchange rate types:

• Types of exchange rates used in the Euro Zone
  Euro
  ;
• Exchange rate between the euro zone and the euro zone
  Eurx
  ;
• 
  Average type used by other regular companies
  M
  ;
  

5. The M type is used for financial accounting. Unless an alternative type is set in obbs, the conversion between currencies described above reads the exchange rate value by M. The exchange rate value exists in the table tcurr and is maintained using ob08.

6. SAP
In
SD
In the design, users are allowed to maintain the exchange rate type in the customer master data. The path is
Sales area data à sales à exch. Rate type
, The field is
KNVV-KURST
. The customer's orders and subsequent invoicing will read the exchange rate based on the manually maintained exchange rate type. If the field is not maintained, the system uses the exchange rate type.
M
, Standard procedure
Lv69af18
Hard-coded.

7. There is a sales order title accounting view
Exch. Rate-Acct.
Field (
VBKD-KURRF
), If maintained, it will be referenced in the invoice (
VBRK-KURRF
As the exchange rate type for invoice accounting. Note: The exchange rate type in the invoice cannot be modified. It is only for order reference. If it is not maintained, the exchange rate type must also be used.
M
. Another exchange rate (
VBKD-KURSK
) Is used to convert the exchange rate from the pricing currency to the document currency. When manually modifying the Order's document currency, this exchange rate will refer to the customer's exchange rate type, pricing date from
Tcurr
The read rate is the default value. Manually modified values take precedence over the default value.

8. Inventory increase/decrease
Gr
,
Gi
Bookkeeping uses the standard currency, and there is no exchange rate conversion problem between currencies. The accounting value adopts the cost price (moving average or standard price ).

9. There are two fields related to the exchange rate in the invoice.
6
Point-to-Point header Exchange Rate
VBRK-KURRF
It is only used for financial accounting, that is, the total amount of invoices is converted to the base currency based on this exchange rate, and then the financial creden。 are recorded in this number. The other is the row project exchange rate.
VBRP-KURSK
This is the exchange rate conversion used for the pricing conditions, that is, the conversion from the price currency to the invoice currency (the document currency can be manually set.
VBRP-KURSK
The source is controlled by the copy relationship from the document to the invoice. The specific field is
TVCPFLP-PFKUR
.
TVCPFLP-PFKUR
Optional fields include:

• A-copy from sales order
• B-price exchange rate = accouting Rate
• C-exchange rate determination according to billing date
• D-exchange rate determination according to pricing date
• E-exchange rate determination according to current date
• F-exchange rate determination according to date of services rendered

For example, if you select
B
, The exchange rate of the row item is directly copied from the raised exchange rate (
VBRK-KURRF
).

10. The exchange rate conversion in pricing is the conversion from the price currency to the document currency. The conversion exchange rate is stored in
KOMV-KKURS
It always reads the exchange rate based on the price date as the condition.

11. Exchange Rate Table
Tcurr
Yes
Client
Level, not related to company code. The read parameters include the exchange rate type, local currency, foreign currency, date, and conversion factor (one-to-one or one hundred-to-one ). Program
Lscunuxx
It contains several exchange rate calculation functions, which can be used for programming:

• Include lscunu01. "calculate_exchange_rate
• Include lscunu02. "convert_to_foreign_currency
• Include lscunu03. "convert_to_local_currency
• Include lscunu04. "read_exchange_rate
• Include lscunu05. "read_notation
• Include lscunu06. "kurs_in_mengennotation
• Include lscunu07. "kurs_in_preisnotation

12. Manually intervene in the price conversion in the enhancement.
Rv61afzb
:
Userexit_xkomv_bewerten_init
. Here we can intercept the exchange rate conversion during the change of the pricing currency. After testing, the sales order, sales invoicing, purchase order, and purchase receipt actions will all go into this enhancement. Available variables include:
[X] kmov
,
[X] komp
,
[X] komk
.

13,
Mm
The vendor in the module is not similar
SD
Design and settings.
Po
Head up
Delivery/invoice
View Maintenance
Po
Currency and
Po
The exchange rate between the currency and the standard currency. At the same time, the exchange rate can be fixed. Normally, it will be used as the exchange rate at the time of receipt. If the manually modified exchange rate value matches
Ob08
The exchange rate values are different.
Gr
(
Ides
The default accounting subject is
Foreign Currency Revaluation losses
And
Income from price differences of own goods
), The difference is the new exchange rate minus the default exchange rate value multiplied by the number and then the default exchange rate (the direct exchange rate is used for multiplication, and the indirect exchange rate is used for Division ).
The manual exchange rate is different from the default exchange rate and the manual exchange rate.

14. You can raise your ticket when purchasing the ticket
Details
The view manually specifies the exchange rate, provided that
Po
Not in
Fix
Exchange rate. To manually specify the exchange rate at Miro, you must
Enter the exchange rate first and then
Po
Number. Otherwise, the exchange rate is gray.

15
When you clear your account, you can
Currency/rate
Manually input the field to intervene in the foreign currency exchange rate. The premise is that the default exchange rate is not specified for the company code settings.