Materials with Missing or Inconsistent QM Inspection Setup Report
Short answer: 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.
- Estimated effort
- S · 2–3 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? QM consultants, master data teams, quality assurance managers and project teams.
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 |
|---|---|---|---|
| MARCPlant Data for Material | Plant data: inspection setup flag, QM control key, batch management, inspection interval (driving table) | — | ECC + S/4 |
| MARAGeneral Material Data | Material type and shelf life | MARA-MATNR = MARC-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| QMATInspection Type - Material Parameters | Inspection types per material and inspection setup flags | QMAT-MATNR = MARC-MATNR AND QMAT-WERKS = MARC-WERKS | ECC + S/4 |
| MAPLAssignment of Task Lists to Materials | Inspection plan assigned to the material (PLNTY = Q) | MAPL-MATNR = MARC-MATNR AND MAPL-WERKS = MARC-WERKS | ECC + S/4 |
| I_ProductInspTypeSettingSettings for Inspection Type in Product | In S/4HANA it can replace QMAT with a clean core approach | Product = MARC-MATNR | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MARC-WERKS | Yes | 1000 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH |
| S_MATNR | Material | Range / multiple | MARC-MATNR | No | RM-1001 |
| S_ART | Expected inspection types | Range / multiple | QMAT-ART | No | 01 |
| P_PLAN | Check task list assignment | Checkbox | — | No | X |
| P_ONLYER | Problem materials only | Checkbox | — | No | X |
| P_MMSTA | Exclude materials blocked at plant level | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | MARC-WERKS |
| 2 | Material | MARC-MATNR |
| 3 | Material description | MAKT-MAKTX |
| 4 | Material type | MARA-MTART |
| 5 | Inspection setup exists | MARC-QMATV |
| 6 | QM control key | MARC-SSQSS |
| 7 | Inspection type | QMAT-ART |
| 8 | Active | QMAT-AKTIV |
| 9 | With task list | QMAT-PPL |
| 10 | Plan assigned | Calculated Yes if MAPL has a record with PLNTY = Q and LOEKZ empty |
| 11 | Batch-managed | MARC-XCHPF |
| 12 | Issue | Calculated Text of the rule that is violated |
| 13 | Suggested action | Calculated Correction to make with QA08, QP01 or MM02, depending on the rule |
Sample output
| Plant | Material | Material description | Material type | Inspection setup exists | QM control key | Inspection type | Active | With task list | Plan assigned | Batch-managed | Issue | Suggested action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | RM-1001 | Carton box 40x30 | ROH | X | 0001 | 01 | X | X | No | Inspection with task list set, no plan assigned | Create or assign an inspection plan in QP01 | |
| 1000 | RM-2040 | Steel sheet 2 mm | ROH | 0001 | No | Control key requires QM, no inspection type | Activate inspection type 01 with QA08 | |||||
| 2000 | FG-4010 | Hazelnut kernels 500 g | FERT | X | 04 | X | X | Yes | X | Batch-managed with shelf life, no recurring inspection type 09 | Add inspection type 09 and the inspection interval (MARC-PRFRQ) | |
| 2000 | RM-3105 | Solvent-based paint | ROH | 01 | No | X | Inspection type recorded but inactive; MARC-QMATV empty | Activate the inspection type with QA08 or remove it |
How does the report work?
- MARC and MARA are read by plant and material type; if selected, materials blocked at plant level (MARC-MMSTA) are skipped.
- 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).
- 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).
- Each finding is listed as a separate line with the problem text and the suggested action (QA08, QP01 or MM02).
- If “Problem materials only” is not selected, materials that pass all rules are also shown as “OK”.
Performance notes
Narrow the MARC selection by plant and material type; read QMAT and MAPL once for these materials with FOR ALL ENTRIES. The report runs in a few minutes for a whole plant and can be repeated in every test cycle before go-live.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a material opens the quality management view in MM03.
- Export to Excel The findings can be handed to the master data team in Excel as a correction list.
- Runs as a background job
Authorization objects
- M_MATE_WRKMaterial display authorization by plant
- Q_INSPTYPEAuthorization 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.
Related reports
Batches Due for Re-Test or Shelf-Life Expiry Report
A custom ALV report that lists batches in stock with their next inspection (re-test) date and shelf-life expiry date, the days remaining and any open …
Inspection Lots Awaiting Usage Decision Aging Report
A custom ALV report that lists inspection lots without a usage decision, with how many days they have been waiting, whether they exceed the target …
Mass Master Inspection Characteristic Upload from Excel Program
A custom program that creates quantitative and qualitative master inspection characteristics in bulk from Excel or CSV rows, with text, unit of …
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.