cancel
Showing results for 
Search instead for 
Did you mean: 

Table name asset depreciation values

Former Member
0 Kudos

Hello Gurus,

What is the table name for getting depreciaton values like ordinary depreciation and special depreciation which are appearing in AW01N transaction. I want to generate a report so pls tell me the table name.

regds

Ramachandra

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

A while back I was trying to create an asset report with asset balances but was unsuccessful in finding a summary asset balance table. Because I was creating the report with SAP query, using tables such as ANEP and ANEK yields the following problems:

o Multi lines per asset because various depreciation years (I only need one line - net book value - per asset)

o Fully depreciated assets that do not have depreciation in the current year will not get selected in the report (I want all assets per selection parameters)

I found a document u201CHow to Add Fields to Any Fixed Asset Reportu201D written by Nathan Genez. I use AR01 as it has the field Net Book Value that meets my report requirements. All I did was to add other fields, for example fields defined in ANLC, to the existing reporting structure of AR01. This is much easier than trying to create a new report.

Hope this helps.

Former Member
0 Kudos

Hi

The Dep. value is stored in table . ANLC

ANLC-KNAFA this is for accumulated dep.

for total all accumulated dep. you have add all below fields in table anlc.

ANLC-KNAFA +ANLC-KSAFA ANLC-KAAFA ANLC-NAFAP+ANLC-AAFAM

Thanks,

kali

former_member182098
Active Contributor
0 Kudos

Hello,

Try with tables

ANEP

ANEA

ANEK

Alternatively through Quick Viewer you create query. User logical data base ADA

Regards,

Ravi

Edited by: Ravi Sankar Venna on Apr 8, 2009 5:05 PM