QM Report Custom development ALV report

Skip Lots and Dynamic Modification Status by Vendor and Material Report

Short answer: A custom ALV report that shows per vendor and material how many goods receipt inspection lots were skipped without inspection because of the dynamic modification rule. Risky cases, where a vendor with a recent rejection or an open quality notification is still delivering skip lots, are flagged separately.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
7
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

The dynamic modification rule and the quality level are maintained and displayed record by record; there is no plant-wide list showing which vendor is skipped at what rate. QA33 lists inspection lots and can show skip lots, but it does not give the skip rate per vendor and material, the recent rejections and open notifications on the same line. Auditing whether the skip rules still work correctly needs a custom report.

Who uses it? Supplier quality engineers, incoming inspection teams, quality managers and purchasing.

Closest standard alternatives

  • QA33 Display Data for Inspection Lot. Lists inspection lots; does not show the skip rate or risk per vendor and material.
  • QA32 Change Data for Inspection Lot. Inspection lot worklist; does not total skip lots.

Tables used

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

TableRoleJoinSystem
QALSInspection Lot RecordGoods receipt inspection lots, skip indicator, rule and stage (driving table)—ECC + S/4
QDPSInspection Stages for a Dynamic Modification RuleStages of the dynamic modification rule and skip indicatorQDPS-DYNREGEL = QALS-DYNREGEL AND QDPS-PRSTUFE = QALS-PRSTUFEECC + S/4
QDQLQuality LevelCurrent quality level record for the vendor and materialQDQL-MATNR = QALS-MATNR AND QDQL-WERKS = QALS-WERK AND QDQL-LIFNR = QALS-LIFNR AND QDQL-PRUEFART = QALS-ARTECC + S/4
QAVEUsage DecisionUsage decision and valuationQAVE-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QMELNotification HeaderOpen quality notifications for the vendor and materialQMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = QALS-LIFNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_LIFNRVendorRange / multipleQALS-LIFNRNo100245
S_MATNRMaterialRange / multipleQALS-MATNRNoRM-2051
S_ARTInspection typeRange / multipleQALS-ARTNo01
S_DATELot creation date rangeRange / multipleQALS-ENSTEHDATYes01.05.2026 – 31.10.2026
S_DYNDynamic modification ruleRange / multipleQALS-DYNREGELNoS01
P_RISKRisky lines onlyCheckbox—No—

Output columns

#ColumnSource
1VendorQALS-LIFNR
2Vendor nameLFA1-NAME1
3MaterialQALS-MATNR
4Material descriptionMAKT-MAKTX
5Dynamic ruleQALS-DYNREGEL
6Latest stageQALS-PRSTUFE
7Skip stageQDPS-KZSKIP
8Total lotsCalculated Number of goods receipt lots in the period
9Skipped lotsCalculated Number of lots with QALS-KZSKIPLOT = X
10Skip rate %Calculated Skipped lots ÷ total lots × 100
11Rejected lotsCalculated Number of lots with QAVE-VBEWERTUNG = R
12Lot that updated the levelQDQL-PRUEFLOS
13Open notificationsCalculated Incomplete QMEL records for the vendor and material
14RiskCalculated X when skip lots exist while there is a rejection or an open notification

Sample output

VendorVendor nameMaterialMaterial descriptionDynamic ruleLatest stageSkip stageTotal lotsSkipped lotsSkip rate %Rejected lotsLot that updated the levelOpen notificationsRisk
100245Bursa Metal SanayiRM-2051Steel sheet 3 mmS0103X24187510100000188401X
100310Kuzey Ahşap ÜrünleriRM-4410Plywood 18 mmS010212433.3000100000187910
100388Konya Kalıp ve PlastikRM-3602Plastic cap 40 mmS0201300030100000189022
100412Trakya AmbalajRM-1205Corrugated board sheetS0103X40348500100000188660
A view built with fictional sample data; not real system data.

How does the report work?

  1. Goods receipt inspection lots (QALS, HERKUNFT = 01) created in the selected period are read with the plant, vendor and material filters.
  2. The skip indicator (KZSKIPLOT), dynamic modification rule (DYNREGEL) and inspection stage (PRSTUFE) of each lot are taken; whether the stage is a skip stage is read from QDPS-KZSKIP.
  3. The usage decision is read from QAVE; lots with VBEWERTUNG = R count as rejected.
  4. Per vendor and material the total lots, skipped lots, inspected lots, rejected lots and the skip rate are calculated. The current quality level record from QDQL (material, plant, vendor, inspection type) and the lot that last updated it (QDQL-PRUEFLOS) are shown.
  5. Incomplete quality notifications for the same vendor and material are counted from QMEL (LIFNUM, MATNR). If skip lots were received while there was a rejection or an open notification in the period, the line is flagged as “risk”. Vendor and material names come from LFA1 and MAKT.

Performance notes

Read QALS with the goods receipt origin, plant and creation date range. Read QAVE and QMEL in bulk with the lot and vendor lists; do the aggregation in memory.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document A line drills down to the lot list of that vendor and material, and from there to QA03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Risky lines can be sent monthly to the supplier quality team.

Authorization objects

  • Q_INSPTYPEInspection lot authorization by inspection type
  • Q_QMELQuality notification display authorization

Frequently asked questions

What is a skip lot?

Under the dynamic modification rule, once a vendor has delivered a set number of lots without problems, the following lots are accepted without inspection. These lots are created with the skip indicator, and in most setups the usage decision is made automatically.

Why does the "risk" flag matter?

A rejection normally moves the quality level back to a stricter stage. If skip lots still arrive after a rejection, the rule may be maintained incorrectly, the quality level may have been changed manually or the rejection was made under another inspection type. These lines are the first place to look in an audit.

Does it work on S/4HANA?

Yes. QALS, QDPS, QDQL and QAVE are used with the same fields on S/4HANA; the report runs unchanged.

Packages that include this solution

QM Package Custom

Supplier Quality Management Pack

A four-component pack that follows supplier quality from approval to evaluation: quality info record release and certificate validity, lots skipped by …

4 components · v1.0

Related reports

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: Skip Lots and Dynamic Modification Status by Vendor and Material Report