Blog

/
18Apr2014

Currency in SAP – Fixed Assets

  • By espouseadmin
  • 1 Tags
  • 0 Comments

Currency in Fixed Asset Accounting is a recurring topic of misunderstandings. The following explanations usually apply to all postings to Fixed Assets.  In individual cases, deeper integration may cause differences in postings from FI, or there are advanced options for intervening in the process.

1. Transaction currency

In Financial Accounting, you can enter a business transaction in any currency. In addition to the local currencies, the business transaction is also updated in this transaction currency. In Asset Accounting, the system ignores the transaction currency. From Asset Accounting transactions (for example, ABZON, ABUMN, ABAVN, …), it is not possible to use a transaction currency that differs from the local currency. Usually, the local currency and the transaction currency are used.

 

2. Local currency

With local currency SAP means the currency in which a company code is managed. In Fixed Asset Accounting, areas posting in real time (technically: T093-BUHBKT = 1) are always managed in local currency.

3. Parallel currency / parallel local currency

Parallel currencies are also known as the second and third local currency.

In Financial Accounting, you can manage a company code in up to two additional local currency types (for example, group currency, index-based currency or hard currency). The currencies of the additional local currency types do not have to differ. For example, you could manage local currency, group currency and hard currency in the same currency unit (such as USD).

For each additional local currency in Asset Accounting, you have to manage a separate area in this parallel local currency for each area posting in realtime. This normally applies to the master area (area 01).

For parallel currencies, you can set the translation type. You can choose whether the system translates to the parallel currency from the underlying transaction currency or from the local currency. You can also set the exchange rate type to be used and the determination of the translation date.

4. Foreign currency

Asset Accounting defines foreign currency as a currency in which an area is managed, and, which fulfills the following conditions:

-The currency used does not match the (first) local currency and

-the area, which is managed in this currency, is not set as a parallel currency area (technically: T093A-CURTP is initial).

Foreign currency areas, in contrast to parallel currencies, are not usually translated from the transaction currency directly.

An exception displays transaction FB01 and its partner transactions, in which it is possible, thanks to deep integration with Asset Accounting, to supply the foreign currency areas with values during document entry. If the transaction currency is identical to the currency of a foreign currency area, the amount is transferred without later being translated using the local currency. You can also enter the foreign currency amount manually when you enter the document.

There is no option to make settings for translation from the transaction currency in the same way as for the parallel currency areas.

The system usually translates from the values in the reference area for value transfer.

5. Problem cases

In practice, using different currencies often results in problems with comprehension. This section describes phenomena common in Asset Accounting, and explains the system response using examples.

a) Rounding differences

You use a parallel currency area and a foreign currency amount in the same currency (for example, both are in EUR). The local currency is managed in USD. The parallel currency is set so that the value is translated directly from the transaction currency.

Example: You post a document (for example, an invoice receipt using transaction MIRO) in an alternative transaction currency (Example: 79.84 GBP).

The exchange rates are as follows:

 

  • 100 GBP = 135 USD
  • 100 USD = 80 EUR
  • 100 GBP = 108 EUR

You receive the following result:

 

Local currency amount (= 01 in USD):    107.78 USD (= 79.84 * 1.35)

Parallel currency area (in EUR):                86.23 EUR (= 79.84 * 1.08)

Foreign currency area (in EUR):               86.22 EUR (= 107.78 * 0.80)

The differing result between the parallel currency area and the foreign currency area can be attributed to the differing currency translation type. The system translates the foreign currency area from the local currency value. Rounding differences may occur.

b) Rounding differences when transaction currency and foreign currency are the same

A special case in the previous example would be to make the posting with EUR as the transaction currency instead of GBP. The transaction currency would thus be the same as the parallel currency and the foreign currency.

In this constellation, you would expect the values for the areas with the same currency to be transferred identically from the transaction currency. However, this is the case for the parallel areas only, which are translated from the transaction currency. In all other cases, the translation is first to the local currency, then to the area currency. 100.00 USD in the transaction currency may therefore become 100.01 USD in the foreign currency area.

For this special case, SAP offers a modification, which ensures the value is transferred identically from the transaction currency for foreign currency areas, provided that these contain the same currency. If you are interested in obtaining this modification, contact SAP Support with reference to this note. SAP Development will then provide you with this modification.

