# 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- or over-absorption between the value allocated at actual quantity × plan rate and the cost actually incurred.

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/activity-plan-vs-actual-rate-absorption-report/


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

### Closest standard alternatives

- KSBT: Shows plan rates; does not compare them with actual costs.
- S_ALR_87013611: Gives the cost center's plan and actual costs; does not calculate the absorption difference per activity type.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| COST | Plan and actual activity rates (driving table) | Read | - | ECC + S/4 |
| COSL | Plan and actual activity quantities | Read | COSL-OBJNR = COST-OBJNR AND COSL-GJAHR = COST-GJAHR | ECC + S/4 |
| COSP | Primary actual costs of the cost center | Read | COSP-OBJNR = masraf yeri nesne numarası | ECC + S/4 |
| COSS | Secondary actual costs received by the cost center | Read | COSS-OBJNR = masraf yeri nesne numarası | ECC + S/4 |
| CSKS | Cost center master | Read | CSKS-KOKRS = P_KOKRS | ECC + S/4 |
| CSKT | Cost center description | Read | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL | ECC + S/4 |
| CSLA | Activity type and activity unit | Read | CSLA-KOKRS = CSKS-KOKRS | 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_LSTAR | Activity type | Range / multiple | CSLA-LSTAR | No |
| P_GJAHR | Fiscal year | Single value | COST-GJAHR | Yes |
| P_PERFR | From period | Single value | - | Yes |
| P_PERTO | To period | Single value | - | Yes |
| P_VERSN | Plan version | Single value | COST-VERSN | No |
| P_TOL | Rate deviation tolerance (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Cost center | CSKS-KOSTL |
| Description | CSKT-KTEXT |
| Activity type | CSLA-LSTAR |
| Unit | CSLA-LEINH |
| Plan quantity | Calculated: Sum of COSL LST001…LST016, value type 01 |
| Actual quantity | Calculated: Sum of COSL LST001…LST016, value type 04 |
| Plan rate | Calculated: COST TKG total rate / price unit, value type 01 |
| Actual cost | Calculated: Actual debits of the cost center in COSP + COSS (activity credits excluded) |
| Allocated value | Calculated: Actual quantity × plan rate |
| Under(+) / over(−) absorption | Calculated: Actual cost − allocated value |
| Actual rate | Calculated: Actual cost / actual quantity |
| Deviation (%) | Calculated: (Actual rate − plan rate) / plan rate × 100 |
| Currency | TKA01-WAERS |

## How does the report work?

1. 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.
2. 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.
3. Quantities: plan (01) and actual (04) activity quantities in COSL are summed for P_PERFR–P_PERTO.
4. Actual cost: the cost center's actual (04) debits in COSP and COSS, excluding the credits from activity output.
5. 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.

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-activity-price-absorption
