QM Report Custom development ALV report

Customer Complaints Traced to Delivery, Batch and Inspection Lot Report

Short answer: A custom ALV report that shows customer complaint notifications on the same line as the delivery, the batch, the inspection lot of that batch, its usage decision and the number of rejected characteristics. Quality teams see at a glance how the complained batch was judged in production or at goods receipt, and whether other complaints came from the same batch.

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

Why is the standard not enough?

QM10 lists customer complaints; the delivery and batch are on the notification, but the production or goods receipt inspection lot of that batch, its usage decision and failed characteristics have to be looked up separately in QA03. MB56 traces where a batch came from but shows no quality result. No standard list shows the complaint and the inspection result on the same line.

Who uses it? Customer quality engineers, quality managers, production and laboratory supervisors.

Closest standard alternatives

  • QM10 Change List of Quality Notifications. Lists customer complaints; the inspection result and usage decision of the batch are not on the same line.
  • QA33 Display Data for Inspection Lot. Lists inspection lots with their decision; does not link them to customer complaints.

Tables used

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

TableRoleJoinSystem
QMELNotification HeaderCustomer complaint: customer, delivery, material, batch and complaint quantity (driving table)—ECC + S/4
QMFENotification ItemsDefect code of the notificationQMFE-QMNUM = QMEL-QMNUMECC + S/4
LIPSDelivery Item DataBatch from the delivery item when the notification has noneLIPS-VBELN = QMEL-LS_VBELN AND LIPS-POSNR = QMEL-LS_POSNRECC + S/4
QALSInspection Lot RecordProduction or goods receipt inspection lot of the batchQALS-MATNR = QMEL-MATNR AND QALS-CHARG = QMEL-CHARGECC + S/4
QAVEUsage DecisionUsage decision of the inspection lotQAVE-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QAMRCharacteristic Results During Inspection ProcessingRejected characteristicsQAMR-PRUEFLOS = QALS-PRUEFLOS AND QAMR-MBEWERTG = 'R'ECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = QMEL-KUNUMECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_QMARTCustomer complaint notification typeRange / multipleQMEL-QMARTYesQ1
S_KUNUMCustomerRange / multipleQMEL-KUNUMNo200310
S_MATNRMaterialRange / multipleQMEL-MATNRNoFG-2050
S_CHARGBatchRange / multipleQMEL-CHARGNoP2610-22
S_QMDATNotification dateRange / multipleQMEL-QMDATYes01.07.2026 – 17.11.2026
S_VKORGSales organizationRange / multipleQMEL-VKORGNo1000
P_ALLLOTShow all inspection lots of the batchCheckbox—No—

Output columns

#ColumnSource
1NotificationQMEL-QMNUM
2Notification dateQMEL-QMDAT
3CustomerQMEL-KUNUM
4Customer nameKNA1-NAME1
5DeliveryQMEL-LS_VBELN
6MaterialQMEL-MATNR
7BatchQMEL-CHARG
8Complaint qtyQMEL-RKMNG
9Defect codeQMFE-FECOD
10Inspection lotQALS-PRUEFLOS
11Lot originQALS-HERKUNFT
12Usage decisionQAVE-VCODE
13Rejected characteristicsCalculated Number of characteristics with QAMR-MBEWERTG = R
14Complaints on same batchCalculated Number of notifications for the same QMEL-MATNR and QMEL-CHARG

Sample output

NotificationNotification dateCustomerCustomer nameDeliveryMaterialBatchComplaint qtyDefect codeInspection lotLot originUsage decisionRejected characteristicsComplaints on same batch
00030000124510/14/2026200310Kuzey Gıda Dağıtım0080044871FG-2050P2610-22120NEM-0104000000180204A102
00030000125210/21/2026200510Ege Tarım Kooperatifi0080044930FG-2050P2610-2260NEM-0104000000180204A102
00030000127111/05/2026200145Marmara Yapı Market0080045011FG-1002P2610-3024ETK-0304000000183504A311
A view built with fictional sample data; not real system data.

How does the report work?

  1. QMEL is read with the customer complaint notification types, customer, material, date and sales organization from the selection screen.
  2. If the batch is empty on the notification, it is taken from the delivery item (QMEL-LS_VBELN / LS_POSNR → LIPS-CHARG).
  3. The inspection lots in QALS for the material and batch are found (production origin 04 or goods receipt 01); by default the latest lot is shown, optionally all of them.
  4. The usage decision of the lot comes from QAVE and the number of rejected characteristics from QAMR records with MBEWERTG = R.
  5. The first defect code of the notification is added from QMFE; other complaints for the same material and batch are counted. The customer name comes from KNA1.

Performance notes

Narrow QMEL by notification type and date. Read QALS once with the material–batch list; check whether QALS has a secondary index on material and batch.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the notification opens QM03; double-clicking the inspection lot opens QA03.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • Q_QMELQuality notification display authorization by notification type
  • Q_INSPTYPEInspection lot authorization by inspection type

Frequently asked questions

Does the report work without batch management?

Without batches, the link to the inspection lot can be made by material and date range, but the match is not exact. The report works best for batch-managed materials.

Can it go down to the component batches?

Yes. By reading the batch where-used records, the component batches of the finished batch and their goods receipt inspection lots can be shown in an extra view; this raises the effort range.

Does the report work on S/4HANA?

Yes. QMEL, QMFE, QALS, QAVE and QAMR keep the same structure in S/4HANA.

Packages that include this solution

QM Package Custom

Customer Complaint and Root Cause Pack

A five-component pack that follows a customer complaint from intake to improvement: automatic complaint notifications from a portal or call centre …

5 components · v1.0

Related reports

QM Report Custom ALV report

Overdue Quality Notifications and Open Tasks Report

A custom ALV report that lists open quality notifications with the days past the required end date, the number of open and overdue tasks, and the next …

QMEL · JEST · TJ02T · QMSM

SD Report Custom ALV report

Returns and Credit Memos by Return Reason Report

A custom ALV report that lists return orders with the return reason, the original invoice, the goods receipt of the return delivery and the credit …

VBAK · VBAP · VBFA · LIKP

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: Customer Complaints Traced to Delivery, Batch and Inspection Lot Report