SAP S/4HANA · The owned model
Enterprise Data Model
One owned modelFacts on ACDOCAConformed dimensions
One owned model, not five silos. Every module’s fact — general ledger, payables and receivables, fixed assets, tax — is built from ACDOCA and joins one shared set of conformed dimensions. That is what lets you report across modules consistently.
One source (ACDOCA) · many module facts · one shared set of conformed dimensions — so you report across modules, not in silos.
Why it matters: when every fact shares the same date, company code, account, and business partner, a number means the same thing in every report — and you can add a module without rebuilding the others. That consistency is the whole point of an enterprise model.
Tap a section to drill in.
◆ The module facts— each is a thin view over ACDOCA + its module specifics, sharing the same keys.
| Fact | Grain (one row per) | Built from |
|---|---|---|
| fct_gl_line | G/L posting line | ACDOCA · I_GLAccountLineItem |
| fct_open_items | open vendor / customer item | ACDOCA / BSEG · I_OperationalAcctgDocItem (K / D) |
| fct_asset_balance | asset · area · date | ACDOCA + ANLA · I_AssetValuationForLedger |
| fct_tax_line | tax line (document · code) | BSET + BKPF |
Each fact is deliberately thin — the measures and the keys. The descriptive detail lives once, in the shared dimensions, so it is never duplicated or contradicted across modules.
◆ The conformed dimensions— one date, one company code, one account, one partner, one cost center — used by every fact.
| Dimension | What it is | Shared by |
|---|---|---|
| dim_date | Calendar — fiscal year, period, posting & tax date | every fact |
| dim_company_code | Entity, ledger, country | every fact |
| dim_account | G/L account + the financial-statement hierarchy (FSV) | G/L, open items, assets, tax |
| dim_business_partner | Vendor & customer — one partner, by role | open items (+ G/L where assigned) |
| dim_cost_center | Cost center / profit center / segment | G/L, assets (where assigned) |
| dim_tax_code | Tax code, rate, type | tax (+ G/L lines carrying a code) |
| dim_asset | Asset master — class, capitalization date | assets |
Conformed means the same dimension table, the same keys, joined by every fact that needs it — so "cost center 4100" is the same thing whether you reach it from a G/L report or an asset report.
◆ Why conformed dimensions matter— a number means the same thing in every report, and you add a module without rebuilding.
- Consistency — "spend by cost center" and "assets by cost center" use the same cost-center list, so they reconcile instead of arguing.
- One version of the truth — one customer, one account hierarchy, one calendar, everywhere. No per-report remapping.
- Extensibility — add Controlling or Materials Management later and it joins the dimensions that already exist. No rebuild.
- The difference between an enterprise model and five disconnected marts that each tell a slightly different story.
◆ How it is built & owned— over ACDOCA + released CDS views, on your cloud, extracted the compliant way.
- Source — ACDOCA and the released CDS views, never compatibility views.
- Build — dbt models: the facts and the conformed dimensions, reconciled to the source ERP before go-live.
- Land — your own cloud warehouse: GCP, AWS, or Azure.
- Extract — released CDS + ODP-OData, SLT, or Table/Table-CDC; never ODP-RFC. See the extraction pattern →
- Own — every line of code and every model is yours, on your cloud.
Want this enterprise model built & owned?
We build the facts and the conformed dimensions on your cloud — reconciled to your books before go-live — and your team owns every line of code.
Terms on this page
- Fact
- A table of measures and keys — the numbers you aggregate (one row per event).
- Dimension
- A descriptive lookup you slice by — date, account, cost center, partner.
- Conformed dimension
- One dimension shared by every fact, so a value means the same thing everywhere.
- Grain
- What one row of a fact represents — the level of detail.
- Star schema
- One fact surrounded by its dimensions — the report-friendly shape.
- Galaxy schema
- Several facts sharing conformed dimensions — the enterprise model.
- ACDOCA
- The Universal Journal — the one S/4HANA table every finance fact is built from.
- Business Partner
- The single master for vendor and customer, surfaced by role.
- dbt
- A popular open tool for building and testing the models in your warehouse.
- Released CDS view
- An SAP-supplied, upgrade-safe view — the compliant source.