Fixed Asset Register with Book and Tax Depreciation Report
Short answer: A custom ALV report that shows every fixed asset on one row with acquisition cost, accumulated depreciation, depreciation of the year and net book value for two chosen depreciation areas (e.g. statutory book and tax). Cost center, asset class and capitalization date are on the list as well, and the difference between the two areas is calculated in its own column.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
AW01N shows one asset with all its areas but gives no mass list. The standard asset balance and asset history reports cover one depreciation area per run; to see book and tax values side by side the report is run twice and merged in Excel. Deferred tax calculation and the audit need the per-asset difference between the two areas in one list.
Who uses it? Fixed asset accountants, tax teams, financial controllers and finance teams preparing for the external audit.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| ANLAAsset Master Record | Asset master record: description, class, capitalization and deactivation date (driving table) | — | ECC + S/4 |
| ANLZTime-Dependent Asset Allocations | Time-dependent assignment: cost center, plant, profit center | ANLZ-BUKRS = ANLA-BUKRS AND ANLZ-ANLN1 = ANLA-ANLN1 AND ANLZ-ANLN2 = ANLA-ANLN2 | ECC + S/4 |
| ANLBDepreciation Terms | Depreciation key and useful life per area | ANLB-BUKRS = ANLA-BUKRS AND ANLB-ANLN1 = ANLA-ANLN1 AND ANLB-ANLN2 = ANLA-ANLN2 AND ANLB-AFABE IN (P_AFAB1, P_AFAB2) | ECC + S/4 |
| ANLCAsset Value Fields | Cost, accumulated and current-year depreciation values per year and area | ANLC-BUKRS = ANLA-BUKRS AND ANLC-ANLN1 = ANLA-ANLN1 AND ANLC-ANLN2 = ANLA-ANLN2 AND ANLC-GJAHR = P_GJAHR | ECC + S/4 |
| T001Company Codes | Company code currency | T001-BUKRS = ANLA-BUKRS | ECC + S/4 |
| I_FixedAssetForLedgerFixed Asset for Ledger | Asset master data per ledger on S/4HANA | CompanyCode = ANLA-BUKRS AND MasterFixedAsset = ANLA-ANLN1 AND FixedAsset = ANLA-ANLN2 | S/4HANA only |
S/4HANA notes
- ANLC → ACDOCA: In S/4HANA new asset accounting the actual values are kept in ACDOCA; ANLC is only read through the compatibility view FAAV_ANLC.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | ANLA-BUKRS | Yes | 1000 |
| S_ANLKL | Asset class | Range / multiple | ANLA-ANLKL | No | 3000 |
| S_ANLN1 | Main asset number | Range / multiple | ANLA-ANLN1 | No | 300012 |
| S_KOSTL | Cost center | Range / multiple | ANLZ-KOSTL | No | 4110 |
| P_GJAHR | Fiscal year | Single value | ANLC-GJAHR | Yes | 2026 |
| P_AFAB1 | Depreciation area 1 (book) | Single value | ANLC-AFABE | Yes | 01 |
| P_AFAB2 | Depreciation area 2 (tax) | Single value | ANLC-AFABE | Yes | 15 |
| P_DEAKT | Also show assets retired during the year | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Asset | ANLA-ANLN1 |
| 2 | Sub-number | ANLA-ANLN2 |
| 3 | Asset description | ANLA-TXT50 |
| 4 | Asset class | ANLA-ANLKL |
| 5 | Capitalization date | ANLA-AKTIV |
| 6 | Cost center | ANLZ-KOSTL |
| 7 | Depreciation key (area 1) | ANLB-AFASL |
| 8 | Useful life (years) | ANLB-NDJAR |
| 9 | Acquisition cost | Calculated ANLC-KANSW + ANLC-ANSWL for area 1 |
| 10 | Depreciation of the year (book) | Calculated ANLC-NAFAG (+ AAFAG) for area 1 |
| 11 | Accumulated depreciation (book) | Calculated ANLC-KNAFA + KAAFA + NAFAG + AAFAG for area 1 |
| 12 | Net book value (book) | Calculated Acquisition cost − accumulated depreciation (area 1) |
| 13 | Net book value (tax) | Calculated The same calculation for area 2 |
| 14 | Difference (book − tax) | Calculated Net book value (book) − net book value (tax) |
| 15 | Currency | T001-WAERS |
Sample output
| Asset | Sub-number | Asset description | Asset class | Capitalization date | Cost center | Depreciation key (area 1) | Useful life (years) | Acquisition cost | Depreciation of the year (book) | Accumulated depreciation (book) | Net book value (book) | Net book value (tax) | Difference (book − tax) | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 300012 | 0 | Hydraulic press 250 t | 3000 | 03/15/2023 | 4110 | LINS | 10 | 1,200,000 | 120,000 | 450,000 | 750,000 | 600,000 | 150,000 | TRY |
| 300047 | 0 | CNC lathe | 3000 | 06/01/2025 | 4120 | LINS | 8 | 860,000 | 107,500 | 161,250 | 698,750 | 645,000 | 53,750 | TRY |
| 400008 | 0 | Forklift 3 t | 4000 | 09/10/2024 | 4300 | LINS | 5 | 540,000 | 108,000 | 243,000 | 297,000 | 216,000 | 81,000 | TRY |
| 500021 | 1 | Server upgrade | 5000 | 02/20/2026 | 9100 | LINS | 4 | 310,000 | 64,583 | 64,583 | 245,417 | 232,500 | 12,917 | TRY |
How does the report work?
- Assets are read from ANLA by company code, asset class and asset range; unless P_DEAKT is set, assets with a deactivation date (DEAKT) are skipped.
- The time-dependent assignment valid at the end of the report year (cost center, plant, profit center) is taken from ANLZ: ANLZ-BDATU ≥ year end.
- The depreciation key (AFASL), useful life (NDJAR/NDPER) and depreciation start date (AFABG) are added from ANLB for both areas.
- Values for the report year and both areas are read from ANLC: cost = KANSW + ANSWL, accumulated depreciation = KNAFA + NAFAG (+ special depreciation KAAFA + AAFAG where used), net book value = cost − accumulated depreciation.
- The net book value difference between the two areas is calculated; amounts are shown in the company code currency (T001-WAERS) with subtotals by asset class.
Performance notes
Restrict ANLC by company code, fiscal year and the two depreciation areas; read ANLA, ANLB and ANLZ in bulk with the same asset keys. ANLC keeps planned depreciation (NAFAP) independent of what has been posted, so in a mid-year run the posted amount is taken from NAFAG. On S/4HANA asset values are derived from ACDOCA; I_FixedAssetForLedger is used for the master data.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the asset number opens AW01N.
- Export to Excel
- Runs as a background job Can be scheduled after the year-end close for the audit file.
Authorization objects
- A_S_ANLKLAsset display authorization by company code and asset class
- A_A_VIEWAuthorization to display depreciation area values
Frequently asked questions
Which depreciation areas can be compared?
The two areas on the selection screen are free: book and tax, book and IFRS, or a group currency area. They only need to be defined in the company code's chart of depreciation.
Is the depreciation of the year correct in a mid-year run?
The report shows posted depreciation (ANLC-NAFAG). Planned annual depreciation (NAFAP) can be added as an optional column, so the effect of the remaining periods is visible too.
Can the difference column be used for deferred tax?
The difference column gives the per-asset breakdown of the temporary difference. Applying the tax rate and posting it is the accounting team's decision; the report contains no rate.
Related reports
Mass Asset Retirement Upload from Excel (Scrapping and Sale)
A custom program that retires fixed assets in bulk from an Excel list, either by scrapping or with sales revenue. It supports full and partial …
G/L Line Items with Offsetting Account and Business Partner Report
A custom ALV general ledger report that lists the line items of selected G/L accounts with debit, credit and running balance, and adds the offsetting …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.