PP Report Custom development ALV report Textile and Apparel

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

  • COOIS Production Order Information System. Shows planned and withdrawn quantities of order components; it does not separate remnants, short rolls and waste.
  • MB51 Material Document List. Lists 261/262 movements to the order; there is no comparison with theoretical consumption and no waste rate.

Tables used

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

TableRoleJoinSystem
AFKOOrder Header Data for PP OrdersCutting order header and reservation number (driving table)—ECC + S/4
AFPOOrder ItemProduct, order quantity and quantity receivedAFPO-AUFNR = AFKO-AUFNRECC + S/4
RESBReservation/Dependent RequirementsPlanned requirement of the fabric componentRESB-RSNUM = AFKO-RSNUMECC + S/4
MSEGMaterial Document Item261 issues and 262 returns to the order, returned batchesMSEG-AUFNR = AFKO-AUFNR AND MSEG-MATNR = RESB-MATNRECC + S/4
MKPFMaterial Document HeaderPosting dateMKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHRECC + S/4
AFRUOrder ConfirmationsConfirmed scrap (cutting defects)AFRU-AUFNR = AFKO-AUFNR AND AFRU-STOKZ = ' 'ECC + S/4
AFVCOperation within an OrderCutting operation and work center linkAFVC-AUFPL = AFKO-AUFPLECC + S/4
CRHDWork Center HeaderCutting table (work center) codeCRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A'ECC + S/4
MBEWMaterial ValuationFabric price for the waste valueMBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKSECC + S/4
MATDOCMaterial Documents (S/4HANA)In S/4HANA it replaces MSEG and MKPF in a single tableMATDOC-AUFNR = AFKO-AUFNRS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAFPO-PWERKYes2000
S_BUDATPosting date rangeRange / multipleMKPF-BUDATYes01.10.2026 – 31.10.2026
S_ARBPLCutting table (work center)Range / multipleCRHD-ARBPLNoKS01–KS06
S_MATNRProductRange / multipleAFPO-MATNRNo—
S_FABRCFabricRange / multipleRESB-MATNRNoKM-*
P_MINLENShort roll threshold (remnants shorter than this)Single value—No5
P_TOLERWaste tolerance (%)Single value—No4

Output columns

#ColumnSource
1Cutting tableCRHD-ARBPL
2OrderAFKO-AUFNR
3ProductAFPO-MATNR
4FabricRESB-MATNR
5Theoretical consumptionCalculated RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG
6Net issueCalculated Σ MSEG-MENGE (261) − Σ MSEG-MENGE (262)
7Remnant returnedCalculated Σ MSEG-MENGE (262)
8Short rollsCalculated Number of returned batches below the short roll threshold
9WasteCalculated Net issue − theoretical consumption
10Waste %Calculated Waste / net issue × 100
11Cutting defects (pcs)AFRU-XMNGA
12UnitRESB-MEINS
13Waste valueCalculated Waste × MBEW price / price unit

Sample output

Cutting tableOrderProductFabricTheoretical consumptionNet issueRemnant returnedShort rollsWasteWaste %Cutting defects (pcs)UnitWaste value
KS021007710GM-TSH-BSC-MKM-PNY-180-BYZ1,2401,302463624.8018M5,642
KS021007714GM-TSH-POL-LKM-PIK-180-LAC860884311242.706M2,496
KS041007722GM-PNT-CHN-32KM-GBR-150-HAK1,5101,6225851126.9022M14,560
KS051007731GM-ELB-SAT-38KM-SAT-150-SYH640659120192.903M1,786
A view built with fictional sample data; not real system data.

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.

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

PP Report Custom ALV report

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 …

AFRU · AFVC · AFVV · CRHD

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: Cutting Remnant, Short Roll and Waste Analysis Report