SAP S/4HANA · Controlling (CO)
Controlling Data Model
Three CO factsAll on ACDOCAConformed dimensions
One owned model for Controlling. The three CO reports — cost centers, profit centers, and internal orders — are all built from ACDOCA and join one shared set of conformed dimensions. The same dimensions the finance model uses, so CO is not a silo.
One source (ACDOCA) · three CO facts · one shared set of conformed dimensions — the same set your finance model uses.
Why it matters: when the cost-center, profit-center, and order facts share the same cost center, account, and date, a number means the same thing in every CO report — and CO reconciles with the rest of finance, because the dimensions are the same ones the finance model uses.
Tap a section to drill in.
◆ The three CO facts— each is a thin view over ACDOCA on a different account assignment, sharing the same keys.
| Fact | Grain (one row per) | Built from |
|---|---|---|
| fct_cost_posting | cost line on a cost center | ACDOCA · RCNTR · RACCT |
| fct_pc_pnl | P&L line on a profit center | ACDOCA · PRCTR + FSV hierarchy |
| fct_order_cost | cost line on an internal order | ACDOCA · AUFNR · RACCT |
All three read the same table — ACDOCA — and differ only in which account assignment they group by. Because CO is merged into the Universal Journal, the cost center (RCNTR), profit center (PRCTR), and order (AUFNR) are explicit columns on every line, so one source feeds all three facts.
◆ The conformed dimensions— one cost center, one profit center, one order, one account — used by every CO fact.
| Dimension | What it is | Master |
|---|---|---|
| dim_cost_center | Cost center & group (RCNTR) | CSKS |
| dim_profit_center | Profit center & segment (PRCTR) | CEPC |
| dim_internal_order | Internal order, type & status (AUFNR) | AUFK |
| dim_account | Cost element / G/L account (RACCT) | SKA1 |
| dim_date | Fiscal year & posting period | calendar |
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 the cost-center report or trace it up to its profit center.
◆ Why it is one CO model, not three— the dimensions are shared, the rollups line up, and it plugs straight into your finance model.
- Shared dimensions — all three facts join the same cost-center, account, and date dimensions, so a number reconciles across the reports instead of arguing.
- The rollups line up — cost centers (CSKS) roll up to profit centers (CEPC) via PRCTR; orders settle to cost centers. One model expresses all of it.
- It is the same conformed set the finance model uses — dim_cost_center, dim_account, and dim_date are shared with G/L, AP/AR, assets, and tax, so CO is not a silo.
- Add later without rebuilding — activity types, statistical key figures, or CO-PA characteristics join the dimensions that already exist.
◆ How it is built & owned— over ACDOCA + released CDS views, on your cloud, extracted the compliant way.
- Source — ACDOCA for the actuals; the released master views I_CostCenter and I_ProfitCenter, and the journal views, for the dimensions.
- Build — dbt models: the three 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 →
- Fits the whole — these facts and dimensions slot into the enterprise data model via the conformed keys.
Want your CO model built & owned?
We build the cost-center, profit-center, and order facts on your cloud — sharing conformed dimensions with your finance model, reconciled 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 cost line).
- Conformed dimension
- One dimension shared by every fact, so a value means the same thing everywhere.
- Cost center (RCNTR)
- Where a cost is incurred — a department, line, or function.
- Profit center (PRCTR)
- A unit you measure profit for; cost centers roll up to it.
- Internal order (AUFNR)
- A short-lived cost collector — a campaign, event, or job.
- Cost element (RACCT)
- The nature of a cost; in S/4HANA it is a G/L account.
- ACDOCA
- The Universal Journal — where CO actuals post; the source for every CO fact.
- Margin Analysis
- Account-based CO-PA, integrated in ACDOCA — no separate CO-PA table.
- Star schema
- One fact surrounded by its dimensions — the report-friendly shape.
- Grain
- What one row of a fact represents — the level of detail.