Scrap and Yield Analysis by Work Center Report
Short answer: A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap percentage with the planned operation scrap and the actual time with the standard time. Quality and production teams see the operations above plan and the most frequent variance reason in one list.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The COOIS operation view and the CO14 confirmation list show yield and scrap one confirmation line at a time. The actual scrap percentage, the comparison with planned operation scrap, the distribution of variance reasons and the comparison of standard and actual time need a separate layout, unit conversion and an Excel calculation. Weekly scrap meetings usually rely on this hand-made table.
Who uses it? Production managers, shift supervisors, quality engineers and controllers who follow production cost.
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 |
|---|---|---|---|
| AFRUOrder Confirmations | Confirmations: yield, scrap, rework, variance reason and actual activities (driving table) | — | ECC + S/4 |
| AFVCOperation within an Order | Operation text and work center object ID | AFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZL | ECC + S/4 |
| AFVVQuantities, Dates and Values of Order Operations | Operation quantity, planned operation scrap, base quantity and standard values | AFVV-AUFPL = AFRU-AUFPL AND AFVV-APLZL = AFRU-APLZL | ECC + S/4 |
| CRHDWork Center Header | Work center code | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Header material of the order | AFKO-AUFNR = AFRU-AUFNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AFRU-WERKS | Yes | 1000 |
| S_BUDAT | Confirmation posting date | Range / multiple | AFRU-BUDAT | Yes | 01.11.2026 – 15.11.2026 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | PRES-01 |
| S_AUFNR | Production order | Range / multiple | AFRU-AUFNR | No | 1000431 |
| S_MATNR | Material | Range / multiple | AFKO-PLNBEZ | No | FG-5003 |
| S_GRUND | Variance reason | Range / multiple | AFRU-GRUND | No | 0002 |
| P_VGWNR | Standard value number for time comparison (1–6) | Single value | — | Yes | 2 |
| P_EXCESS | Scrap above plan only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Work center | CRHD-ARBPL |
| 2 | Production order | AFRU-AUFNR |
| 3 | Operation | AFRU-VORNR |
| 4 | Operation text | AFVC-LTXA1 |
| 5 | Material | AFKO-PLNBEZ |
| 6 | Yield | Calculated Σ AFRU-LMNGA |
| 7 | Scrap | Calculated Σ AFRU-XMNGA |
| 8 | Rework | Calculated Σ AFRU-RMNGA |
| 9 | Unit | AFRU-MEINH |
| 10 | Actual scrap % | Calculated Scrap ÷ (yield + scrap) × 100 |
| 11 | Planned scrap % | Calculated AFVV-ASVRG ÷ AFVV-MGVRG × 100 |
| 12 | Scrap variance (pts) | Calculated Actual scrap % − planned scrap % |
| 13 | Variance reason (top) | AFRU-GRUND |
| 14 | Standard time (h) | Calculated AFVV-VGWnn × (yield + scrap) ÷ AFVV-BMSCH, converted to hours |
| 15 | Actual time (h) | Calculated Σ AFRU-ISMnn, converted to hours |
| 16 | Time variance % | Calculated (Actual time − standard time) ÷ standard time × 100 |
Sample output
| Work center | Production order | Operation | Operation text | Material | Yield | Scrap | Rework | Unit | Actual scrap % | Planned scrap % | Scrap variance (pts) | Variance reason (top) | Standard time (h) | Actual time (h) | Time variance % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRES-01 | 1000431 | 0010 | Sheet cutting | FG-5003 | 1,180 | 62 | 8 | PC | 5 | 2 | 3 | 0002 | 19.70 | 23.50 | 19.30 |
| PRES-01 | 1000438 | 0010 | Sheet cutting | FG-6100 | 480 | 6 | 0 | PC | 1.20 | 2 | -0.80 | 8.10 | 7.90 | -2.50 | |
| KAYNAK-02 | 1000444 | 0020 | MIG welding | SF-2210 | 140 | 9 | 4 | PC | 6 | 1.50 | 4.50 | 0005 | 35 | 41.20 | 17.70 |
| BOYA-01 | 1000450 | 0030 | Powder coating | FG-5003 | 950 | 14 | 22 | PC | 1.50 | 1 | 0.50 | 0001 | 15.80 | 16.40 | 3.80 |
How does the report work?
- Confirmations of the selected plant and posting date range are read from AFRU; cancelled confirmations (STOKZ set) and reversal records (STZHL set) are skipped.
- Confirmations are totalled per order and operation (AUFPL + APLZL): yield LMNGA, scrap XMNGA, rework RMNGA and the actual activity (ISM01–ISM06) that matches the selected standard value.
- Operation text (LTXA1) and the work center object ID (ARBID) come from AFVC; the work center code comes from CRHD (OBJTY = A, OBJID = ARBID). Operation quantity (MGVRG), planned operation scrap (ASVRG), base quantity (BMSCH) and standard values (VGW01–VGW06, units VGE01–VGE06) come from AFVV. The header material (PLNBEZ) comes from AFKO.
- Actual scrap % = scrap ÷ (yield + scrap) × 100. Planned scrap % = ASVRG ÷ MGVRG × 100. Variance = actual − planned (percentage points).
- Standard time = VGWnn × (yield + scrap) ÷ BMSCH, converted to hours. Time variance % = (actual − standard) ÷ standard × 100.
- The variance reason (GRUND) shown is the reason with the largest scrap quantity. ALV shows subtotals per work center; lines with scrap above plan are highlighted.
Performance notes
Narrow AFRU by plant and posting date. Read AFVC, AFVV and CRHD with FOR ALL ENTRIES only for the selected operations. For a full-year analysis run the report in the background or run months separately and combine them.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a line lists the operation's confirmations, from where CO14 opens.
- Export to Excel
- Runs as a background job
Authorization objects
- C_AFRU_AWKDisplay confirmations by plant and order type
- C_AFKO_AWKDisplay production orders by plant and order type
Frequently asked questions
Which standard value is the machine time?
It depends on the standard value key; in many setups 1 is setup, 2 machine and 3 labor time. That is why the number on the selection screen is a parameter, and its default is set during installation from the company's standard value key.
Do cancelled confirmations distort the totals?
No. Cancelled confirmations (AFRU-STOKZ) and reversal records (AFRU-STZHL) are excluded, so only valid confirmations are counted.
Does it work on S/4HANA?
Yes. AFRU, AFVC, AFVV and CRHD keep the same structure in S/4HANA. For a clean core approach, the I_MfgOrderConfirmation CDS view can be used.
Packages that include this solution
Product Cost and Production Variance Pack
A four-report pack that shows where product cost variance comes from, with one plant and period selection: standard vs current cost estimate …
Related reports
Mass Production Order Confirmation Upload Program
A custom program that reads operation confirmations (yield, scrap, rework, activity times) coming from MES, shop-floor terminals or Excel at the end …
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 …
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.