MM Report Custom development ALV report Textile and Apparel

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

  • ME2O SC Stock Monitoring (Vendor). Shows component stock at the subcontractor and what needs to be sent; it does not calculate yield or waste.
  • MBLB Stocks at Subcontractor. Lists stock at the vendor; it does not reconcile it with quantities sent and returned.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderSubcontracting order header and subcontractor (driving table)—ECC + S/4
EKPOPurchasing Document ItemSubcontracting order item: finished material to return and order quantityEKPO-EBELN = EKKO-EBELNECC + S/4
RESBReservation/Dependent RequirementsComponents to be provided for the order itemRESB-EBELN = EKPO-EBELN AND RESB-EBELP = EKPO-EBELPECC + S/4
MSEGMaterial Document Item541/542 transfers, 101/102/122 finished goods receiptsMSEG-EBELN = EKPO-EBELN AND MSEG-EBELP = EKPO-EBELPECC + S/4
MKPFMaterial Document HeaderPosting dateMKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHRECC + S/4
MSLBSpecial Stocks with VendorComponent stock at the subcontractorMSLB-LIFNR = EKKO-LIFNR AND MSLB-MATNR = RESB-MATNRECC + S/4
MARMUnits of Measure for MaterialUnit conversion between kg and metersMARM-MATNR = EKPO-MATNRECC + S/4
LFA1Vendor Master (General Section)Subcontractor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
MBEWMaterial ValuationComponent price for the waste valueMBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKSECC + S/4
I_MaterialDocumentItem_2Material Document Item (CDS)In S/4HANA it can replace MSEG with a clean core approachPurchaseOrder = EKPO-EBELNS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_EKORGPurchasing organizationRange / multipleEKKO-EKORGNo1000
S_WERKSPlantRange / multipleEKPO-WERKSYes1000
S_LIFNRSubcontractorRange / multipleEKKO-LIFNRNo—
S_BUDATPosting date rangeRange / multipleMKPF-BUDATYes01.10.2026 – 31.10.2026
S_MATNRComponent sentRange / multipleRESB-MATNRNoHK-*
P_TOLERYield variance tolerance (%)Single value—No3

Output columns

#ColumnSource
1SubcontractorLFA1-NAME1
2OrderEKPO-EBELN
3ItemEKPO-EBELP
4Finished materialEKPO-MATNR
5Component sentRESB-MATNR
6Quantity sentCalculated Σ MSEG-MENGE (541) − Σ MSEG-MENGE (542)
7Left at subcontractorMSLB-LBLAB
8Processed inputCalculated Sent − left at subcontractor
9Finished quantity returnedCalculated Σ MSEG-MENGE (101) − Σ (102, 122)
10Expected yieldCalculated EKPO-MENGE / RESB-BDMNG
11Actual yieldCalculated Finished returned / processed input (converted to the same unit via MARM)
12Yield variance %Calculated (Actual yield − expected yield) / expected yield × 100
13Unexplained wasteCalculated Processed input − finished returned / expected yield
14Waste valueCalculated Unexplained waste × MBEW price / price unit

Sample output

SubcontractorOrderItemFinished materialComponent sentQuantity sentLeft at subcontractorProcessed inputFinished quantity returnedExpected yieldActual yieldYield variance %Unexplained wasteWaste value
Ege Boya Fason Ltd.450002104000010KM-PNY-220-LACHK-PNY-220-HAM2,4001802,2207,6603.603.45-4.209211,040
Marmara Baskı San.450002105200010KM-SAT-150-DSNHK-SAT-150-HAM1,20001,2004,3803.703.65-1.40162,560
Ege Boya Fason Ltd.450002106600020KM-DNM-160-INDHK-DNM-160-HAM3,1004202,6807,92032.96-1.50405,200
Trakya Apre A.Ş.450002107100010KM-KTN-180-BEJHK-KTN-180-HAM95009503,0603.403.22-5.30507,000
A view built with fictional sample data; not real system data.

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.

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

MM Report Custom ALV report

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 …

EKKO · EKPO · EKET · EKBE

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: Subcontract Processing Yield and Waste Reconciliation Report