Skip to Content

SAP Path

SAP Easy Access à SAP Menu à Accounting à Financial Accounting à Fixed Assets à Information System à Depreciation Forecast à Depreciation on Capitalized Assets (Depreciation Simulation)

SAP Transaction Code

S_ALR_87012936

Introduction

This report gives the depreciation simulation for future years by asset wise. There are also options in order to get the depreciation on monthly, quarterly and yearly basis. The is very useful report for the teams working in Fixed Assets area in order to report the simulated depreciation figures for future number of years.

Enter Selection Parameters

/wp-content/uploads/2012/09/1_133981.png

Field Name Description
Company Code Company in which the report is required to be executed
Report Date Last working day of the future year
Display Variant Select 1_SAP_1_LINE (which is more convenient for output display)
Summary Report Optional – Select this box only if intend to display the balances for Summary per asset class

Click on  “Explode” button in order to expand the selection screen details.

/wp-content/uploads/2012/09/2_133982.png

Field Name Description
List Assets This will show the list of details by asset
Evaluation Period This will evaluation the simulation by period

Click on Execute Button

/wp-content/uploads/2012/09/3_133983.png

However, the above report showing the output data without columns optimized and limited up to few years.

/wp-content/uploads/2012/09/4_133984.png

From the menu bar, select: Settings à Optimize Column Width

/wp-content/uploads/2012/09/5_133985.png

The above report is now showing with column with optimized. However, still the depreciation simulation up to 2020 is not included in the report.

Now, we need to change our layout in order to bring those fields into the report.

Change the Layout (Ctrl+F8)

/wp-content/uploads/2012/09/6_133986.png

/wp-content/uploads/2012/09/7_133987.png

/wp-content/uploads/2012/09/8a_133988.png

Now the proposed depreciation values for the future years are available in the report. Please note that this report not only brings the depreciation values, it can also bring the APC values and Net Book Values for the future years. However, the layout needs to be accordingly changed and include the fields that required to be shown in the output for reporting purpose. 

To report this post you need to login first.

32 Comments

You must be Logged on to comment or reply to a post.

  1. Ranu Eugene

    HI Ravi,

    As always very useful document by you.

    Thanks for sharing and do keep educating us.

    Keep up the good Work. 🙂

    Best of Luck. 🙂

    Regards

    Eugene

    (0) 
  2. v s

    Dear Ravi,

    Really it is nice document.

    Please suggest if I want the forecasting Segment wise then hwo it can be taken.

    Regards,

    Vinay

    (0) 
  3. Ganesh K.B.

    Hi Ravi,

    Nice document.  Many of us would have known the simulation point.  But the more important and helpful tips were the optimization of columns and adding the additional periods through change layout which many of us would not have known.

    Regards,

    (0) 
  4. Agnes Ye

    Hi Ravi,

       You document is really helpful.Thanks for your sharing.

    Can you tell me how to define years in the report, i did not find in hidden fields.

    Thanks & Regards

    Ag

    (0) 
      1. Agnes Ye

        Is that mean i need to add fields to the report by ABAP?

        When I choose “Financial Year”,change layout, the hidden field just have one year. eg: Report date:12/31/2014 , then i change layout ,only have Year 2014 .

        Or something wrong with my entry?

        Thank you for your reply.

        Ag.

        (0) 
        1. Ravi Sankar Venna Post author

          Now, I got it what you mean by.

          You do not need to any abap work.

          The reason for you are seeing only one year is, you should give the report date as your closing date of fiscal year in 2018 or 2019 or 2020, then you would get the values for the future years.

          Please enter the future report date in your selection (initial screen).

          Hope this helps you.

          Kind Regards,

          Ravi

          (0) 
      2. putri putri

        Hi Ravi,
        I have one asset with aquisition date=start depreciation date on 31.12.2016. Asset usefull life=3 years
        I got depreciation for fiscal year 2016=243228
        I tried to have simulation for fiscal year 2017-2018.
        But why the depreciation amount is zero in the future year?
        Kindly advice.
        Thank you in advance

        (0) 
  5. Prakash Kumar

    Hi Ravi !

    Thanks for sharing this document !

    Is there any to add 18 months in the simulation report, currently it shows maximum 12 months.

    Regards,

    Prakash K.

    (0) 

Leave a Reply