# Subcontract Processing Yield and Waste Reconciliation Report

> A custom ALV report that compares the fabric sent to the subcontractor for processes such as dyeing, printing or finishing with the stock left at the subcontractor and the finished goods returned, and measures the actual yield against the expected yield. The unexplained waste quantity and value become visible per subcontractor and order, so reconciliation with subcontractors is based on figures.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (5–7 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/subcontract-processing-yield-and-waste-reconciliation-report/


## Why is the standard not enough?

ME2O shows component stock at the subcontractor and what still needs to be sent, and MBLB shows stock at the vendor. Since component consumption (543) is posted automatically at finished goods receipt with the quantity from the bill of material, the real waste stays hidden in the subcontractor stock; no standard screen compares quantities sent and returned in different units (kg and meters) and calculates the yield. The custom report makes this reconciliation including the unit conversion.

### Closest standard alternatives

- ME2O: Shows component stock at the subcontractor and what needs to be sent; it does not calculate yield or waste.
- MBLB: Lists stock at the vendor; it does not reconcile it with quantities sent and returned.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EKKO | Subcontracting order header and subcontractor (driving table) | Read | - | ECC + S/4 |
| EKPO | Subcontracting order item: finished material to return and order quantity | Read | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| RESB | Components to be provided for the order item | Read | RESB-EBELN = EKPO-EBELN AND RESB-EBELP = EKPO-EBELP | ECC + S/4 |
| MSEG | 541/542 transfers, 101/102/122 finished goods receipts | Read | MSEG-EBELN = EKPO-EBELN AND MSEG-EBELP = EKPO-EBELP | ECC + S/4 |
| MKPF | Posting date | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC + S/4 |
| MSLB | Component stock at the subcontractor | Read | MSLB-LIFNR = EKKO-LIFNR AND MSLB-MATNR = RESB-MATNR | ECC + S/4 |
| MARM | Unit conversion between kg and meters | Read | MARM-MATNR = EKPO-MATNR | ECC + S/4 |
| LFA1 | Subcontractor name | Read | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| MBEW | Component price for the waste value | Read | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| I_MaterialDocumentItem_2 | In S/4HANA it can replace MSEG with a clean core approach | Read | PurchaseOrder = EKPO-EBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | Yes |
| S_LIFNR | Subcontractor | Range / multiple | EKKO-LIFNR | No |
| S_BUDAT | Posting date range | Range / multiple | MKPF-BUDAT | Yes |
| S_MATNR | Component sent | Range / multiple | RESB-MATNR | No |
| P_TOLER | Yield variance tolerance (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Subcontractor | LFA1-NAME1 |
| Order | EKPO-EBELN |
| Item | EKPO-EBELP |
| Finished material | EKPO-MATNR |
| Component sent | RESB-MATNR |
| Quantity sent | Calculated: Σ MSEG-MENGE (541) − Σ MSEG-MENGE (542) |
| Left at subcontractor | MSLB-LBLAB |
| Processed input | Calculated: Sent − left at subcontractor |
| Finished quantity returned | Calculated: Σ MSEG-MENGE (101) − Σ (102, 122) |
| Expected yield | Calculated: EKPO-MENGE / RESB-BDMNG |
| Actual yield | Calculated: Finished returned / processed input (converted to the same unit via MARM) |
| Yield variance % | Calculated: (Actual yield − expected yield) / expected yield × 100 |
| Unexplained waste | Calculated: Processed input − finished returned / expected yield |
| Waste value | Calculated: Unexplained waste × MBEW price / price unit |

## How does the report work?

1. Subcontracting order items (item category subcontracting) in the selected purchasing organization, plant and subcontractor are read from EKKO and EKPO.
2. Components linked to the order item (EBELN, EBELP) and the planned component quantity come from RESB; expected yield = EKPO-MENGE / RESB-BDMNG.
3. 541 transfers to the subcontractor and 542 returns within the period are read from MSEG and MKPF and totalled per order when the order reference exists, otherwise per subcontractor and component.
4. Finished goods receipts (101) and their reversals/returns (102, 122) are totalled per order; component stock left at the subcontractor is read from MSLB (LBLAB).
5. Processed input = sent − left at subcontractor. Actual yield = finished goods returned / processed input. If the units differ, the conversion in MARM (for example kg per meter) is used.
6. Unexplained waste = processed input − finished goods returned / expected yield; its value is calculated with the MBEW price. Subcontractors are ranked by yield variance.

## Authorization objects

- M_BEST_EKO: Purchase order display authorization by purchasing organization
- M_MSEG_WMB: Goods movement display authorization by plant

## Frequently asked questions

### How does this report differ from a subcontracting component consumption reconciliation?

A component consumption reconciliation compares the consumption posted at finished goods receipt with the plan. This report looks at the physical flow: it calculates the actual yield from the quantities sent, left at the subcontractor and returned, and reveals waste hidden by the posted consumption.

### How are quantities compared when fabric is sent in kg and returns in meters?

The weight per meter of the finished material is taken from the unit of measure conversion in the material master (MARM) and both quantities are converted to the same unit. Materials without a conversion are listed with a warning.

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

Yes. Goods movements are read via MATDOC or I_MaterialDocumentItem_2 and stock at the subcontractor from the MSLB compatibility view.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=textile-subcontract-yield-reconciliation
