# 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 budget and consumption rate. Rows above the consumption threshold are flagged with a traffic light.

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/cost-center-plan-actual-commitment-report/


## 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.

### Closest standard alternatives

- S_ALR_87013611: Shows plan, actual and variance; does not include commitments or remaining budget.
- KSB1: Lists actual line items; does not compare with plan and commitments.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| COSP | Primary cost totals: plan, actual and commitments (driving table) | Read | - | ECC + S/4 |
| COSS | Secondary cost totals: plan and actual allocations | Read | COSS-OBJNR = COSP-OBJNR AND COSS-GJAHR = COSP-GJAHR | ECC + S/4 |
| CSKS | Cost center master: validity, profit center, category | Read | OBJNR = 'KS' + CSKS-KOKRS + CSKS-KOSTL | ECC + S/4 |
| CSKT | Cost center description | Read | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI | ECC + S/4 |
| TKA01 | Controlling area currency | Read | TKA01-KOKRS = CSKS-KOKRS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | CSKS-KOKRS | Yes |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | No |
| S_KSTAR | Cost element | Range / multiple | COSP-KSTAR | No |
| P_GJAHR | Fiscal year | Single value | COSP-GJAHR | Yes |
| P_PERFR | From period | Single value | - | Yes |
| P_PERTO | To period | Single value | - | Yes |
| P_VERSN | Plan version | Single value | COSP-VERSN | No |
| P_CMMT | Include commitments | Checkbox | - | No |
| P_WARN | Warning threshold (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Cost center | CSKS-KOSTL |
| Description | CSKT-KTEXT |
| Profit center | CSKS-PRCTR |
| Cost element | COSP-KSTAR |
| Plan | Calculated: Sum of COSP + COSS WKG001…WKG016, value type 01, P_VERSN |
| Actual | Calculated: COSP + COSS period total, value type 04 |
| Commitment | Calculated: COSP period total, value types 21 and 22 |
| Actual + commitment | Calculated: Actual + commitment |
| Remaining | Calculated: Plan − actual − commitment |
| Consumption (%) | Calculated: (Actual + commitment) / plan × 100 |
| Light | Calculated: Consumption < P_WARN green, P_WARN–100 yellow, > 100 red |
| Currency | TKA01-WAERS |

## How does the report work?

1. 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.
2. Plan: value type 01 (plan) in COSP and COSS for the selected plan version (VERSN).
3. Actual: value type 04 in COSP and COSS, version 0. Commitment: value types 21 (purchase requisition) and 22 (purchase order) in COSP.
4. Period amounts are summed from WKG001…WKG016 for the P_PERFR–P_PERTO range in controlling area currency (TKA01-WAERS).
5. Remaining = plan − actual − commitment; consumption % = (actual + commitment) / plan × 100. The P_WARN threshold and 100% set the traffic light.

## Authorization objects

- K_CSKS: Display authorization by cost center
- K_CCA: General 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-cost-center-plan-actual-commitment