c) Unexpected values in the foreign currency area

When you make a posting from Logistics, it may not be possible to explain the values in the transaction currency and local currency that result from a currency translation. An extreme case would be a posting with the transaction currency amount 0.00 but an alternative amount in the local currency. Example: Transaction currency 0.00 EUR and local currency amount 1000.00 USD.

The system responds as described before, even with constellations of this type. This may lead to differences between areas with the same currency but different currency translation types. For the numerical example above, the following scenario arises:

Local currency area (in USD): 1000.00 USD

Parallel currency area (in EUR): 0.00 EUR (from transaction currency)

Foreign currency area (in EUR): 800.00 EUR (from local currency)

B. Configuration of Currency in FI – GL & Fixed Asset Accounting:

1. Currency Set up for Company Code and Ledger

 

FA1

If you have older version of SAP then you can activate this by using corresponding menu path or T code OB22.

Group currency needs to be maintained in client definition (T Code SCC4), which normally Basis team does.

Exchange Rate Type for local Currency is hard coded in the system as M for all the Local Currency. Sap has also provided some standard solution to use alternative exchange rate type for EUR to other currency translation and vise versa. See the below screen shot.

FA2

( to find where to define to default)

We can assign exchange rate type in document type.

2. Define Depreciation Areas for Foreign Currencies

 

In this step define Currency for each Depreciation Area for a Company Code

Select the Company Code and Click on the Depreciation Area Currency.

Specify currency in which you depreciation Area will get value.

3. Specify the Use of Parallel Currencies

 

 

If we activated Parallel currency at company code level then we need to maintain parallel

currency Depreciation Area for each depreciation Area for which depreciation will be posted. Here Depreciation Area and corresponding parallel currency depreciation area should be identical in all respect. There is some exception that parallel currency depreciation area will be a derived Area and its currency will be your Group or other parallel currency.

We need to specify the following

Currency Type : Group Currency;

Depreciation Area to adopt APC value;

Depreciation Area to adopt Depreciation term;

Identical Indicator for both APC and Depreciation term.

 

After defining all the above, we need to activate Parallel currency view in the following screen- T Code OABT.

Please copy the parallel currency Area from Area 30 only else there will some inconsistency in asset accounting with reference to Parallel currency. You may expect the following two types of error message while saving your configuration as well as posting your asset transaction.

We need to maintain identical APC and Depreciation term using T. codes OABC: Dep. Area :Rule for takeover of APC value and OABD: Dep. Area :Rule for takeover of Depreciation term. If you will try to maintain and save using transaction OABT then errpr message “Table TABWA is not part of the Customizing object VV_T093A_CURTPV” will be populated without saving data.

 

 

C. Error resolution for the Parallel Currency:

Error :

1. Table TABWA is not part of the Customizing object VV_T093A_CURTPV and

2. Parallel currency area (currency type 30) missing for area 01
Message no. ACC_AA047.

 

Follow step by step configuration in Asset Accounting as follows to avoid inconsistency in the Asset Accounting: (Step by Step FI –FA Organizational Structure and other Configuration covered in Fixed Asset & SAP System Document).

a)     Create Chart of Depreciation

b)     Create/Delete Depreciation Area:

–        Copy Non Leading Area from Area 01 (if you use Non Leading Ledger to post depreciation)

–        Copy Parallel Currency Depreciation Area from Area 30

c)     Assign COD to Company Code

d)     Specify Allowed Depreciation for Dep. Area

OABN: Ordinary Depreciation

OABS: Special Depreciation

OABU: Unplanned Depreciation

OABM: Transfer of Reserve

OABZ: Interest Posting

OABX: Investment Support

OABW: Revaluation/Management of replacement

 

e)     Define How depreciation are post to GL

SPRO: Define Depreciation Area

OADC: Depreciation Area Type

OABC: Dep. Area :Rule for takeover of APC value

OABD: Dep. Area :Rule for takeover of Depreciation term

OAYH: Depreciation Area Currency

OABT: Set up Parallel Currency – This is the last step for Depciation Area Configuration.

CATEGORIES Fixed Assets SAP

COMMENTS

Leave a Reply

Your email address will not be published. Required fields are marked *