QM Report Custom development ALV report

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

  • QA08 Collective Processing of Inspection Setup. Activates and changes inspection setups in bulk; does not report missing or inconsistent setups by rule.
  • MM03 Display Material. Shows the quality management view one material at a time.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
MARCPlant Data for MaterialPlant data: inspection setup flag, QM control key, batch management, inspection interval (driving table)—ECC + S/4
MARAGeneral Material DataMaterial type and shelf lifeMARA-MATNR = MARC-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MARC-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
QMATInspection Type - Material ParametersInspection types per material and inspection setup flagsQMAT-MATNR = MARC-MATNR AND QMAT-WERKS = MARC-WERKSECC + S/4
MAPLAssignment of Task Lists to MaterialsInspection plan assigned to the material (PLNTY = Q)MAPL-MATNR = MARC-MATNR AND MAPL-WERKS = MARC-WERKSECC + S/4
I_ProductInspTypeSettingSettings for Inspection Type in ProductIn S/4HANA it can replace QMAT with a clean core approachProduct = MARC-MATNRS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleMARC-WERKSYes1000
S_MTARTMaterial typeRange / multipleMARA-MTARTNoROH
S_MATNRMaterialRange / multipleMARC-MATNRNoRM-1001
S_ARTExpected inspection typesRange / multipleQMAT-ARTNo01
P_PLANCheck task list assignmentCheckbox—NoX
P_ONLYERProblem materials onlyCheckbox—NoX
P_MMSTAExclude materials blocked at plant levelCheckbox—NoX

Output columns

#ColumnSource
1PlantMARC-WERKS
2MaterialMARC-MATNR
3Material descriptionMAKT-MAKTX
4Material typeMARA-MTART
5Inspection setup existsMARC-QMATV
6QM control keyMARC-SSQSS
7Inspection typeQMAT-ART
8ActiveQMAT-AKTIV
9With task listQMAT-PPL
10Plan assignedCalculated Yes if MAPL has a record with PLNTY = Q and LOEKZ empty
11Batch-managedMARC-XCHPF
12IssueCalculated Text of the rule that is violated
13Suggested actionCalculated Correction to make with QA08, QP01 or MM02, depending on the rule

Sample output

PlantMaterialMaterial descriptionMaterial typeInspection setup existsQM control keyInspection typeActiveWith task listPlan assignedBatch-managedIssueSuggested action
1000RM-1001Carton box 40x30ROHX000101XXNoInspection with task list set, no plan assignedCreate or assign an inspection plan in QP01
1000RM-2040Steel sheet 2 mmROH0001NoControl key requires QM, no inspection typeActivate inspection type 01 with QA08
2000FG-4010Hazelnut kernels 500 gFERTX04XXYesXBatch-managed with shelf life, no recurring inspection type 09Add inspection type 09 and the inspection interval (MARC-PRFRQ)
2000RM-3105Solvent-based paintROH01NoXInspection type recorded but inactive; MARC-QMATV emptyActivate the inspection type with QA08 or remove it
A view built with fictional sample data; not real system data.

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”.

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

QM Report Custom ALV report

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 …

MCHB · MCHA · MCH1 · QALS

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.

Related report: Materials with Missing or Inconsistent QM Inspection Setup Report