QM Program Custom development Background program

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

  • QM12 Change List of Tasks. Lists tasks; sends no reminder to the owner.
  • QM02 Change Quality Notification. Changes tasks one notification at a time.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
QMELNotification HeaderQuality notification header, type and short textReadECC + S/4
QMSMNotification TasksNotification tasks, owner and planned finish dateReadECC + S/4
USR21User Name to Address Key AssignmentUser's address and person numberReadECC + S/4
ADR6E-Mail Addresses (Business Address Services)Owner's email addressReadECC + S/4

BAPIs and functions used

  • SO_DOCUMENT_SEND_API1SAPoffice: Send Document with Attachments. Emails the task list to each owner

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_QMARTNotification typeRange / multipleQMEL-QMARTYesQ1, Q2, Q3
S_WERKPlantRange / multipleQMEL-MAWERKNo1000
S_PARNRResponsibleRange / multipleQMSM-PARNRNo—
P_LEADDays ahead for upcoming tasksSingle value—No3
P_ESCDays overdue for escalationSingle value—No7
P_CCQuality manager email addressSingle value—No[email protected]
P_TESTTest mode (list without sending email)Checkbox—NoX

Result list columns

#ColumnSource
1ResponsibleQMSM-PARNR
2EmailADR6-SMTP_ADDR
3NotificationQMEL-QMNUM
4Notification textQMEL-QMTXT
5Task textQMSM-MATXT
6Planned finishQMSM-PETER
7Overdue (days)Calculated Today − QMSM-PETER (a negative value is days left)
8SendingCalculated Sent, sent with escalation, test, no address or error

Sample result list

ResponsibleEmailNotificationNotification textTask textPlanned finishOverdue (days)Sending
KALITE01[email protected]200001388Cap diameter out of toleranceRoot cause analysis (8D D4)11/06/202611Sent with escalation
KALITE01[email protected]200001402Scratches on sheet surfaceGet corrective action plan from vendor11/14/20263Sent
URETIM04[email protected]200001410Coating thickness too highVerify spray gun setting11/19/2026-2Sent
DEPO02200001415Damp carton deliveryCheck storage conditions11/12/20265No address
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. Tasks whose planned finish date (PETER) is before today are classified as “overdue”, those within the day count in the parameter as “upcoming”.
  3. 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.
  4. 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.
  5. 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

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

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.

Related report: Automatic Reminder Email for Overdue Quality Notification Tasks