Skip to Content
Author's profile photo Ravi Sankar Venna

How to view depreciation simulation for future number of years

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. 

Assigned Tags

      33 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Prasad Tatikonda
      Prasad Tatikonda

      Hi Ravi,

      Nice document with good examples.

      Regards,

      Prasad

      Author's profile photo Former Member
      Former Member

      Very Informative...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Naresh.

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Mr. Ravi,

      congratulatios for your article.

      Transaction AR18 is similar.

      Author's profile photo Former Member
      Former Member

      Good One Ravi.. 🙂

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Kiran.

      Author's profile photo Vinod Vemuru
      Vinod Vemuru

      Very useful T-code Ravi 🙂

      Author's profile photo Former Member
      Former Member

      Dear Ravi,

      Good Document.. its helpful.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Sekhar. 🙂

      Author's profile photo sreehari tokala
      sreehari tokala

      Thank you Very Much Ravi sir, your the asset of the SDN. it's very help full to me. Thank you for giving your efforts.

      Regards,

      sreehari.

      Author's profile photo Diwa p
      Diwa p

      thank you so much ravi. very informative and useful document.

      Regards

      Diwa

      Author's profile photo CA. Prasad Atmakuri
      CA. Prasad Atmakuri

      Thanks for very informative document Ravi 🙂

      Regards

      Prasad

      Author's profile photo Ranu Eugene
      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Eugene, much appreciated your comments. 🙂

      Kind Regards,

      Ravi

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Thank you for valueable information.

      Wish you a nice and relaxing weekend.

      all the best erwin 🙂

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Erwin, wish you the same.

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Very good document.

      Thank you.

      Author's profile photo Former Member
      Former Member

      Useful Doc Mr.Ravi

      Author's profile photo v s
      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

      Author's profile photo Former Member
      Former Member

      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,

      Author's profile photo Basappa Allannavar
      Basappa Allannavar

      Hello Ravi,

      Very nice Document.

      Regards,

      Basappa

      Author's profile photo Sattaiah Gundu
      Sattaiah Gundu

      Hi Ravi,

      Really very nice document

      Thanks & Regards

      Sattaiah Gundu

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Please change your layout, you would find number of fields you can bring into the report.

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog 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

      Author's profile photo Former Member
      Former Member

      OK ,I got it .

      Thanks for your help,Ravi.

      Kind Regards,

      Ag

      Author's profile photo putri putri
      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

      Author's profile photo Former Member
      Former Member

      Nice example and notes. Impressed.

      Author's profile photo Former Member
      Former Member

      Nice Document with examples...

      Author's profile photo Former Member
      Former Member

      Hi,

      Nice document. Thanks for sharing your knowledge.

      Regards

      Karthi

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo VIVEK JOSHI
      VIVEK JOSHI

      Hi Ravi,

       

      Can we get depreciation forecast monthly?