Subcontract Processing Yield and Waste Reconciliation Report
Short answer: 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.
- Estimated effort
- M · 5–7 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?
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.
Who uses it? Subcontracting and purchasing managers, warehouse teams, production planning and cost accounting.
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 |
|---|---|---|---|
| EKKOPurchasing Document Header | Subcontracting order header and subcontractor (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Subcontracting order item: finished material to return and order quantity | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| RESBReservation/Dependent Requirements | Components to be provided for the order item | RESB-EBELN = EKPO-EBELN AND RESB-EBELP = EKPO-EBELP | ECC + S/4 |
| MSEGMaterial Document Item | 541/542 transfers, 101/102/122 finished goods receipts | MSEG-EBELN = EKPO-EBELN AND MSEG-EBELP = EKPO-EBELP | ECC + S/4 |
| MKPFMaterial Document Header | Posting date | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC + S/4 |
| MSLBSpecial Stocks with Vendor | Component stock at the subcontractor | MSLB-LIFNR = EKKO-LIFNR AND MSLB-MATNR = RESB-MATNR | ECC + S/4 |
| MARMUnits of Measure for Material | Unit conversion between kg and meters | MARM-MATNR = EKPO-MATNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Subcontractor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| MBEWMaterial Valuation | Component price for the waste value | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| I_MaterialDocumentItem_2Material Document Item (CDS) | In S/4HANA it can replace MSEG with a clean core approach | PurchaseOrder = EKPO-EBELN | 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.
- MSLB → MATDOC: In S/4HANA special stock at vendor is no longer persisted in MSLB; it is calculated from MATDOC and the name MSLB is read through the compatibility view NSDM_V_MSLB. Reading code keeps working, but the table must not be written directly.
- 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_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No | 1000 |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | Yes | 1000 |
| S_LIFNR | Subcontractor | Range / multiple | EKKO-LIFNR | No | — |
| S_BUDAT | Posting date range | Range / multiple | MKPF-BUDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_MATNR | Component sent | Range / multiple | RESB-MATNR | No | HK-* |
| P_TOLER | Yield variance tolerance (%) | Single value | — | No | 3 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Subcontractor | LFA1-NAME1 |
| 2 | Order | EKPO-EBELN |
| 3 | Item | EKPO-EBELP |
| 4 | Finished material | EKPO-MATNR |
| 5 | Component sent | RESB-MATNR |
| 6 | Quantity sent | Calculated Σ MSEG-MENGE (541) − Σ MSEG-MENGE (542) |
| 7 | Left at subcontractor | MSLB-LBLAB |
| 8 | Processed input | Calculated Sent − left at subcontractor |
| 9 | Finished quantity returned | Calculated Σ MSEG-MENGE (101) − Σ (102, 122) |
| 10 | Expected yield | Calculated EKPO-MENGE / RESB-BDMNG |
| 11 | Actual yield | Calculated Finished returned / processed input (converted to the same unit via MARM) |
| 12 | Yield variance % | Calculated (Actual yield − expected yield) / expected yield × 100 |
| 13 | Unexplained waste | Calculated Processed input − finished returned / expected yield |
| 14 | Waste value | Calculated Unexplained waste × MBEW price / price unit |
Sample output
| Subcontractor | Order | Item | Finished material | Component sent | Quantity sent | Left at subcontractor | Processed input | Finished quantity returned | Expected yield | Actual yield | Yield variance % | Unexplained waste | Waste value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ege Boya Fason Ltd. | 4500021040 | 00010 | KM-PNY-220-LAC | HK-PNY-220-HAM | 2,400 | 180 | 2,220 | 7,660 | 3.60 | 3.45 | -4.20 | 92 | 11,040 |
| Marmara Baskı San. | 4500021052 | 00010 | KM-SAT-150-DSN | HK-SAT-150-HAM | 1,200 | 0 | 1,200 | 4,380 | 3.70 | 3.65 | -1.40 | 16 | 2,560 |
| Ege Boya Fason Ltd. | 4500021066 | 00020 | KM-DNM-160-IND | HK-DNM-160-HAM | 3,100 | 420 | 2,680 | 7,920 | 3 | 2.96 | -1.50 | 40 | 5,200 |
| Trakya Apre A.Ş. | 4500021071 | 00010 | KM-KTN-180-BEJ | HK-KTN-180-HAM | 950 | 0 | 950 | 3,060 | 3.40 | 3.22 | -5.30 | 50 | 7,000 |
How does the report work?
- Subcontracting order items (item category subcontracting) in the selected purchasing organization, plant and subcontractor are read from EKKO and EKPO.
- Components linked to the order item (EBELN, EBELP) and the planned component quantity come from RESB; expected yield = EKPO-MENGE / RESB-BDMNG.
- 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.
- 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).
- 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.
- Unexplained waste = processed input − finished goods returned / expected yield; its value is calculated with the MBEW price. Subcontractors are ranked by yield variance.
Performance notes
Read EKPO only for subcontracting items. Limit MSEG by movement types (541, 542, 101, 102, 122), subcontractor and date range. MSLB is a small table; read it once for the selected subcontractors.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the order opens ME23N; double-clicking the quantity sent opens the related material documents; double-clicking the remaining stock opens MBLB.
- Export to Excel
- Runs as a background job
- Send the result by email At month end each subcontractor can receive its own reconciliation list.
Authorization objects
- M_BEST_EKOPurchase order display authorization by purchasing organization
- M_MSEG_WMBGoods 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.
Related reports
Subcontracting Component Consumption and Stock at Vendor Reconciliation Report
A custom ALV report that compares the planned consumption of components sent to the vendor on subcontracting orders with the consumption posted at …
Vendor On-Time Delivery Performance Report
A custom ALV report that compares every goods receipt posted in the selected period with the delivery date of the purchase order and shows, per …
Vendor Quality Scorecard and Rejection Rate (PPM) Report
A custom ALV report that shows, per vendor and material, the lot rejection rate from goods receipt inspection lots, the rejected quantity in parts per …
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.