AFAB Dynamic Variant for Posting Period and Fiscal Year

(ECC 6.0 SP16)

Scenario:
User would like to have the current month depreciation posting run executed on ME-4 every month. Example: Month end is 30 Sept 2022. Therefore, depreciation should be executed on 26 Sept 2022.

Issue:
Fiscal Year and Posting Period does not have the dynamic calculation option when saving a variant.

Workaround solution:
Utilize standard SAP program RVSETDAT. This program updates both table TVARV and TVARVC for the following variables:
i. RV_ACTUAL_DATE – Updates current system date. Eg. 20220930
ii. RV_ACTUAL_MONTH – Updates month based on current system date. Eg. 09
iii. RV_ACTUAL_YEAR – Updates year based on current system date. Eg. 2022

Steps as follows:

1. By default, the variables above are not maintained in TVARVC. Therefore, create the variables above in TVARVC via t-code STARV under “Parameter” tab.
   
   
   
2. Save AFAB variant with Fiscal Year and Posting Period field as follows:
   
   
   
   
3. Schedule a job with the following steps:
   
   Step 1
   Execute program RVSETDAT.
   This would update the values in table TVARVC.
   
   
   Step 2
   Execute program RAPOST2000 with the variant saved in Step #2 above.
   Fiscal Year and Posting Period is derived from TVARVC:
   

Summary:
If the above solution does not work for some reason, create a Z program based on RVSETDAT logic with Z variable to suit your requirement.

Example 1
Fiscal Year is not calendar year ie. fiscal year for calendar year 2022 is 2023.

1. Create a Z program based on RVSETDAT logic
2. Derive Fiscal Year with own logic ie. get year from current system date and +1

Example 2
Schedule job to be executed on 2nd working day for the depreciation of the previous month.

1. Create a Z program based on RVSETDAT logic
2. Derive Posting Period with own logic ie. get month from current system date and -1

Retire Multiple Assets in SAP

I can suggest you an easy way of retiring multiple assets.

1. Use AR01 (Asset balances report)

2. Enter the assets to be disposed off and execute.

3. Click on “Create Worklist” (Edit-> Worklist-> Create).

4. Enter a name and click your selection.

5. In the next screen, enter the data as you would in ABAVN. Once you click on [Enter] button a work queue number will be created.

6. Go to AR31, use the work queue number and execute it. Release worklist and refresh it
till it is completed.

IMPORTANT: Try this in a test environment before you do it in Production.

Activate Group Assets in SAP

Step 1
IMG: Financial Accounting > Asset Accounting > Valuation > Group Assets > Specify Dep Areas for Group Assets

Transaction Code : OAYM

Here we specify the Dep area relevant for Group Assets.
Select each company code and select depreciation area relevant for group assets.

Step 2
IMG: Financial Accounting > Asset Accounting > Valuation > Group Assets > Specify Asset classes for Group Assets

Transaction Code : OAAX

Here we specify the asset classes relevant for Group Assets.

Impairment to Fixed Assets

http://scn.sap.com/thread/2145267

Please refer SAP Note 1144500

(This is for revaluation of fixed assets with reference to SORP requirements in UK relating to public sector undertakings)

You will find the configuration document here. You may use this as a guide.

You have three types of revaluation:

1) Upward revaluation
2) Downward revaluation not below historic cost
3) Downward revaluation below historic cost

Usually in cases 2 and 3, you are going to impair the asset. Impairment is nothing but “Unplanned Depreciation” in SAP Terminology. SAP may not completely support the accounting requirements for unplanned depreciation. There is no other go.

For example, if you have made impairment during the fiscal year, that impairment value will be ignored by SAP for calculating the ordinary depreciation for the remaining months of that particular year. Therefore, you would see the difference between system posted ordinary depreciation and expected to be posted depreciation.

However, at the beginning of the next fiscal year, the system will take into consideration the amount of “Impairment / Unplanned Depreciation” and the ordinary depreciation amount gets adjusted accordingly.

Example:

Asset is purchased on 01.01.2012 (Fiscal Year Variant Calendar Year) with value of $120,000 for 10 years life. (120 months)

Depreciated for 4 months – so the depreciation until April is $4,000 ($1000 per month)

Let us say, now you posted an impairment on 01.05.2012 an Unplanned Depreciation (Impairment) of $20,000

Still the system would compute the depreciation of $1000 per month from May to December (it will not take into consideration the amount of $20,000 unplanned depreciation).

Please note this is standard system behaviour, it is not possible to get the correct amount of depreciation. You would usually expect the depreciation of $800 ($120,000-$4,000 $20,000 / 116 months) = $ 800. But, that is not the case with system, it would still calculate $1,000 for that year.

You would expect the depreciation of $6,400 from May to December (800 * 8 months), but system has deducted $8000 (1000 * 8 months). Now the difference is $1,600. That means to this extent the system as excessively deducted.

Therefore, the system will nullify this affect from the next year which is 01.01.2013 by depreciating $ 814.81 instead of $ 800.

Difference between $ 814.81 and $ 800 is $14.81 which is nothing but $1,600 / 108 months (from 01.01.2013 to end of life of the asset).