Depreciation Rate List

[Former Member]

Please tell me the T codes for Depreciation rates as per the Depreciation methods in SAP. We want to find the list of depreciation against the fixed assets and what is the percentage.

[Former Member · Accepted solution]

I need to know clearly every asset and the linked depreciation rates to it as per depreciation areas. This list doesnot serve the purpose.

[Former Member · Accepted solution]

Hi Vicky,

As I mentioned, please use tcode SQ01 to create query,use tables:

ANLA Asset Master Record Segment

ANLB Depreciation terms

T090NAZ Depreciation Keys - Method Assignment

T090ND Declining-Balance Method

T090NS Multilevel Method

Find the key fields and set relationship between tables.

Julie

[Former Member]

Please suggest me the table for the asset location, bill date and bill no., depreciation rate, gross block, depreciation for the fiscal year, accumulated depreciation and net block. All these are part of the asset register report.

[narasimhulu_konnipati]

Check the tables

ANLA, ANLB, ANLC, ANLZ, ANEP, and ANLP

This ANLA to ANLZ are the tables which are used for Asset Accounting

Search through SE16N

Reports

AR01, AR02 and AR03..........

Create / Change the output layout as you want.

Thanks

[Former Member]

Dear Vicky,

We don't have the standard tcode to list Dep Method with Dep rate as you want.

You can find information you want by going to tcode SE16N and enter these tables:

T090NAZ Depreciation Keys - Method Assignment

T090ND Declining-Balance Method

T090NS Multilevel Method

If you want to customize transaction code, please create query (tcode SQ01) to extract data from follow tables.

Hope it helpful.

Julie

[narasimhulu_konnipati]

You can find all the depreciation keys with percentages in AFAMS.

Thanks,

Narasimhulu