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

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/scrap-and-yield-by-work-center-report/


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

### Closest standard alternatives

- COOIS: Shows yield and scrap per operation; no comparison with planned scrap and no time variance.
- CO14: Shows individual confirmations; no totals or ratios per work center.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AFRU | Confirmations: yield, scrap, rework, variance reason and actual activities (driving table) | Read | - | ECC + S/4 |
| AFVC | Operation text and work center object ID | Read | AFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZL | ECC + S/4 |
| AFVV | Operation quantity, planned operation scrap, base quantity and standard values | Read | AFVV-AUFPL = AFRU-AUFPL AND AFVV-APLZL = AFRU-APLZL | ECC + S/4 |
| CRHD | Work center code | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| AFKO | Header material of the order | Read | AFKO-AUFNR = AFRU-AUFNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AFRU-WERKS | Yes |
| S_BUDAT | Confirmation posting date | Range / multiple | AFRU-BUDAT | Yes |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_AUFNR | Production order | Range / multiple | AFRU-AUFNR | No |
| S_MATNR | Material | Range / multiple | AFKO-PLNBEZ | No |
| S_GRUND | Variance reason | Range / multiple | AFRU-GRUND | No |
| P_VGWNR | Standard value number for time comparison (1–6) | Single value | - | Yes |
| P_EXCESS | Scrap above plan only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Work center | CRHD-ARBPL |
| Production order | AFRU-AUFNR |
| Operation | AFRU-VORNR |
| Operation text | AFVC-LTXA1 |
| Material | AFKO-PLNBEZ |
| Yield | Calculated: Σ AFRU-LMNGA |
| Scrap | Calculated: Σ AFRU-XMNGA |
| Rework | Calculated: Σ AFRU-RMNGA |
| Unit | AFRU-MEINH |
| Actual scrap % | Calculated: Scrap ÷ (yield + scrap) × 100 |
| Planned scrap % | Calculated: AFVV-ASVRG ÷ AFVV-MGVRG × 100 |
| Scrap variance (pts) | Calculated: Actual scrap % − planned scrap % |
| Variance reason (top) | AFRU-GRUND |
| Standard time (h) | Calculated: AFVV-VGWnn × (yield + scrap) ÷ AFVV-BMSCH, converted to hours |
| Actual time (h) | Calculated: Σ AFRU-ISMnn, converted to hours |
| Time variance % | Calculated: (Actual time − standard time) ÷ standard time × 100 |

## How does the report work?

1. Confirmations of the selected plant and posting date range are read from AFRU; cancelled confirmations (STOKZ set) and reversal records (STZHL set) are skipped.
2. 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.
3. 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.
4. Actual scrap % = scrap ÷ (yield + scrap) × 100. Planned scrap % = ASVRG ÷ MGVRG × 100. Variance = actual − planned (percentage points).
5. Standard time = VGWnn × (yield + scrap) ÷ BMSCH, converted to hours. Time variance % = (actual − standard) ÷ standard × 100.
6. 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.

## Authorization objects

- C_AFRU_AWK: Display confirmations by plant and order type
- C_AFKO_AWK: Display 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.

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