Vendor Quality Info Record Release and Expiry Status Report
Short answer: 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.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Supplier quality engineers, buyers and quality assurance teams.
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 |
|---|---|---|---|
| QINFQM Info Record for Material and Vendor | Quality info record: release date and quantity, block, certificate validity (driving table) | — | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name and quality system | LFA1-LIFNR = QINF-LIEFERANT | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = QINF-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKKOPurchasing Document Header | Vendor of the open orders | EKKO-LIFNR = QINF-LIEFERANT | ECC + S/4 |
| EKPOPurchasing Document Item | Open order item: material, plant, deletion and delivery completed flags | EKPO-EBELN = EKKO-EBELN AND EKPO-MATNR = QINF-MATNR AND EKPO-WERKS = QINF-WERK | ECC + S/4 |
| EKETPurchasing Schedule Lines | Scheduled and received quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| MARCPlant Data for Material | QM control key in procurement (missing info record check) | MARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKS | ECC + S/4 |
| TQ08Control of QM in Procurement | Whether the control key requires a release | TQ08-QM_PUR = MARC-SSQSS | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QINF-WERK | Yes | 1000 |
| S_LIFNR | Vendor | Range / multiple | QINF-LIEFERANT | No | 100245 |
| S_MATNR | Material | Range / multiple | QINF-MATNR | No | RM-1001 |
| P_DAYS | Expiry warning horizon (days) | Single value | — | Yes | 60 |
| P_OPENPO | Only with open purchase orders | Checkbox | — | No | — |
| P_MISS | Show missing info records | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | QINF-WERK |
| 2 | Vendor | QINF-LIEFERANT |
| 3 | Vendor name | LFA1-NAME1 |
| 4 | Material | QINF-MATNR |
| 5 | Material description | MAKT-MAKTX |
| 6 | Release valid to | QINF-FREI_DAT |
| 7 | Days left | Calculated QINF-FREI_DAT − today |
| 8 | Released qty | QINF-FREI_MNG |
| 9 | Ordered qty | QINF-BEST_MG |
| 10 | Remaining released qty | Calculated QINF-FREI_MNG − QINF-BEST_MG (if a quantity limit applies) |
| 11 | Block function | QINF-SPERRFKT |
| 12 | Quality system | LFA1-QSSYS |
| 13 | Certificate valid to | QINF-QSSYSDAT |
| 14 | Open PO qty | Calculated Σ (EKET-MENGE − EKET-WEMNG), items not deleted and not completed |
| 15 | Status | Calculated Expired, no info record, quantity will be exceeded, expiring, certificate expiring, blocked or OK |
Sample output
| Plant | Vendor | Vendor name | Material | Material description | Release valid to | Days left | Released qty | Ordered qty | Remaining released qty | Block function | Quality system | Certificate valid to | Open PO qty | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 100245 | Atlas Ambalaj | RM-1001 | Carton box 40x30 | 12/15/2026 | 28 | 50,000 | 41,000 | 9,000 | ISO9001 | 03/31/2027 | 12,000 | Quantity will be exceeded | |
| 1000 | 100387 | Delta Metal | RM-2040 | Steel sheet 2 mm | 11/10/2026 | -7 | ISO9001 | 10/31/2026 | 3,200 | Expired | ||||
| 2000 | 100512 | Ege Kimya | RM-3105 | Solvent-based paint | 01/20/2027 | 64 | ISO9001 | 12/31/2026 | 800 | Certificate expiring | ||||
| 2000 | 100630 | Kuzey Kauçuk | RM-4220 | EPDM gasket 40 mm | 1,500 | No info record |
How does the report work?
- QINF is read by plant, vendor and material; records with a deletion flag (LOEKZ) are skipped.
- Days left = release date (FREI_DAT) − today. For a quantity-limited release (FREI_MGKZ), remaining quantity = released quantity (FREI_MNG) − quantity ordered (BEST_MG).
- The vendor’s quality system is read from LFA1-QSSYS and the certificate validity date from QINF-QSSYSDAT.
- 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.
- 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.
- Status priority: expired, no info record, quantity will be exceeded (remaining < open order), about to expire, certificate expiring, blocked (SPERRFKT), OK.
Performance notes
QINF is a small table. Read the open order quantity aggregated in one JOIN, only for the vendor/material pairs in the list. Run the report as a weekly background job and send it to the supplier quality team.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a line opens the info record in QI03; clicking the open PO quantity opens the related orders.
- Export to Excel
- Runs as a background job
- Send the result by email Records about to expire can be emailed to the supplier quality team every Monday.
Authorization objects
- Q_TCODEQM transaction authorization (display info record)
- M_BEST_WRKPurchase 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.
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
Materials with Missing or Inconsistent QM Inspection Setup Report
A custom ALV report that checks the QM settings in the material master against rules and lists each finding with a suggested action: expected …
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 …
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.