# Vendor Quality Info Record Release and Expiry Status Report

> A custom ALV report that shows, in one list, vendor/material quality info records whose release date has passed or is about to pass, the remaining quantity of a quantity-limited release, the validity of the vendor's quality system certificate and the open purchase order quantity. It also finds vendor/material pairs that require a release but have no info record at all.

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/vendor-quality-info-record-release-expiry-report/


## Why is the standard not enough?

QI03 shows a single quality info record; QI06 changes releases in bulk but does not list the ones about to expire together with open purchase orders. Once the release date passes, the purchase order or goods receipt is blocked and the problem is only noticed at that moment. The custom report shows the records that will expire in advance, together with the open order quantity that will be affected.

### Closest standard alternatives

- QI03: Displays a single quality info record; no expiry list and no open order impact.
- QI06: Changes releases in bulk; does not report the ones about to expire together with open orders.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QINF | Quality info record: release date and quantity, block, certificate validity (driving table) | Read | - | ECC + S/4 |
| LFA1 | Vendor name and quality system | Read | LFA1-LIFNR = QINF-LIEFERANT | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = QINF-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKKO | Vendor of the open orders | Read | EKKO-LIFNR = QINF-LIEFERANT | ECC + S/4 |
| EKPO | Open order item: material, plant, deletion and delivery completed flags | Read | EKPO-EBELN = EKKO-EBELN AND EKPO-MATNR = QINF-MATNR AND EKPO-WERKS = QINF-WERK | ECC + S/4 |
| EKET | Scheduled and received quantity | Read | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| MARC | QM control key in procurement (missing info record check) | Read | MARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKS | ECC + S/4 |
| TQ08 | Whether the control key requires a release | Read | TQ08-QM_PUR = MARC-SSQSS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QINF-WERK | Yes |
| S_LIFNR | Vendor | Range / multiple | QINF-LIEFERANT | No |
| S_MATNR | Material | Range / multiple | QINF-MATNR | No |
| P_DAYS | Expiry warning horizon (days) | Single value | - | Yes |
| P_OPENPO | Only with open purchase orders | Checkbox | - | No |
| P_MISS | Show missing info records | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | QINF-WERK |
| Vendor | QINF-LIEFERANT |
| Vendor name | LFA1-NAME1 |
| Material | QINF-MATNR |
| Material description | MAKT-MAKTX |
| Release valid to | QINF-FREI_DAT |
| Days left | Calculated: QINF-FREI_DAT − today |
| Released qty | QINF-FREI_MNG |
| Ordered qty | QINF-BEST_MG |
| Remaining released qty | Calculated: QINF-FREI_MNG − QINF-BEST_MG (if a quantity limit applies) |
| Block function | QINF-SPERRFKT |
| Quality system | LFA1-QSSYS |
| Certificate valid to | QINF-QSSYSDAT |
| Open PO qty | Calculated: Σ (EKET-MENGE − EKET-WEMNG), items not deleted and not completed |
| Status | Calculated: Expired, no info record, quantity will be exceeded, expiring, certificate expiring, blocked or OK |

## How does the report work?

1. QINF is read by plant, vendor and material; records with a deletion flag (LOEKZ) are skipped.
2. Days left = release date (FREI_DAT) − today. For a quantity-limited release (FREI_MGKZ), remaining quantity = released quantity (FREI_MNG) − quantity ordered (BEST_MG).
3. The vendor's quality system is read from LFA1-QSSYS and the certificate validity date from QINF-QSSYSDAT.
4. The open order quantity for the same vendor, material and plant is calculated from EKKO, EKPO and EKET: Σ (EKET-MENGE − EKET-WEMNG) over items that are neither deleted nor delivery-completed.
5. With "Missing info records" selected, vendors with open orders for materials whose QM control key in the plant data (MARC-SSQSS) requires a release in TQ08 but that have no QINF record are listed on separate lines.
6. Status priority: expired, no info record, quantity will be exceeded (remaining < open order), about to expire, certificate expiring, blocked (SPERRFKT), OK.

## Authorization objects

- Q_TCODE: QM transaction authorization (display info record)
- M_BEST_WRK: Purchase order display authorization by plant

## Frequently asked questions

### What happens when a release expires?

If the QM control key requires a release, a purchase order or goods receipt with an expired or used-up info record is blocked or raises a warning. The report shows this before the order or delivery happens.

### How are missing info records found?

For vendor/material/plant pairs with open orders, the material's QM control key is read in TQ08. If the key requires a release and there is no record in QINF, the line is listed as "No info record".

### Does the report work on S/4HANA?

Yes. QINF, LFA1, EKKO, EKPO and EKET also exist in S/4HANA. Even though vendor master data is maintained as a business partner, the vendor number in LFA1 stays the same.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-quality-info-record-release-expiry
