Cutting Remnant, Short Roll and Waste Analysis Report
Short answer: 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.
- Estimated effort
- M · 6–8 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Cutting room and garment production supervisors, production planning, cost accounting and plant management.
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 |
|---|---|---|---|
| AFKOOrder Header Data for PP Orders | Cutting order header and reservation number (driving table) | — | ECC + S/4 |
| AFPOOrder Item | Product, order quantity and quantity received | AFPO-AUFNR = AFKO-AUFNR | ECC + S/4 |
| RESBReservation/Dependent Requirements | Planned requirement of the fabric component | RESB-RSNUM = AFKO-RSNUM | ECC + S/4 |
| MSEGMaterial Document Item | 261 issues and 262 returns to the order, returned batches | MSEG-AUFNR = AFKO-AUFNR AND MSEG-MATNR = RESB-MATNR | ECC + S/4 |
| MKPFMaterial Document Header | Posting date | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC + S/4 |
| AFRUOrder Confirmations | Confirmed scrap (cutting defects) | AFRU-AUFNR = AFKO-AUFNR AND AFRU-STOKZ = ' ' | ECC + S/4 |
| AFVCOperation within an Order | Cutting operation and work center link | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| CRHDWork Center Header | Cutting table (work center) code | CRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A' | ECC + S/4 |
| MBEWMaterial Valuation | Fabric price for the waste value | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| MATDOCMaterial Documents (S/4HANA) | In S/4HANA it replaces MSEG and MKPF in a single table | MATDOC-AUFNR = AFKO-AUFNR | S/4HANA only |
S/4HANA notes
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AFPO-PWERK | Yes | 2000 |
| S_BUDAT | Posting date range | Range / multiple | MKPF-BUDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_ARBPL | Cutting table (work center) | Range / multiple | CRHD-ARBPL | No | KS01–KS06 |
| S_MATNR | Product | Range / multiple | AFPO-MATNR | No | — |
| S_FABRC | Fabric | Range / multiple | RESB-MATNR | No | KM-* |
| P_MINLEN | Short roll threshold (remnants shorter than this) | Single value | — | No | 5 |
| P_TOLER | Waste tolerance (%) | Single value | — | No | 4 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Cutting table | CRHD-ARBPL |
| 2 | Order | AFKO-AUFNR |
| 3 | Product | AFPO-MATNR |
| 4 | Fabric | RESB-MATNR |
| 5 | Theoretical consumption | Calculated RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG |
| 6 | Net issue | Calculated Σ MSEG-MENGE (261) − Σ MSEG-MENGE (262) |
| 7 | Remnant returned | Calculated Σ MSEG-MENGE (262) |
| 8 | Short rolls | Calculated Number of returned batches below the short roll threshold |
| 9 | Waste | Calculated Net issue − theoretical consumption |
| 10 | Waste % | Calculated Waste / net issue × 100 |
| 11 | Cutting defects (pcs) | AFRU-XMNGA |
| 12 | Unit | RESB-MEINS |
| 13 | Waste value | Calculated Waste × MBEW price / price unit |
Sample output
| Cutting table | Order | Product | Fabric | Theoretical consumption | Net issue | Remnant returned | Short rolls | Waste | Waste % | Cutting defects (pcs) | Unit | Waste value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KS02 | 1007710 | GM-TSH-BSC-M | KM-PNY-180-BYZ | 1,240 | 1,302 | 46 | 3 | 62 | 4.80 | 18 | M | 5,642 |
| KS02 | 1007714 | GM-TSH-POL-L | KM-PIK-180-LAC | 860 | 884 | 31 | 1 | 24 | 2.70 | 6 | M | 2,496 |
| KS04 | 1007722 | GM-PNT-CHN-32 | KM-GBR-150-HAK | 1,510 | 1,622 | 58 | 5 | 112 | 6.90 | 22 | M | 14,560 |
| KS05 | 1007731 | GM-ELB-SAT-38 | KM-SAT-150-SYH | 640 | 659 | 12 | 0 | 19 | 2.90 | 3 | M | 1,786 |
How does the report work?
- 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.
- Fabric components are selected from RESB. Theoretical consumption = RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG, i.e. the requirement for the quantity actually received.
- 261 issues and 262 returns posted to the order are read from MSEG and MKPF. Net issue = Σ 261 − Σ 262.
- 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”.
- 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.
- The ALV shows subtotals per work center, product and fabric; lines above tolerance are highlighted.
Performance notes
Read MSEG with the order numbers and movement types (261, 262) and apply the date filter via MKPF. In S/4HANA, MATDOC or I_MaterialDocumentItem_2 is faster in a single read. Read RESB only for fabric material groups.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the order opens CO03; double-clicking the net issue opens the related material documents in MB51.
- Export to Excel
- Runs as a background job
Authorization objects
- C_AFKO_AWKProduction order display authorization by order type and plant
- M_MSEG_WMBGoods 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.
Related reports
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Production Order Component Consumption Variance Report (Planned vs Actual Issue)
A custom ALV report that compares, for completed production orders, the consumption each component should have for the delivered quantity with the …
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 …
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.