# Weekly Capacity Load by Work Center Report

> A custom ALV report that shows, for every work center of the selected plant, the available capacity, the production order and planned order load and the utilization for the coming weeks as a work center × week matrix. Overloaded weeks are flagged against a threshold and exported to Excel as one table.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (5–8 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/weekly-capacity-load-by-work-center-report/


## Why is the standard not enough?

CM01 and CM05 show overload per work center, but the result is a set of separate screens split by period; there is no way to export several work centers as one table with weekly available hours, production order load and planned order load, or to email overloaded weeks. Planners combine the results of several screens by hand for the weekly capacity meeting.

### Closest standard alternatives

- CM01: Gives the work center load per period; it does not give several work centers in one Excel table by week.
- CM05: Lists overloaded work centers; it does not show order and planned order load in separate columns.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| KBED | Capacity requirement records: remaining requirement and scheduled dates (driving table) | Read | - | ECC + S/4 |
| CRHD | Work center code, plant and person responsible | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = CRCA-OBJID | ECC + S/4 |
| CRCA | Link between work center and capacity | Read | CRCA-KAPID = KBED-KAPID | ECC + S/4 |
| KAKO | Capacity category, shift length, utilization rate and factory calendar | Read | KAKO-KAPID = KBED-KAPID | ECC + S/4 |
| AFKO | Production order the capacity requirement belongs to | Read | AFKO-AUFPL = KBED-AUFPL | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | CRHD-WERKS | Yes |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_VERAN | Person responsible | Range / multiple | CRHD-VERAN | No |
| S_KAPAR | Capacity category | Range / multiple | KAKO-KAPAR | No |
| P_FROM | Start date (default: today) | Single value | SY-DATUM | Yes |
| P_WEEKS | Number of weeks | Single value | - | Yes |
| P_LIMIT | Overload threshold (%) | Single value | - | No |
| P_PLAF | Include planned order load | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Work center | CRHD-ARBPL |
| Plant | CRHD-WERKS |
| Capacity category | KAKO-KAPAR |
| Capacity name | KAKO-NAME |
| Week | Calculated: ISO week of KBED-SSTAD |
| Available (h) | Calculated: (KAKO-ENDZT − BEGZT − PAUSE) × NGRAD ÷ 100 × AZNOR × working days |
| Order load (h) | Calculated: Σ KBED-KBEAREST of records that match AFKO |
| Planned order load (h) | Calculated: Σ KBED-KBEAREST of records not linked to a production order |
| Utilization % | Calculated: (Order load + planned order load) ÷ available × 100 |
| Free / over hours | Calculated: Available − total load (negative: overload) |
| Operations | Calculated: Number of KBED records in the week |
| Status | Calculated: Overloaded when utilization % exceeds the threshold, otherwise normal |

## How does the report work?

1. Work centers of the selected plant (OBJTY = A, LVORM blank) are read from CRHD. CRCA gives the capacities (KAPID) of each work center; KAKO gives the capacity category (KAPAR), shift start and end (BEGZT, ENDZT), break (PAUSE), utilization rate (NGRAD) and number of individual capacities (AZNOR).
2. Daily available capacity = (ENDZT − BEGZT − PAUSE) × NGRAD ÷ 100 × AZNOR, converted from seconds to hours. Working days come from the factory calendar in KAKO-KALID (or the plant calendar when blank); interval variants defined on the capacity take priority.
3. Capacity requirement records of these capacities are read from KBED. The remaining requirement KBEAREST (unit KEINH) is converted to hours and assigned to the ISO week of the scheduled start date (SSTAD; FSTAD when blank).
4. Records that match AFKO-AUFPL = KBED-AUFPL are totalled as production order load; records without a match are written, by selection, to the planned order load column.
5. Utilization % = (order load + planned order load) ÷ available capacity × 100. Weeks above the threshold are flagged as overloaded and shown in red.
6. Double-clicking a line opens the operations of that week (order, operation, remaining hours) in a separate list.

## Authorization objects

- C_ARPL_WRK: Display work centers by plant
- C_AFKO_AWK: Display production orders by plant and order type

## Frequently asked questions

### Are shift programs and holidays taken into account?

Yes. Available capacity is calculated from the capacity's factory calendar and, where defined, its interval variants (shift program); holidays add no capacity.

### Is the result the same as CM01?

The remaining requirement comes from the same source (KBED), so the totals match for the same period and capacity. The difference is that the result is one weekly table that compares work centers.

### Does it work on S/4HANA?

Yes. KBED, KAKO, CRHD and CRCA keep the same structure in S/4HANA. For a clean core approach, CDS views such as I_WorkCenterCapacity and I_CapacityRequirement can be used.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-weekly-capacity-load-by-work-center
