# Cutting Remnant, Short Roll and Waste Analysis Report

> A custom ALV report that compares the fabric issued to cutting orders with the theoretical fabric needed for the quantity produced, and splits the difference into remnants returned to stock, short rolls and real waste. The waste rate becomes visible by product, fabric and cutting table, and the number and value of short rolls are tracked separately.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (6–8 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/cutting-remnant-short-roll-and-waste-analysis-report/


## Why is the standard not enough?

COOIS shows planned and withdrawn quantities of order components and MB51 lists 261/262 movements, but neither separates returned remnants into short rolls, calculates waste against the quantity produced or totals its value by cutting table. The custom report makes this split and shows the waste that erodes margin by product and machine.

### Closest standard alternatives

- COOIS: Shows planned and withdrawn quantities of order components; it does not separate remnants, short rolls and waste.
- MB51: Lists 261/262 movements to the order; there is no comparison with theoretical consumption and no waste rate.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AFKO | Cutting order header and reservation number (driving table) | Read | - | ECC + S/4 |
| AFPO | Product, order quantity and quantity received | Read | AFPO-AUFNR = AFKO-AUFNR | ECC + S/4 |
| RESB | Planned requirement of the fabric component | Read | RESB-RSNUM = AFKO-RSNUM | ECC + S/4 |
| MSEG | 261 issues and 262 returns to the order, returned batches | Read | MSEG-AUFNR = AFKO-AUFNR AND MSEG-MATNR = RESB-MATNR | ECC + S/4 |
| MKPF | Posting date | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC + S/4 |
| AFRU | Confirmed scrap (cutting defects) | Read | AFRU-AUFNR = AFKO-AUFNR AND AFRU-STOKZ = ' ' | ECC + S/4 |
| AFVC | Cutting operation and work center link | Read | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| CRHD | Cutting table (work center) code | Read | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| MBEW | Fabric price for the waste value | Read | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| MATDOC | In S/4HANA it replaces MSEG and MKPF in a single table | Read | MATDOC-AUFNR = AFKO-AUFNR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AFPO-PWERK | Yes |
| S_BUDAT | Posting date range | Range / multiple | MKPF-BUDAT | Yes |
| S_ARBPL | Cutting table (work center) | Range / multiple | CRHD-ARBPL | No |
| S_MATNR | Product | Range / multiple | AFPO-MATNR | No |
| S_FABRC | Fabric | Range / multiple | RESB-MATNR | No |
| P_MINLEN | Short roll threshold (remnants shorter than this) | Single value | - | No |
| P_TOLER | Waste tolerance (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Cutting table | CRHD-ARBPL |
| Order | AFKO-AUFNR |
| Product | AFPO-MATNR |
| Fabric | RESB-MATNR |
| Theoretical consumption | Calculated: RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG |
| Net issue | Calculated: Σ MSEG-MENGE (261) − Σ MSEG-MENGE (262) |
| Remnant returned | Calculated: Σ MSEG-MENGE (262) |
| Short rolls | Calculated: Number of returned batches below the short roll threshold |
| Waste | Calculated: Net issue − theoretical consumption |
| Waste % | Calculated: Waste / net issue × 100 |
| Cutting defects (pcs) | AFRU-XMNGA |
| Unit | RESB-MEINS |
| Waste value | Calculated: Waste × MBEW price / price unit |

## How does the report work?

1. Cutting orders in the selected plant that received goods in the selected period are read from AFKO and AFPO; the work center of the cutting operation comes from AFVC and CRHD.
2. Fabric components are selected from RESB. Theoretical consumption = RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG, i.e. the requirement for the quantity actually received.
3. 261 issues and 262 returns posted to the order are read from MSEG and MKPF. Net issue = Σ 261 − Σ 262.
4. Every batch returned from the order to stock is a remnant; those with a quantity below the minimum length on the selection screen count as "short rolls".
5. Waste = net issue − theoretical consumption; waste % = waste / net issue. The waste value is calculated with the MBEW price. Confirmed scrap in AFRU (XMNGA) is shown separately as the number of cutting defects.
6. The ALV shows subtotals per work center, product and fabric; lines above tolerance are highlighted.

## Authorization objects

- C_AFKO_AWK: Production order display authorization by order type and plant
- M_MSEG_WMB: Goods movement display authorization by plant

## Frequently asked questions

### Is marker efficiency taken into account?

By default, theoretical consumption comes from the fabric quantity in the bill of material. If markers are planned in a CAD system outside SAP, the fabric need per marker can be uploaded from a file and used instead; this adds 2–3 days to the estimate.

### How is a short roll determined?

Every batch returned from the order to stock with movement type 262 counts as a remnant. Batches shorter than the threshold on the selection screen (for example 5 meters) are counted and listed as short rolls.

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

Yes. Goods movements are read via MATDOC or I_MaterialDocumentItem_2 and order data from the same tables.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=textile-remnant-waste-analysis
