# Production Output by Machine, Process and Quality Report (Metres and m²)

> A custom ALV report that totals good output and scrap from production confirmations by machine, process (weaving, dyeing, finishing, inspection) and quality in metres and m². Output confirmed in different units is converted into one unit; metres per machine hour and the scrap rate appear on the same line.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (4–7 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/production-output-by-machine-process-quality-metres-m2-report/


## Why is the standard not enough?

COOIS lists operations and confirmations, but it does not convert the confirmation unit into metres and m², does not total by machine, process and quality, and does not calculate output per machine hour. In textile companies this data is usually combined by hand in Excel for the daily production meeting. The custom report produces the same table in one run.

### Closest standard alternatives

- COOIS: Lists operations and confirmations; no metre/m² conversion and no machine, process and quality totals.
- CO14: Displays a single confirmation; no period totals and no efficiency calculation.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AFRU | Confirmations: good quantity, scrap, unit, machine time (driving table) | Read | - | ECC + S/4 |
| CRHD | Machine (work center) and plant | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFRU-ARBID | ECC + S/4 |
| CRTX | Machine description | Read | CRTX-OBJTY = CRHD-OBJTY AND CRTX-OBJID = CRHD-OBJID | ECC + S/4 |
| AFVC | Standard text key of the operation (process) | Read | AFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZL | ECC + S/4 |
| AFPO | Quality (material) produced | Read | AFPO-AUFNR = AFRU-AUFNR | ECC + S/4 |
| MAKT | Quality description | Read | MAKT-MATNR = AFPO-MATNR | ECC + S/4 |
| MARA | Fabric width and its unit | Read | MARA-MATNR = AFPO-MATNR | ECC + S/4 |
| MARM | Unit conversion factors (M, M2, KG) | Read | MARM-MATNR = AFPO-MATNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | CRHD-WERKS | Yes |
| S_BUDAT | Confirmation posting date | Range / multiple | AFRU-BUDAT | Yes |
| S_ARBPL | Machine (work center) | Range / multiple | CRHD-ARBPL | No |
| S_KTSCH | Process (standard text key) | Range / multiple | AFVC-KTSCH | No |
| S_MATNR | Quality (material) | Range / multiple | AFPO-MATNR | No |
| P_GROUP | Grouping: machine / process / quality | Radio button | - | Yes |

## Output columns

| Column | Source |
|---|---|
| Plant | CRHD-WERKS |
| Machine | CRHD-ARBPL |
| Machine description | CRTX-KTEXT |
| Process | AFVC-KTSCH |
| Quality | AFPO-MATNR |
| Quality description | MAKT-MAKTX |
| Good output (m) | Calculated: Σ AFRU-LMNGA converted to metres via MARM |
| Good output (m²) | Calculated: Good metres × width (m) |
| Scrap (m) | Calculated: Σ AFRU-XMNGA converted to metres |
| Scrap % | Calculated: Scrap / (good + scrap) × 100 |
| Machine hours | Calculated: Σ AFRU-ISM01 converted to hours |
| Metres / hour | Calculated: Good metres / machine hours |
| Number of orders | Calculated: Count of distinct AFRU-AUFNR |

## How does the report work?

1. AFRU is read by plant and posting date (BUDAT); reversed confirmations (STOKZ = X) and reversal confirmations (STZHL filled) are excluded.
2. The confirmation's work center (AFRU-ARBID → CRHD-OBJID, OBJTY = 'A') gives the machine; the machine description comes from CRTX. The process is the operation's standard text key (AFVC-KTSCH; e.g. weaving, dyeing, finishing, inspection).
3. The quality is the material produced by the order (AFPO-MATNR); its description comes from MAKT.
4. If the confirmation unit (AFRU-MEINH) is not metres, it is converted with the MARM factors (UMREZ/UMREN). m² = metres × width; the width is converted to metres from MARA-BREIT and its unit MEABM. If the material has an M2 alternative unit, the MARM factor is used directly.
5. Scrap (XMNGA) is converted the same way; scrap % = scrap / (good + scrap) × 100.
6. Machine hours come from the machine time activity of the confirmation (ISM01, converted to hours by unit ILE01); metres/hour = good metres / machine hours. The ALV shows subtotals by the selected grouping (machine, process or quality).

## Authorization objects

- C_AFRU_AWK: Confirmation display authorization by plant and order type
- C_AFKO_AWK: Production order display authorization

## Frequently asked questions

### How are metres found if confirmations are posted in kilograms?

If the conversion between kg and metres is defined in MARM as an alternative unit, that factor is used. If not, the line is flagged with a warning and the metre column stays empty, which also makes the missing master data visible.

### Can I see the figures per shift?

AFRU has no shift field. A shift column can be added by matching the confirmation start time (ISDZ) with the work center's shift calendar; this adds about 1 day to the estimate.

### Does it work on S/4HANA?

Yes. AFRU, CRHD, AFVC and MARM keep the same structure on S/4HANA; the report runs without changes.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-production-output-report
