MM Report Custom development ALV report

Subcontracting Component Consumption and Stock at Vendor Reconciliation Report

Short answer: A custom ALV report that compares the planned consumption of components sent to the vendor on subcontracting orders with the consumption posted at finished goods receipt (543) and lists it together with the stock left at the vendor. Excess consumption, scrap and overdue subcontracting deliveries show up in one list.

Estimated effort
M · 5–7 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

ME2O monitors the component stock provided to the vendor and the requirements, and MBLB lists the stock at the vendor, but neither compares the actual component consumption at finished goods receipt with the consumption expected for the finished quantity and shows excess consumption and overdue subcontracting deliveries on the same line. Year-end stock reconciliation with the vendor is therefore done by hand with MB51 and ME2O output.

Who uses it? Subcontracting and purchasing specialists, production planning, inventory control and costing teams.

Closest standard alternatives

  • MBLB Stocks at Subcontractor. Lists stock at the vendor; does not compare expected and actual consumption by order.
  • MB51 Material Document List. Lists the 543 consumption documents; planned quantity and finished goods receipt are not on the same line.

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: vendor (driving table)—ECC + S/4
EKPOPurchasing Document ItemSubcontracting item: finished material, order quantity, item categoryEKPO-EBELN = EKKO-EBELNECC + S/4
EKETPurchasing Schedule LinesSubcontracting delivery dateEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
RESBReservation/Dependent RequirementsSubcontracting components: planned component quantityRESB-EBELN = EKPO-EBELN AND RESB-EBELP = EKPO-EBELPECC + S/4
EKBEPurchasing Document HistoryFinished goods receiptsEKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELPECC + S/4
MSEGMaterial Document ItemComponent consumption movements (543/544)MSEG-EBELN = EKPO-EBELN AND MSEG-EBELP = EKPO-EBELP AND MSEG-MATNR = RESB-MATNRECC + S/4
MSLBSpecial Stocks with VendorSpecial stock at the vendor (SOBKZ = O)MSLB-LIFNR = EKKO-LIFNR AND MSLB-MATNR = RESB-MATNR AND MSLB-WERKS = EKPO-WERKSECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4

S/4HANA notes

  • MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
  • 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.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LIFNRSubcontractorRange / multipleEKKO-LIFNRNo100733
S_WERKSPlantRange / multipleEKPO-WERKSYes1100
S_EBELNPurchase orderRange / multipleEKPO-EBELNNo4500013320
S_MATNRComponent materialRange / multipleRESB-MATNRNoRM-2040
S_EINDTSubcontracting delivery dateRange / multipleEKET-EINDTNo01.09.2026 – 30.11.2026
P_TOLPCTConsumption variance tolerance (%)Single value—No2
P_OPENOnly items not fully deliveredCheckbox—No—
P_KEYDTKey date for overdue checkSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1VendorEKKO-LIFNR
2Vendor nameLFA1-NAME1
3Purchase orderEKPO-EBELN
4ItemEKPO-EBELP
5Finished materialEKPO-MATNR
6ComponentRESB-MATNR
7Order qtyEKPO-MENGE
8Finished receivedCalculated Σ EKBE-MENGE (VGABE = 1, reversals negative)
9Delivery dateEKET-EINDT
10Planned componentRESB-BDMNG
11Expected consumptionCalculated RESB-BDMNG × finished received ÷ EKPO-MENGE
12Actual consumptionCalculated Σ MSEG-MENGE (BWART 543, 544 negative)
13Excess consumptionCalculated Actual − expected consumption
14UnitRESB-MEINS
15Stock at vendorMSLB-LBLAB
16StatusCalculated Matched, excess consumption, under-consumption or delivery overdue

Sample output

VendorVendor namePurchase orderItemFinished materialComponentOrder qtyFinished receivedDelivery datePlanned componentExpected consumptionActual consumptionExcess consumptionUnitStock at vendorStatus
100733Kuzey Döküm450001332000010FG-5010RM-20401,00080011/05/20262,5002,0002,140140KG360Excess consumption
100733Kuzey Döküm450001332000010FG-5010CH-03151,00080011/05/20265040400KG10Matched
100841Anadolu Kaplama450001335600020FG-6120PK-1180600010/28/2026600000PC600Delivery overdue
A view built with fictional sample data; not real system data.

How does the report work?

  1. EKKO and EKPO are read by vendor, plant and order number; only the subcontracting item category (EKPO-PSTYP = 3) and non-deleted items remain.
  2. Components are read from RESB by order item (RESB-EBELN, RESB-EBELP); deleted components (XLOEK) are excluded. The planned component quantity is RESB-BDMNG.
  3. The received finished quantity is summed net from EKBE (VGABE = 1). Actual consumption is summed from 543 movements in MSEG (544 reversals negative) by order item and component material.
  4. Expected consumption = RESB-BDMNG × received finished qty ÷ EKPO-MENGE; excess consumption = actual − expected. If the difference exceeds the tolerance percentage the line is flagged as excess, if it is below as under-consumption. If EKET-EINDT is before the key date and the finished goods have not fully arrived, the line counts as overdue.
  5. Stock at the vendor is added from MSLB per vendor and component (LBLAB + LBINS); the subtotal at vendor + component level gives the reconciliation of shipped, consumed and remaining quantities.

Performance notes

The number of subcontracting orders is usually limited; read RESB for the order list and MSEG for movement type 543 and the order list. For the yearly reconciliation, running in the background and exporting to Excel is enough.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order number opens ME23N, the actual consumption opens the 543 documents in MB51 and the stock at vendor opens MBLB.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • M_BEST_EKOPurchase order display authorization by purchasing organization
  • M_BEST_WRKPurchase order display authorization by plant
  • M_MSEG_WWAGoods movement authorization by plant

Frequently asked questions

Why does excess consumption occur?

The component consumption may have been increased by hand at the finished goods receipt, the vendor may have reported scrap or the component unit conversion may be wrong. The report shows the difference; the reason is clarified with the vendor and the subcontracting owner.

Why is the stock at the vendor not shown per order?

SAP keeps the special stock at the vendor (MSLB) at vendor, plant and material level, not per order. The report therefore shows the stock at the vendor in the component subtotal and gives the shipped, consumed and remaining reconciliation at that level.

Does the report work on S/4HANA?

Yes. Subcontracting orders, RESB and the order history keep the same structure in S/4HANA; the MSEG and MSLB reads work through compatibility views.

Related reports

MM Report Custom ALV report

Open Purchase Orders by Vendor Report

A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …

EKKO · EKPO · EKET · LFA1

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: Subcontracting Component Consumption and Stock at Vendor Reconciliation Report