Cost Center Plan vs Actual with Commitments Report
Short answer: 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 budget and consumption rate. Rows above the consumption threshold are flagged with a traffic light.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_ALR_87013611 shows plan, actual and variance but does not include open purchase requisition and order commitments, so managers see more remaining budget than there really is. Commitments are listed in a separate report and KSB1 shows only actual line items. There is no standard Excel-ready list that deducts actuals and commitments together to give the remaining budget.
Who uses it? Controllers, cost center owners, budgeting teams and finance managers.
Closest standard alternatives
- S_ALR_87013611 Cost Centers: Actual/Plan/Variance. Shows plan, actual and variance; does not include commitments or remaining budget.
- KSB1 Cost Centers: Actual Line Items. Lists actual line items; does not compare with plan and commitments.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| COSPCO Object: Cost Totals for External Postings | Primary cost totals: plan, actual and commitments (driving table) | — | ECC + S/4 |
| COSSCO Object: Cost Totals for Internal Postings | Secondary cost totals: plan and actual allocations | COSS-OBJNR = COSP-OBJNR AND COSS-GJAHR = COSP-GJAHR | ECC + S/4 |
| CSKSCost Center Master Record | Cost center master: validity, profit center, category | OBJNR = 'KS' + CSKS-KOKRS + CSKS-KOSTL | ECC + S/4 |
| CSKTCost Center Texts | Cost center description | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI | 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 | 4100–4599 |
| S_KSTAR | Cost element | Range / multiple | COSP-KSTAR | No | 770000–779999 |
| P_GJAHR | Fiscal year | Single value | COSP-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 | COSP-VERSN | No | 0 |
| P_CMMT | Include commitments | Checkbox | — | No | X |
| P_WARN | Warning threshold (%) | Single value | — | No | 85 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Cost center | CSKS-KOSTL |
| 2 | Description | CSKT-KTEXT |
| 3 | Profit center | CSKS-PRCTR |
| 4 | Cost element | COSP-KSTAR |
| 5 | Plan | Calculated Sum of COSP + COSS WKG001…WKG016, value type 01, P_VERSN |
| 6 | Actual | Calculated COSP + COSS period total, value type 04 |
| 7 | Commitment | Calculated COSP period total, value types 21 and 22 |
| 8 | Actual + commitment | Calculated Actual + commitment |
| 9 | Remaining | Calculated Plan − actual − commitment |
| 10 | Consumption (%) | Calculated (Actual + commitment) / plan × 100 |
| 11 | Light | Calculated Consumption < P_WARN green, P_WARN–100 yellow, > 100 red |
| 12 | Currency | TKA01-WAERS |
Sample output
| Cost center | Description | Profit center | Cost element | Plan | Actual | Commitment | Actual + commitment | Remaining | Consumption (%) | Light | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4100 | Maintenance workshop | PC1100 | 770150 | 480,000 | 352,400 | 61,800 | 414,200 | 65,800 | 86 | Yellow | TRY |
| 4100 | Maintenance workshop | PC1100 | 770160 | 120,000 | 131,500 | 0 | 131,500 | -11,500 | 110 | Red | TRY |
| 4300 | Marketing | PC1200 | 760200 | 900,000 | 512,000 | 144,000 | 656,000 | 244,000 | 73 | Green | TRY |
| 4500 | Information technology | PC1900 | 770300 | 360,000 | 290,500 | 52,000 | 342,500 | 17,500 | 95 | Yellow | TRY |
How does the report work?
- Cost centers of the controlling area are read from CSKS with their validity in the selected period (DATAB/DATBI) and their texts from CSKT in the logon language; the object number (OBJNR) is built from the cost center.
- Plan: value type 01 (plan) in COSP and COSS for the selected plan version (VERSN).
- Actual: value type 04 in COSP and COSS, version 0. Commitment: value types 21 (purchase requisition) and 22 (purchase order) in COSP.
- Period amounts are summed from WKG001…WKG016 for the P_PERFR–P_PERTO range in controlling area currency (TKA01-WAERS).
- Remaining = plan − actual − commitment; consumption % = (actual + commitment) / plan × 100. The P_WARN threshold and 100% set the traffic light.
Performance notes
Read COSP and COSS by the object number list, fiscal year, value type and version; the totals tables are small, so the report is much faster than one based on line items. In S/4HANA, do the aggregation in the database.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants Variants with subtotals by cost center or profit center can be saved.
- Double-click drill-down to the document The actual amount drills down to KSB1 and the commitment amount to the open order items.
- Export to Excel
- Runs as a background job
- Send the result by email Each cost center owner can receive their own rows.
Authorization objects
- K_CSKSDisplay authorization by cost center
- K_CCAGeneral cost center accounting authorization
Frequently asked questions
Which commitments are included?
Open purchase requisitions and purchase orders with the cost center as account assignment are included. If other commitment types such as funds reservations are used, they can be added to the value type list.
Can I select by cost center group or hierarchy?
Yes. A cost center group is added to the selection; the group is resolved into a list of cost centers and the result can be subtotaled by hierarchy node.
Does it work on S/4HANA?
Yes. COSP and COSS are read as compatibility views on S/4HANA and actuals come from ACDOCA. If the new planning (ACDOCP) is used, the report is adapted to read plan values from there.
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
Activity Type Plan vs Actual Rate and Under/Over-Absorption Report
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- …
Cost Center Cost Plan Upload from Excel
A custom program that loads periodic plan amounts per cost center and cost element from a budget file into the CO plan in bulk. It checks every row in …
Internal Order Budget Availability Report
A custom ALV report that compares the annual or overall budget of internal orders with actual costs and open commitments, and shows the remaining …
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.