# Materials with Missing or Inconsistent QM Inspection Setup Report

> A custom ALV report that checks the QM settings in the material master against rules and lists each finding with a suggested action: expected inspection type missing or inactive, inspection with task list set but no plan assigned, control key requires QM but no inspection type, batch-managed material with shelf life but no recurring inspection. It is used to clean up quality master data after a go-live, an S/4HANA conversion or a mass material creation.

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: S (2–3 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/materials-missing-qm-inspection-setup-check-report/


## Why is the standard not enough?

QA08 activates or changes inspection setups in bulk, but it does not report by rule which materials have a missing or inconsistent setup. MM03 shows one material at a time. A missing setup is only noticed when no inspection lot is created at goods receipt or when results cannot be recorded for a lot without a plan. The custom report scans the whole plant and states the action for each finding.

### Closest standard alternatives

- QA08: Activates and changes inspection setups in bulk; does not report missing or inconsistent setups by rule.
- MM03: Shows the quality management view one material at a time.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MARC | Plant data: inspection setup flag, QM control key, batch management, inspection interval (driving table) | Read | - | ECC + S/4 |
| MARA | Material type and shelf life | Read | MARA-MATNR = MARC-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| QMAT | Inspection types per material and inspection setup flags | Read | QMAT-MATNR = MARC-MATNR AND QMAT-WERKS = MARC-WERKS | ECC + S/4 |
| MAPL | Inspection plan assigned to the material (PLNTY = Q) | Read | MAPL-MATNR = MARC-MATNR AND MAPL-WERKS = MARC-WERKS | ECC + S/4 |
| I_ProductInspTypeSetting | In S/4HANA it can replace QMAT with a clean core approach | Read | Product = MARC-MATNR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARC-WERKS | Yes |
| S_MTART | Material type | Range / multiple | MARA-MTART | No |
| S_MATNR | Material | Range / multiple | MARC-MATNR | No |
| S_ART | Expected inspection types | Range / multiple | QMAT-ART | No |
| P_PLAN | Check task list assignment | Checkbox | - | No |
| P_ONLYER | Problem materials only | Checkbox | - | No |
| P_MMSTA | Exclude materials blocked at plant level | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | MARC-WERKS |
| Material | MARC-MATNR |
| Material description | MAKT-MAKTX |
| Material type | MARA-MTART |
| Inspection setup exists | MARC-QMATV |
| QM control key | MARC-SSQSS |
| Inspection type | QMAT-ART |
| Active | QMAT-AKTIV |
| With task list | QMAT-PPL |
| Plan assigned | Calculated: Yes if MAPL has a record with PLNTY = Q and LOEKZ empty |
| Batch-managed | MARC-XCHPF |
| Issue | Calculated: Text of the rule that is violated |
| Suggested action | Calculated: Correction to make with QA08, QP01 or MM02, depending on the rule |

## How does the report work?

1. MARC and MARA are read by plant and material type; if selected, materials blocked at plant level (MARC-MMSTA) are skipped.
2. For each material/plant, the QMAT inspection types are read with the active flag (AKTIV) and the flags for inspection with task list (PPL), inspection with material specification (MPB) and posting to inspection stock (INSMK).
3. Rules: (a) the expected inspection type from the selection screen is missing or inactive; (b) MARC-QMATV is inconsistent with the active QMAT records; (c) a QM control key in procurement (MARC-SSQSS) is set but inspection type 01 is not active; (d) PPL is set but there is no undeleted inspection plan assignment (PLNTY = Q) in MAPL; (e) a batch-managed material (MARC-XCHPF) with shelf life (MARA-MHDHB) has no recurring inspection type 09 or no inspection interval (MARC-PRFRQ).
4. Each finding is listed as a separate line with the problem text and the suggested action (QA08, QP01 or MM02).
5. If "Problem materials only" is not selected, materials that pass all rules are also shown as "OK".

## Authorization objects

- M_MATE_WRK: Material display authorization by plant
- Q_INSPTYPE: Authorization by inspection type

## Frequently asked questions

### Can the rules be adjusted per company?

Yes. The expected inspection types can be kept in a settings table by material type and plant (e.g. 01 for raw materials, 04 for finished goods, 09 for batch-managed materials with shelf life). Each additional rule is a short development.

### How is it used in an S/4HANA conversion?

The report is run before the conversion and the findings are cleaned up; it is run again after the conversion to confirm the settings were kept. The same check is also used when a new plant is opened and after mass material uploads.

### Does the report work on S/4HANA?

Yes. MARC, MARA, QMAT and MAPL also exist in S/4HANA. For a clean core approach, the I_ProductInspTypeSetting CDS view can replace QMAT.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-material-inspection-setup-check
