Skip to Content
avatar image
Former Member

Table name asset depreciation values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 08, 2009 at 04:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2009 at 04:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2009 at 09:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2016 at 09:22 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded