Weekly Capacity Load by Work Center Report
Short answer: 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.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Production planners, capacity planners and production managers who plan shifts.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| KBEDCapacity Requirements Records | Capacity requirement records: remaining requirement and scheduled dates (driving table) | — | ECC + S/4 |
| CRHDWork Center Header | Work center code, plant and person responsible | CRHD-OBJTY = 'A' AND CRHD-OBJID = CRCA-OBJID | ECC + S/4 |
| CRCAWork Center Capacity Allocation | Link between work center and capacity | CRCA-KAPID = KBED-KAPID | ECC + S/4 |
| KAKOCapacity Header Segment | Capacity category, shift length, utilization rate and factory calendar | KAKO-KAPID = KBED-KAPID | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Production order the capacity requirement belongs to | AFKO-AUFPL = KBED-AUFPL | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | CRHD-WERKS | Yes | 1000 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | PRES-01 |
| S_VERAN | Person responsible | Range / multiple | CRHD-VERAN | No | 001 |
| S_KAPAR | Capacity category | Range / multiple | KAKO-KAPAR | No | 001 |
| P_FROM | Start date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_WEEKS | Number of weeks | Single value | — | Yes | 4 |
| P_LIMIT | Overload threshold (%) | Single value | — | No | 100 |
| P_PLAF | Include planned order load | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Work center | CRHD-ARBPL |
| 2 | Plant | CRHD-WERKS |
| 3 | Capacity category | KAKO-KAPAR |
| 4 | Capacity name | KAKO-NAME |
| 5 | Week | Calculated ISO week of KBED-SSTAD |
| 6 | Available (h) | Calculated (KAKO-ENDZT − BEGZT − PAUSE) × NGRAD ÷ 100 × AZNOR × working days |
| 7 | Order load (h) | Calculated Σ KBED-KBEAREST of records that match AFKO |
| 8 | Planned order load (h) | Calculated Σ KBED-KBEAREST of records not linked to a production order |
| 9 | Utilization % | Calculated (Order load + planned order load) ÷ available × 100 |
| 10 | Free / over hours | Calculated Available − total load (negative: overload) |
| 11 | Operations | Calculated Number of KBED records in the week |
| 12 | Status | Calculated Overloaded when utilization % exceeds the threshold, otherwise normal |
Sample output
| Work center | Plant | Capacity category | Capacity name | Week | Available (h) | Order load (h) | Planned order load (h) | Utilization % | Free / over hours | Operations | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PRES-01 | 1000 | 001 | PRES-01 | 2026-W47 | 80 | 72.50 | 6 | 98.10 | 1.50 | 14 | Normal |
| PRES-01 | 1000 | 001 | PRES-01 | 2026-W48 | 80 | 88 | 10 | 122.50 | -18 | 19 | Overloaded |
| KAYNAK-02 | 1000 | 002 | KAYNAK-02 | 2026-W47 | 112 | 95 | 0 | 84.80 | 17 | 11 | Normal |
| BOYA-01 | 1000 | 001 | BOYA-01 | 2026-W48 | 60 | 41 | 12 | 88.30 | 7 | 9 | Normal |
How does the report work?
- 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).
- 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.
- 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).
- 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.
- Utilization % = (order load + planned order load) ÷ available capacity × 100. Weeks above the threshold are flagged as overloaded and shown in red.
- Double-clicking a line opens the operations of that week (order, operation, remaining hours) in a separate list.
Performance notes
Read KBED only for the selected capacity IDs and date range. Calculate the factory calendar once per capacity and keep it in a buffer. In plants with many work centers, run the report in the background every morning and distribute the result by email.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document A week line opens that week's operations; from an operation CO03 opens.
- Export to Excel
- Runs as a background job
- Send the result by email Overloaded weeks can be sent to the person responsible for the work center.
Authorization objects
- C_ARPL_WRKDisplay work centers by plant
- C_AFKO_AWKDisplay 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.
Packages that include this solution
Production Order Control Pack
A pack that combines four reports and one background program for the daily production meeting with one plant and MRP controller selection: overdue …
Related reports
Overdue Production Orders and Remaining Quantity Report
A custom ALV report that lists production orders past their basic finish date that are not yet fully received, with days late, remaining quantity and …
Scrap and Yield Analysis by Work Center Report
A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap …
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.