SAP tables for the following asset fields

[Former Member]

Hi,

I have been trying to figure out SAp table for the follwing fieds of assets, but even there is no F! help available on the screen. Please help me with the table names:

APC FY start

Acquisition

Retirement

Transfer

Post-capital.

Invest.support

Current APC

Dep. FY start

Dep. for year

Dep.retir.

Dep.transfer

Dep.post-cap.

Write-ups

Accumul. dep.

Bk.val.FY strt

Curr.bk.val.

Thanks a lot in advance.

Regards,

Abhishek

[iklovski · Accepted solution]

Hi,

Transactions: ANEK/ANEP tables.

Total figures: ANLC

Regards,

Eli

[atif_farooq]

Dear:

Table relevant to your requirement will be

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)

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!)

• 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

Regards