Main Database Tables in Asset Accounting


Tables For Postings

Postings in Asset Accounting create or modifies entries in the following tables:

  • ANEK (Document Header Asset Posting)
  • ANEP (Asset Line Items)
  • ANEA (Proportional Values: mostly for retirements and retiring transfers)
  • ANLC (asset values summarized on area and year level)
  • ANLB (only for the very first posting on the asset; table is updated)
  • ANLA (aquisition date, deactivation date, origin)

Fields of Posting Tables

The most important fields are explained in the following slides:
The following fields belong to the tables ANEP, ANEA, ANEK:

  • BUKRS: company code
  • ANLN1: asset main number
  • ANLN2: asset sub number
  • GJAHR: fiscal year
  • LNRAN: number of the asset line item

Table ANEK

The following important fields belong to table ANEK:

  • CPUDT, CPUTM: System date of posting
  • TCODE: Transaction code, which was used for posting
  • ANLU1, ANLU2: Asset number of acquired/retired asset for transfer or intercompany transfers
  • BELNR: document number (FI or reference number)
  • AWTYP, AWORG, AWSYS: fields which are the unique link to the corresponding FI document.

Table ANEP

Table ANEP consists of the following important fields:

  • AFABE: depreciation area
  • BELNR: document number (or reference number)
  • BWASL: transaction type
  • ANBTR: APC amount of the posting
  • NAFAB, SAFAB, ZINSB: ordinary, special depreciation, interest on transaction (not valid anymore for the new depreciation engine!)
  • XANTW: indicator, that proportional values exists (XANTW = X, if there are entries in table ANEA)
  • LNSAN: line item number of the reversal document
  • AUGLN: number of the clearing line items (is set by the AuC settlement)

Table ANEA

Table ANEA is filled if proportional values/value adjustments have to be considered, e.g. for retirements and transfers.
In table ANEP field XANTW is set to X
The following important fields are part of table ANEA:

  • AFABE: depreciation area
  • NAFAV, SAFAV, AAFAV: proportional value adjustments of previous fiscal years
  • NAFAL, SAFAL, AAFAL: proportional value adjustments of current fiscal year

Table ANLC

In table ANLC the sum of all asset values are listed per asset, depreciation area and fiscal year :

  • BUKRS: company code
  • ANLN1, ANLN2 : asset number
  • GJAHR: fiscal year
  • AFABE: depreciation area
  • KANSW: accumulated APC values
  • KNAFA, KSAFA, KAAFA: accumulated ordinary, special, unplanned depreciation

Further fields of table ANLC per company code, asset, depreciation area, fiscal year:

  • NAFAP, SAFAP, AAFAP: Planned ordinary, special, unplanned depreciation of the current fiscal year
  • NAFAG, SAFAG, AAFAG: Posted ordinary, special, unplanned depreciation of the current fiscal year
  • ANSWL: sum of all the changes of the APC value
  • NAFAV, SAFAV, AAFAV: Proportional depreciation of previous years
  • NAFAL, SAFAL, AAFAL: Proportional depreciation of the current fiscal year

2 thoughts on “Main Database Tables in Asset Accounting”

  1. Hi,

    I want get the data for valu adjustment in sap bi report,
    for value adjustment in asset explorer report in sep ecc which table i need to look, how to get the data for this field.

  2. Hi

    On account of transition to Ind AS, we need the asset history sheet in such a manner that the WDV on 31st March, 2015 will be reported as Opening gross blocked of 1st April 2015.

Leave a Comment