Cost Center Report
Actual costs versus plan by cost element, for a cost center or a whole group — variance and variance %, built on ACDOCA, where CO and FI are merged. The overspend lines surface first.
Sample build of the Cost Center Report — actual costs versus plan by cost element, with the overspend lines surfaced first, rendered tool-neutral so it runs in Power BI, SAC, or Tableau.
| Cost element (G/L) | Plan | Actual | Variance |
|---|---|---|---|
| 6000 · Salaries | 1,200,000 | 1,245,000 | +45,000 |
| 6100 · Contractors | 300,000 | 412,000 | +112,000 |
| 6200 · Travel | 80,000 | 61,000 | −19,000 |
| 6300 · Software | 150,000 | 158,000 | +8,000 |
| 9300 · IT allocation secondary | 220,000 | 224,000 | +4,000 |
| 6500 · Depreciation | 90,000 | 90,000 | 0 |
Actual spend 2.19M is 7.4% over the 2.04M plan. One line — Contractors (G/L 6100) — is 112K of the 150K overrun.
Contractors are 37% over plan (412K vs 300K) — three-quarters of the whole cost-center overrun sits on this one cost element, not spread evenly.
Pattern matches contractor backfill while a headcount req is open. Route to the cost-center owner with the open req and the run-rate; convert or close it before period end. CO postings write straight to ACDOCA, so the number is final — no FI/CO reconciliation needed.
The report's query logic — generic SQL on ACDOCA, the Universal Journal where CO and FI postings now live together. It sums actual amounts by cost center and cost element (G/L account) for the period, then joins your plan to get the variance. The same SQL becomes a dbt model in your warehouse.
Show / hide SQL
SELECT a.rcntr AS cost_center,
a.racct AS cost_element, -- G/L account (merged)
SUM(a.hsl) AS actual_amount,
p.plan_amount AS plan_amount,
SUM(a.hsl) - p.plan_amount AS variance
FROM acdoca a
LEFT JOIN plan_costs p ON p.rcntr = a.rcntr
AND p.racct = a.racct
AND p.poper = a.poper
WHERE a.rbukrs = :P_COMPANY_CODE
AND a.rcntr = :P_COST_CENTER
AND a.gjahr = :P_FISCAL_YEAR
AND a.poper BETWEEN :P_FROM_PERIOD AND :P_TO_PERIOD
GROUP BY a.rcntr, a.racct, p.plan_amount
ORDER BY variance DESC;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 cost line (cost center · cost element · period).
| Element | Type | Definition |
|---|---|---|
| dim_cost_center | dimension | Cost center & group — where the cost was incurred (RCNTR) |
| dim_account | dimension | Cost element / G/L account — the nature of the cost (RACCT) |
| dim_profit_center | dimension | Profit center & segment for margin reporting (PRCTR) |
| dim_date | dimension | Conformed calendar — fiscal year & posting period |
| actual_amount | measure | Actual cost posted in the period (HSL) |
| plan_amount | measure | Planned cost for the cost center / cost element |
| variance | measure | Actual − plan — the overspend or saving |
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 — the CO actual lines (RCNTR · RACCT · HSL) | 6 PK · amounts | Transparent table |
| I_CostCenter | Released cost-center master view — name, group, hierarchy, validity | released | Released CDS view |
| I_ProfitCenter | Released profit-center master view — segment, hierarchy | released | Released CDS view |
| I_GLAccountLineItem | Released journal-entry line view — CO actuals surface here | released | Released CDS view |
| CSKS | Cost center master — controlling area, validity, hierarchy area | KOKRS · KOSTL · DATBI | Transparent table |
| COEP | Classic CO line items — now a compatibility view over ACDOCA (Note 2270404) | compat | Compatibility view |
| SKA1 | G/L account (chart of accounts) — cost element category, GLACCOUNT_TYPE | KTOPL · SAKNR | Transparent table |