Automatic Reminder Email for Overdue Quality Notification Tasks
Short answer: A custom background job that checks corrective and preventive action tasks on quality notifications against their planned finish date and emails each responsible person a list of their own overdue and upcoming tasks. When a delay exceeds a set number of days, the quality manager is copied in.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
QM02 manages tasks notification by notification; QM12 lists tasks but sends nothing to the owner. A workflow (SAP Business Workflow) can be set up to remind task owners, but that needs its own design and maintenance. Closing corrective actions on time needs a lightweight job that emails the owner regularly.
Who uses it? Quality managers, 8D and CAPA process owners, task owners and internal audit teams.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| QMELNotification Header | Quality notification header, type and short text | Read | ECC + S/4 |
| QMSMNotification Tasks | Notification tasks, owner and planned finish date | Read | ECC + S/4 |
| USR21User Name to Address Key Assignment | User's address and person number | Read | ECC + S/4 |
| ADR6E-Mail Addresses (Business Address Services) | Owner's email address | Read | ECC + S/4 |
BAPIs and functions used
- SO_DOCUMENT_SEND_API1SAPoffice: Send Document with Attachments. Emails the task list to each owner
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_QMART | Notification type | Range / multiple | QMEL-QMART | Yes | Q1, Q2, Q3 |
| S_WERK | Plant | Range / multiple | QMEL-MAWERK | No | 1000 |
| S_PARNR | Responsible | Range / multiple | QMSM-PARNR | No | — |
| P_LEAD | Days ahead for upcoming tasks | Single value | — | No | 3 |
| P_ESC | Days overdue for escalation | Single value | — | No | 7 |
| P_CC | Quality manager email address | Single value | — | No | [email protected] |
| P_TEST | Test mode (list without sending email) | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Responsible | QMSM-PARNR |
| 2 | ADR6-SMTP_ADDR | |
| 3 | Notification | QMEL-QMNUM |
| 4 | Notification text | QMEL-QMTXT |
| 5 | Task text | QMSM-MATXT |
| 6 | Planned finish | QMSM-PETER |
| 7 | Overdue (days) | Calculated Today − QMSM-PETER (a negative value is days left) |
| 8 | Sending | Calculated Sent, sent with escalation, test, no address or error |
Sample result list
| Responsible | Notification | Notification text | Task text | Planned finish | Overdue (days) | Sending | |
|---|---|---|---|---|---|---|---|
| KALITE01 | [email protected] | 200001388 | Cap diameter out of tolerance | Root cause analysis (8D D4) | 11/06/2026 | 11 | Sent with escalation |
| KALITE01 | [email protected] | 200001402 | Scratches on sheet surface | Get corrective action plan from vendor | 11/14/2026 | 3 | Sent |
| URETIM04 | [email protected] | 200001410 | Coating thickness too high | Verify spray gun setting | 11/19/2026 | -2 | Sent |
| DEPO02 | 200001415 | Damp carton delivery | Check storage conditions | 11/12/2026 | 5 | No address |
How does the program work?
- Quality notifications (QMEL) and their tasks (QMSM) are read for the selected notification types and plants; tasks that are not completed (ERLDAT empty) and not deleted (KZLOESCH empty) are taken.
- Tasks whose planned finish date (PETER) is before today are classified as “overdue”, those within the day count in the parameter as “upcoming”.
- The task owner is determined from QMSM-PARVW and PARNR. If the owner is an SAP user, the email address is read from ADR6 via USR21; for other partner types the address is taken from the partner master data. Tasks without an address are collected in the list sent to the quality manager.
- One email is prepared per owner: notification number, notification short text, task text, planned finish and days overdue. When the delay exceeds the escalation day count, the quality manager is copied in. The email is sent with SO_DOCUMENT_SEND_API1.
- In test mode no email is sent; only who would receive what is listed. The sending result is written to the job log; notifications are not changed.
Performance notes
Schedule the job once a day before working hours. Read QMSM in bulk with the notification list; read the addresses once with the list of owners.
Features
- Runs as a background job
- Send the result by email Each owner receives a single summary email, however many tasks they have.
- Test mode (check without posting)
- Line-by-line result and error log
- ALV list (sort, filter, subtotals)
Authorization objects
- Q_QMELQuality notification display authorization by notification type
- S_OC_SENDAuthorization to send email
Frequently asked questions
What if the owner is a personnel number or a vendor?
The address is read from the relevant master data according to the partner type. If no address is found, the task is not lost; it appears as "no address" in the list sent to the quality manager.
Can the email text be in Turkish and English?
Yes. The text is prepared in the owner's user language; Turkish and English templates are part of the delivery.
Does it work on S/4HANA?
Yes. QMEL, QMSM and the address tables are the same on S/4HANA. Email sending can also be done with the BCS classes if preferred.
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
Automatic Vendor Quality Notification Creation for Rejected Characteristics
A custom background job that automatically opens a quality notification against the vendor for goods receipt lots with a rejected characteristic. The …
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 …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.