PP Report Custom development ALV report

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

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

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
KBEDCapacity Requirements RecordsCapacity requirement records: remaining requirement and scheduled dates (driving table)—ECC + S/4
CRHDWork Center HeaderWork center code, plant and person responsibleCRHD-OBJTY = 'A' AND CRHD-OBJID = CRCA-OBJIDECC + S/4
CRCAWork Center Capacity AllocationLink between work center and capacityCRCA-KAPID = KBED-KAPIDECC + S/4
KAKOCapacity Header SegmentCapacity category, shift length, utilization rate and factory calendarKAKO-KAPID = KBED-KAPIDECC + S/4
AFKOOrder Header Data for PP OrdersProduction order the capacity requirement belongs toAFKO-AUFPL = KBED-AUFPLECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleCRHD-WERKSYes1000
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoPRES-01
S_VERANPerson responsibleRange / multipleCRHD-VERANNo001
S_KAPARCapacity categoryRange / multipleKAKO-KAPARNo001
P_FROMStart date (default: today)Single valueSY-DATUMYes17.11.2026
P_WEEKSNumber of weeksSingle value—Yes4
P_LIMITOverload threshold (%)Single value—No100
P_PLAFInclude planned order loadCheckbox—NoX

Output columns

#ColumnSource
1Work centerCRHD-ARBPL
2PlantCRHD-WERKS
3Capacity categoryKAKO-KAPAR
4Capacity nameKAKO-NAME
5WeekCalculated ISO week of KBED-SSTAD
6Available (h)Calculated (KAKO-ENDZT − BEGZT − PAUSE) × NGRAD ÷ 100 × AZNOR × working days
7Order load (h)Calculated Σ KBED-KBEAREST of records that match AFKO
8Planned order load (h)Calculated Σ KBED-KBEAREST of records not linked to a production order
9Utilization %Calculated (Order load + planned order load) ÷ available × 100
10Free / over hoursCalculated Available − total load (negative: overload)
11OperationsCalculated Number of KBED records in the week
12StatusCalculated Overloaded when utilization % exceeds the threshold, otherwise normal

Sample output

Work centerPlantCapacity categoryCapacity nameWeekAvailable (h)Order load (h)Planned order load (h)Utilization %Free / over hoursOperationsStatus
PRES-011000001PRES-012026-W478072.50698.101.5014Normal
PRES-011000001PRES-012026-W48808810122.50-1819Overloaded
KAYNAK-021000002KAYNAK-022026-W4711295084.801711Normal
BOYA-011000001BOYA-012026-W4860411288.3079Normal
A view built with fictional sample data; not real system data.

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.

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

PP Package Custom

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 …

5 components · v1.0

Related reports

PP Report Custom ALV report

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 …

AFRU · AFVC · AFVV · CRHD

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.

Related report: Weekly Capacity Load by Work Center Report