Asset Transactions
Every asset movement in the period — acquisitions, retirements, and transfers, by transaction type — the line-item detail that sits under the history-sheet roll-forward (the old S_ALR_87012048), built on ACDOCA.
Sample build of the Asset Transactions report — every asset movement by transaction type, the detail that reconciles up to the history-sheet roll-forward, and rendered tool-neutral so it runs in Power BI, SAC, or Tableau.
| Asset | Type | Document | Date | Amount |
|---|---|---|---|---|
| 100001 · Forklift #12 | 100 · Acquisition | 4900020118 | 14 Feb | 240,000 |
| 100002 · Server rack | 100 · Acquisition | 4900020155 | 03 Mar | 180,000 |
| 200044 · Delivery van | 210 · Retirement | 4900020399 | 28 Apr | (300,000) |
| 300012 · Building wing | 310 · Transfer | 4900020412 | 12 May | 1,500,000 |
Every asset movement in the period — acquisitions (100s), retirements (200s), and transfers (300s) — by transaction type. This is the line-item detail that sits under the Asset History Sheet roll-forward.
Asset 200044 (Delivery van) was retired for 300K on 28 Apr. A retirement posts a gain or loss to P&L against remaining book value — confirm the disposal value and that the asset is fully deactivated on the register.
Transaction type (ANBWA) drives which history-sheet column a movement lands in. The old S_ALR_87012048 and the Fiori app F1614 can differ on the APC and value-adjustment columns (SAP KBA 3393005) — reconcile transaction totals up to the history-sheet movement rows.
The report's query logic — generic SQL on ACDOCA, listing each asset posting with its transaction type, document, and amount. The same SQL becomes a dbt model in your warehouse.
Show / hide SQL
SELECT m.anlkl AS asset_class,
a.anln1, a.anln2,
a.afabe AS deprec_area,
a.anbwa AS trans_type,
CASE
WHEN a.anbwa BETWEEN '100' AND '199' THEN 'Acquisition'
WHEN a.anbwa BETWEEN '200' AND '299' THEN 'Retirement'
WHEN a.anbwa BETWEEN '300' AND '399' THEN 'Transfer'
ELSE 'Other'
END AS trans_category,
a.belnr AS document_no,
a.budat AS posting_date,
a.bzdat AS asset_value_date,
a.hsl AS amount
FROM acdoca a
JOIN anla m ON m.bukrs = a.rbukrs
AND m.anln1 = a.anln1
AND m.anln2 = a.anln2
WHERE a.rbukrs = :P_COMPANY_CODE
AND a.gjahr = :P_FISCAL_YEAR
AND a.afabe = :P_DEPRECIATION_AREA -- 01 book / 15 tax / 32 IFRS
AND a.anln1 <> '' AND a.anbwa <> '' -- asset transaction postings only
AND a.budat BETWEEN :P_FROM_DATE AND :P_TO_DATE
ORDER BY a.budat, a.anln1;The data-warehouse model — one fact surrounded by conformed dimensions (what you slice by) and measures (what you aggregate), expressed as dbt so it migrates with you. Grain: one row per asset transaction (posting).
| Element | Type | Definition |
|---|---|---|
| dim_asset | dimension | Asset master (ANLA) — class, description, capitalization date |
| dim_deprec_area | dimension | Depreciation area & accounting principle — book / tax / IFRS |
| dim_transaction_type | dimension | Transaction type (ANBWA) — acquisition / retirement / transfer |
| dim_date | dimension | Conformed calendar — posting & asset value date |
| amount | measure | Transaction amount in company-code currency (HSL) |
| document_no | attribute | The accounting document the movement posted under |
| trans_category | attribute | Acquisition / retirement / transfer, derived from ANBWA |
Every source object behind this report. Each linked object has its own page — with its fields and its real S/4HANA status, so you build on the right thing.
| Object | Role | Key fields | S/4HANA status |
|---|---|---|---|
| ACDOCA | Universal Journal — asset values post here (ANLN1 · AFABE · ANBWA) | 6 PK · 360+ | Transparent table |
| ANLA | Asset master — class, description, capitalization date | ANLN1 · ANLN2 | Transparent table |
| ANLZ / ANLB | Time-dependent assignments & depreciation terms (key, useful life) | ANLN1 | Transparent table |
| I_FixedAsset | Released asset-master CDS view — class, attributes | released | Released CDS view |
| I_AssetValuationForLedger | Released asset-values CDS view (ledger-dependent) | released | Released CDS view |
| ANEP / ANLC | Legacy asset line / value tables — FAAV_* views, do not extract | — | Compat view → ACDOCA |
| FAAT_PLAN_VALUES | Planned depreciation per asset · area · period — for the forecast | reference | Transparent table |