PP Report Custom development ALV report

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

  • COOIS Production Order Information System. Shows yield and scrap per operation; no comparison with planned scrap and no time variance.
  • CO14 Display Production Order Confirmation. Shows individual confirmations; no totals or ratios per work center.

Tables used

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

TableRoleJoinSystem
AFRUOrder ConfirmationsConfirmations: yield, scrap, rework, variance reason and actual activities (driving table)—ECC + S/4
AFVCOperation within an OrderOperation text and work center object IDAFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZLECC + S/4
AFVVQuantities, Dates and Values of Order OperationsOperation quantity, planned operation scrap, base quantity and standard valuesAFVV-AUFPL = AFRU-AUFPL AND AFVV-APLZL = AFRU-APLZLECC + S/4
CRHDWork Center HeaderWork center codeCRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBIDECC + S/4
AFKOOrder Header Data for PP OrdersHeader material of the orderAFKO-AUFNR = AFRU-AUFNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAFRU-WERKSYes1000
S_BUDATConfirmation posting dateRange / multipleAFRU-BUDATYes01.11.2026 – 15.11.2026
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoPRES-01
S_AUFNRProduction orderRange / multipleAFRU-AUFNRNo1000431
S_MATNRMaterialRange / multipleAFKO-PLNBEZNoFG-5003
S_GRUNDVariance reasonRange / multipleAFRU-GRUNDNo0002
P_VGWNRStandard value number for time comparison (1–6)Single value—Yes2
P_EXCESSScrap above plan onlyCheckbox—No—

Output columns

#ColumnSource
1Work centerCRHD-ARBPL
2Production orderAFRU-AUFNR
3OperationAFRU-VORNR
4Operation textAFVC-LTXA1
5MaterialAFKO-PLNBEZ
6YieldCalculated Σ AFRU-LMNGA
7ScrapCalculated Σ AFRU-XMNGA
8ReworkCalculated Σ AFRU-RMNGA
9UnitAFRU-MEINH
10Actual scrap %Calculated Scrap ÷ (yield + scrap) × 100
11Planned scrap %Calculated AFVV-ASVRG ÷ AFVV-MGVRG × 100
12Scrap variance (pts)Calculated Actual scrap % − planned scrap %
13Variance reason (top)AFRU-GRUND
14Standard time (h)Calculated AFVV-VGWnn × (yield + scrap) ÷ AFVV-BMSCH, converted to hours
15Actual time (h)Calculated Σ AFRU-ISMnn, converted to hours
16Time variance %Calculated (Actual time − standard time) ÷ standard time × 100

Sample output

Work centerProduction orderOperationOperation textMaterialYieldScrapReworkUnitActual scrap %Planned scrap %Scrap variance (pts)Variance reason (top)Standard time (h)Actual time (h)Time variance %
PRES-0110004310010Sheet cuttingFG-50031,180628PC523000219.7023.5019.30
PRES-0110004380010Sheet cuttingFG-610048060PC1.202-0.808.107.90-2.50
KAYNAK-0210004440020MIG weldingSF-221014094PC61.504.5000053541.2017.70
BOYA-0110004500030Powder coatingFG-50039501422PC1.5010.50000115.8016.403.80
A view built with fictional sample data; not real system data.

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.

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

CO Package Custom

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 …

4 components · v1.0

Related reports

PP Program Custom Mass upload

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 …

AFRU · AFKO · AFVC · AFFW

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: Scrap and Yield Analysis by Work Center Report