Activity Type Plan vs Actual Rate and Under/Over-Absorption Report
Short answer: A custom ALV report that compares the plan rate per cost center and activity type with the actual rate derived from actual costs, and shows the under- or over-absorption between the value allocated at actual quantity × plan rate and the cost actually incurred.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
KSBT shows only plan rates and does not compare them with actual costs. S_ALR_87013611 gives the cost center's plan and actual costs, but does not calculate the value allocated at actual quantity × plan rate or the actual rate per activity type. Under- or over-absorption is therefore usually worked out in Excel before the actual price calculation.
Who uses it? Production controllers, cost accountants and CO teams responsible for rate planning.
Closest standard alternatives
- KSBT Cost Centers: Activity Prices. Shows plan rates; does not compare them with actual costs.
- S_ALR_87013611 Cost Centers: Actual/Plan/Variance. Gives the cost center's plan and actual costs; does not calculate the absorption difference per activity type.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| COSTCO Object: Price Totals | Plan and actual activity rates (driving table) | — | ECC + S/4 |
| COSLCO Object: Activity Type Totals | Plan and actual activity quantities | COSL-OBJNR = COST-OBJNR AND COSL-GJAHR = COST-GJAHR | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Primary actual costs of the cost center | COSP-OBJNR = masraf yeri nesne numarası | ECC + S/4 |
| COSSCO Object: Cost Totals for Internal Postings | Secondary actual costs received by the cost center | COSS-OBJNR = masraf yeri nesne numarası | ECC + S/4 |
| CSKSCost Center Master Record | Cost center master | CSKS-KOKRS = P_KOKRS | ECC + S/4 |
| CSKTCost Center Texts | Cost center description | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL | ECC + S/4 |
| CSLAActivity Type Master Data | Activity type and activity unit | CSLA-KOKRS = CSKS-KOKRS | ECC + S/4 |
| TKA01Controlling Areas | Controlling area currency | TKA01-KOKRS = CSKS-KOKRS | ECC + S/4 |
S/4HANA notes
- COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
- COSS → ACDOCA: In S/4HANA COSS is a view, not a table; internal actual postings are read from ACDOCA.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | CSKS-KOKRS | Yes | 1000 |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | No | 4200–4299 |
| S_LSTAR | Activity type | Range / multiple | CSLA-LSTAR | No | MAK01 |
| P_GJAHR | Fiscal year | Single value | COST-GJAHR | Yes | 2026 |
| P_PERFR | From period | Single value | — | Yes | 1 |
| P_PERTO | To period | Single value | — | Yes | 10 |
| P_VERSN | Plan version | Single value | COST-VERSN | No | 0 |
| P_TOL | Rate deviation tolerance (%) | Single value | — | No | 5 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Cost center | CSKS-KOSTL |
| 2 | Description | CSKT-KTEXT |
| 3 | Activity type | CSLA-LSTAR |
| 4 | Unit | CSLA-LEINH |
| 5 | Plan quantity | Calculated Sum of COSL LST001…LST016, value type 01 |
| 6 | Actual quantity | Calculated Sum of COSL LST001…LST016, value type 04 |
| 7 | Plan rate | Calculated COST TKG total rate / price unit, value type 01 |
| 8 | Actual cost | Calculated Actual debits of the cost center in COSP + COSS (activity credits excluded) |
| 9 | Allocated value | Calculated Actual quantity × plan rate |
| 10 | Under(+) / over(−) absorption | Calculated Actual cost − allocated value |
| 11 | Actual rate | Calculated Actual cost / actual quantity |
| 12 | Deviation (%) | Calculated (Actual rate − plan rate) / plan rate × 100 |
| 13 | Currency | TKA01-WAERS |
Sample output
| Cost center | Description | Activity type | Unit | Plan quantity | Actual quantity | Plan rate | Actual cost | Allocated value | Under(+) / over(−) absorption | Actual rate | Deviation (%) | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4210 | Injection line 1 | MAK01 | H | 4,200 | 3,860 | 850 | 3,412,000 | 3,281,000 | 131,000 | 883.94 | 4 | TRY |
| 4220 | Assembly line | ISC01 | H | 6,400 | 6,720 | 420 | 2,688,000 | 2,822,400 | -134,400 | 400 | -4.80 | TRY |
| 4230 | Paint shop | MAK02 | H | 1,800 | 1,250 | 1,100 | 1,905,000 | 1,375,000 | 530,000 | 1,524 | 38.50 | TRY |
How does the report work?
- Cost centers of the controlling area are read from CSKS and CSKT, and activity types and their units from CSLA; the cost center / activity type object number is built.
- Plan rate: value type 01 in COST for P_VERSN; the total rate (TKG) of the periods is divided by the price unit. If the actual price calculation has run, the value type 04 rate is read as well.
- Quantities: plan (01) and actual (04) activity quantities in COSL are summed for P_PERFR–P_PERTO.
- Actual cost: the cost center’s actual (04) debits in COSP and COSS, excluding the credits from activity output.
- Allocated value = actual quantity × plan rate. Under/over-absorption = actual cost − allocated value. Actual rate = actual cost / actual quantity; the deviation % is compared with P_TOL.
Performance notes
COST, COSL, COSP and COSS are totals tables and read quickly with an object number list. For large controlling areas, selecting by cost center group or plant-related cost centers is recommended.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The actual cost drills down to KSB1 and the rate to KSBT.
- Export to Excel
- Runs as a background job
- Send the result by email
Authorization objects
- K_CSKSDisplay authorization by cost center
- K_CCAGeneral cost center accounting authorization
Frequently asked questions
Can the report be used before the actual price calculation?
Yes, that is its main purpose. The actual rate is calculated in the report from actual cost and quantity; once the actual price calculation has run, the system's rate is shown in an extra column as well.
Can fixed and variable rates be shown separately?
Yes. By reading the fixed rate portion in COST, the plan rate can be split into fixed and variable, so the deviation from capacity utilization becomes visible separately.
Does it work on S/4HANA?
Yes. COST and COSL are still used on S/4HANA; COSP and COSS are read as compatibility views. If the new planning is used, plan quantities and rates are checked during installation.
Packages that include this solution
Cost Center Planning and Controlling Pack
A three-solution pack that covers the cost center planning cycle from start to end: plan upload from Excel, plan vs actual vs commitment comparison …
Related reports
Cost Center Plan vs Actual with Commitments Report
A custom ALV report that shows plan, actual and open purchasing commitments per cost center and cost element on one row, and calculates the remaining …
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.