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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QMELNotification Header | Customer complaint: customer, delivery, material, batch and complaint quantity (driving table) | — | ECC + S/4 |
| QMFENotification Items | Defect code of the notification | QMFE-QMNUM = QMEL-QMNUM | ECC + S/4 |
| LIPSDelivery Item Data | Batch from the delivery item when the notification has none | LIPS-VBELN = QMEL-LS_VBELN AND LIPS-POSNR = QMEL-LS_POSNR | ECC + S/4 |
| QALSInspection Lot Record | Production or goods receipt inspection lot of the batch | QALS-MATNR = QMEL-MATNR AND QALS-CHARG = QMEL-CHARG | ECC + S/4 |
| QAVEUsage Decision | Usage decision of the inspection lot | QAVE-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMRCharacteristic Results During Inspection Processing | Rejected characteristics | QAMR-PRUEFLOS = QALS-PRUEFLOS AND QAMR-MBEWERTG = 'R' | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = QMEL-KUNUM | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_QMART | Customer complaint notification type | Range / multiple | QMEL-QMART | Yes | Q1 |
| S_KUNUM | Customer | Range / multiple | QMEL-KUNUM | No | 200310 |
| S_MATNR | Material | Range / multiple | QMEL-MATNR | No | FG-2050 |
| S_CHARG | Batch | Range / multiple | QMEL-CHARG | No | P2610-22 |
| S_QMDAT | Notification date | Range / multiple | QMEL-QMDAT | Yes | 01.07.2026 – 17.11.2026 |
| S_VKORG | Sales organization | Range / multiple | QMEL-VKORG | No | 1000 |
| P_ALLLOT | Show all inspection lots of the batch | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Notification | QMEL-QMNUM |
| 2 | Notification date | QMEL-QMDAT |
| 3 | Customer | QMEL-KUNUM |
| 4 | Customer name | KNA1-NAME1 |
| 5 | Delivery | QMEL-LS_VBELN |
| 6 | Material | QMEL-MATNR |
| 7 | Batch | QMEL-CHARG |
| 8 | Complaint qty | QMEL-RKMNG |
| 9 | Defect code | QMFE-FECOD |
| 10 | Inspection lot | QALS-PRUEFLOS |
| 11 | Lot origin | QALS-HERKUNFT |
| 12 | Usage decision | QAVE-VCODE |
| 13 | Rejected characteristics | Calculated Number of characteristics with QAMR-MBEWERTG = R |
| 14 | Complaints on same batch | Calculated Number of notifications for the same QMEL-MATNR and QMEL-CHARG |
Sample output
| Notification | Notification date | Customer | Customer name | Delivery | Material | Batch | Complaint qty | Defect code | Inspection lot | Lot origin | Usage decision | Rejected characteristics | Complaints on same batch |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 000300001245 | 10/14/2026 | 200310 | Kuzey Gıda Dağıtım | 0080044871 | FG-2050 | P2610-22 | 120 | NEM-01 | 040000001802 | 04 | A1 | 0 | 2 |
| 000300001252 | 10/21/2026 | 200510 | Ege Tarım Kooperatifi | 0080044930 | FG-2050 | P2610-22 | 60 | NEM-01 | 040000001802 | 04 | A1 | 0 | 2 |
| 000300001271 | 11/05/2026 | 200145 | Marmara Yapı Market | 0080045011 | FG-1002 | P2610-30 | 24 | ETK-03 | 040000001835 | 04 | A3 | 1 | 1 |
How does the report work?
- QMEL is read with the customer complaint notification types, customer, material, date and sales organization from the selection screen.
- If the batch is empty on the notification, it is taken from the delivery item (QMEL-LS_VBELN / LS_POSNR → LIPS-CHARG).
- 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.
- The usage decision of the lot comes from QAVE and the number of rejected characteristics from QAMR records with MBEWERTG = R.
- 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
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 …
Related reports
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 …
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 …
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.