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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QALSInspection Lot Record | Goods receipt inspection lots, skip indicator, rule and stage (driving table) | — | ECC + S/4 |
| QDPSInspection Stages for a Dynamic Modification Rule | Stages of the dynamic modification rule and skip indicator | QDPS-DYNREGEL = QALS-DYNREGEL AND QDPS-PRSTUFE = QALS-PRSTUFE | ECC + S/4 |
| QDQLQuality Level | Current quality level record for the vendor and material | QDQL-MATNR = QALS-MATNR AND QDQL-WERKS = QALS-WERK AND QDQL-LIFNR = QALS-LIFNR AND QDQL-PRUEFART = QALS-ART | ECC + S/4 |
| QAVEUsage Decision | Usage decision and valuation | QAVE-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QMELNotification Header | Open quality notifications for the vendor and material | QMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes | 1000 |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No | 100245 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | RM-2051 |
| S_ART | Inspection type | Range / multiple | QALS-ART | No | 01 |
| S_DATE | Lot creation date range | Range / multiple | QALS-ENSTEHDAT | Yes | 01.05.2026 – 31.10.2026 |
| S_DYN | Dynamic modification rule | Range / multiple | QALS-DYNREGEL | No | S01 |
| P_RISK | Risky lines only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Vendor | QALS-LIFNR |
| 2 | Vendor name | LFA1-NAME1 |
| 3 | Material | QALS-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Dynamic rule | QALS-DYNREGEL |
| 6 | Latest stage | QALS-PRSTUFE |
| 7 | Skip stage | QDPS-KZSKIP |
| 8 | Total lots | Calculated Number of goods receipt lots in the period |
| 9 | Skipped lots | Calculated Number of lots with QALS-KZSKIPLOT = X |
| 10 | Skip rate % | Calculated Skipped lots ÷ total lots × 100 |
| 11 | Rejected lots | Calculated Number of lots with QAVE-VBEWERTUNG = R |
| 12 | Lot that updated the level | QDQL-PRUEFLOS |
| 13 | Open notifications | Calculated Incomplete QMEL records for the vendor and material |
| 14 | Risk | Calculated X when skip lots exist while there is a rejection or an open notification |
Sample output
| Vendor | Vendor name | Material | Material description | Dynamic rule | Latest stage | Skip stage | Total lots | Skipped lots | Skip rate % | Rejected lots | Lot that updated the level | Open notifications | Risk |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100245 | Bursa Metal Sanayi | RM-2051 | Steel sheet 3 mm | S01 | 03 | X | 24 | 18 | 75 | 1 | 010000018840 | 1 | X |
| 100310 | Kuzey Ahşap Ürünleri | RM-4410 | Plywood 18 mm | S01 | 02 | 12 | 4 | 33.30 | 0 | 010000018791 | 0 | ||
| 100388 | Konya Kalıp ve Plastik | RM-3602 | Plastic cap 40 mm | S02 | 01 | 30 | 0 | 0 | 3 | 010000018902 | 2 | ||
| 100412 | Trakya Ambalaj | RM-1205 | Corrugated board sheet | S01 | 03 | X | 40 | 34 | 85 | 0 | 010000018866 | 0 |
How does the report work?
- Goods receipt inspection lots (QALS, HERKUNFT = 01) created in the selected period are read with the plant, vendor and material filters.
- 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.
- The usage decision is read from QAVE; lots with VBEWERTUNG = R count as rejected.
- 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.
- 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
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 …
Related reports
Automatic Vendor Quality Notification Creation for Rejected Characteristics
A custom background job that automatically opens a quality notification against the vendor for goods receipt lots with a rejected characteristic. The …
Vendor Quality Scorecard and Rejection Rate (PPM) Report
A custom ALV report that shows, per vendor and material, the lot rejection rate from goods receipt inspection lots, the rejected quantity in parts per …
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.