# Skip Lots and Dynamic Modification Status by Vendor and Material Report

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

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/skip-lots-dynamic-modification-status-by-vendor-material-report/


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

### Closest standard alternatives

- QA33: Lists inspection lots; does not show the skip rate or risk per vendor and material.
- QA32: Inspection lot worklist; does not total skip lots.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QALS | Goods receipt inspection lots, skip indicator, rule and stage (driving table) | Read | - | ECC + S/4 |
| QDPS | Stages of the dynamic modification rule and skip indicator | Read | QDPS-DYNREGEL = QALS-DYNREGEL AND QDPS-PRSTUFE = QALS-PRSTUFE | ECC + S/4 |
| QDQL | Current quality level record for the vendor and material | Read | QDQL-MATNR = QALS-MATNR AND QDQL-WERKS = QALS-WERK AND QDQL-LIFNR = QALS-LIFNR AND QDQL-PRUEFART = QALS-ART | ECC + S/4 |
| QAVE | Usage decision and valuation | Read | QAVE-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QMEL | Open quality notifications for the vendor and material | Read | QMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNR | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_ART | Inspection type | Range / multiple | QALS-ART | No |
| S_DATE | Lot creation date range | Range / multiple | QALS-ENSTEHDAT | Yes |
| S_DYN | Dynamic modification rule | Range / multiple | QALS-DYNREGEL | No |
| P_RISK | Risky lines only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Vendor | QALS-LIFNR |
| Vendor name | LFA1-NAME1 |
| Material | QALS-MATNR |
| Material description | MAKT-MAKTX |
| Dynamic rule | QALS-DYNREGEL |
| Latest stage | QALS-PRSTUFE |
| Skip stage | QDPS-KZSKIP |
| Total lots | Calculated: Number of goods receipt lots in the period |
| Skipped lots | Calculated: Number of lots with QALS-KZSKIPLOT = X |
| Skip rate % | Calculated: Skipped lots ÷ total lots × 100 |
| Rejected lots | Calculated: Number of lots with QAVE-VBEWERTUNG = R |
| Lot that updated the level | QDQL-PRUEFLOS |
| Open notifications | Calculated: Incomplete QMEL records for the vendor and material |
| Risk | Calculated: X when skip lots exist while there is a rejection or an open notification |

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

## Authorization objects

- Q_INSPTYPE: Inspection lot authorization by inspection type
- Q_QMEL: Quality 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-skip-lot-dynamic-modification-status
