Analytics Catalog/SAP S/4HANA/Fixed Assets/Data model
Explore the catalogACDOCAAsset History SheetCDS viewsExtraction
SAP S/4HANA · Fixed Assets

Fixed Assets Data Model

Three FA factsOn ACDOCAConformed dimensions

One owned model for Fixed Assets. The balance, history-sheet, and transaction facts are all built from ACDOCA and join one shared set of conformed dimensions. The same set the rest of finance uses.

ACDOCA — the Universal Journal asset values post real-time here · the single spine fct_asset_balanceBalancesfct_asset_historyHistory sheetfct_asset_transactionTransactions Conformed dimensions — shared by every FA fact dim_asset · dim_deprec_area · dim_transaction_type · dim_company_code · dim_date
One source (ACDOCA) · three FA facts · one shared set of conformed dimensions — the same set your finance model uses.
Why it matters: when the Fixed Assets facts share the same asset, account, and date, a number means the same thing in every Fixed Assets report — and it reconciles with the rest of finance, because the dimensions are the same ones the enterprise model uses.

Tap a section to drill in.

◆ The Fixed Assets facts— each is a thin view over the source, sharing the same keys.
FactGrain (one row per)Built from
fct_asset_balanceasset × area balanceACDOCA + ANLA
fct_asset_historyasset movementACDOCA by transaction type
fct_asset_transactionasset transaction lineACDOCA · I_FixedAsset
In S/4HANA asset values post real-time to ACDOCA, so there is no separate asset sub-ledger to reconcile. The history sheet is the transactions grouped by movement type and depreciation area.
◆ The conformed dimensions— one asset, one account, one calendar — used by every fact.
DimensionWhat it isMaster
dim_assetAsset master (ANLN1/ANLN2)ANLA
dim_deprec_areaDepreciation areaarea config
dim_transaction_typeTransaction type (acquisition, retirement…)ATM config
dim_company_codeCompany code (RBUKRS)T001
dim_dateFiscal year & periodcalendar
Conformed means the same dimension table, the same keys, joined by every fact that needs it — so a value means the same thing in every report.
◆ Why it is one model, not three— the dimensions are shared, and it plugs straight into your finance model.
◆ How it is built & owned— over the source + released CDS views, on your cloud, extracted the compliant way.
Terms on this page
Asset (ANLN1/ANLN2)
The asset number and its sub-number — the asset master is ANLA.
Depreciation area
A valuation view of an asset (book, tax, group…).
History sheet
The asset movements — acquisitions, retirements, depreciation — over a period.
Fact
A table of measures and keys — the numbers you aggregate.
Conformed dimension
One dimension shared by every fact, so a value means the same thing everywhere.
ACDOCA
The Universal Journal — the single S/4HANA table behind the finance facts.
Star schema
One fact surrounded by its dimensions — the report-friendly shape.
Grain
What one row of a fact represents — the level of detail.
Want your Fixed Assets model built & owned?
We build the balance, history-sheet, and transaction facts on ACDOCA — reconciled to the asset register before go-live — and your team owns every line of code.
Talk to us