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