QM Report Custom development ALV report

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

  • QI03 Display Quality Info Record - Purchasing. Displays a single quality info record; no expiry list and no open order impact.
  • QI06 QM Releases: Mass Maintenance. Changes releases in bulk; does not report the ones about to expire together with open orders.

Tables used

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

TableRoleJoinSystem
QINFQM Info Record for Material and VendorQuality info record: release date and quantity, block, certificate validity (driving table)—ECC + S/4
LFA1Vendor Master (General Section)Vendor name and quality systemLFA1-LIFNR = QINF-LIEFERANTECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = QINF-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
EKKOPurchasing Document HeaderVendor of the open ordersEKKO-LIFNR = QINF-LIEFERANTECC + S/4
EKPOPurchasing Document ItemOpen order item: material, plant, deletion and delivery completed flagsEKPO-EBELN = EKKO-EBELN AND EKPO-MATNR = QINF-MATNR AND EKPO-WERKS = QINF-WERKECC + S/4
EKETPurchasing Schedule LinesScheduled and received quantityEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
MARCPlant Data for MaterialQM control key in procurement (missing info record check)MARC-MATNR = EKPO-MATNR AND MARC-WERKS = EKPO-WERKSECC + S/4
TQ08Control of QM in ProcurementWhether the control key requires a releaseTQ08-QM_PUR = MARC-SSQSSECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQINF-WERKYes1000
S_LIFNRVendorRange / multipleQINF-LIEFERANTNo100245
S_MATNRMaterialRange / multipleQINF-MATNRNoRM-1001
P_DAYSExpiry warning horizon (days)Single value—Yes60
P_OPENPOOnly with open purchase ordersCheckbox—No—
P_MISSShow missing info recordsCheckbox—NoX

Output columns

#ColumnSource
1PlantQINF-WERK
2VendorQINF-LIEFERANT
3Vendor nameLFA1-NAME1
4MaterialQINF-MATNR
5Material descriptionMAKT-MAKTX
6Release valid toQINF-FREI_DAT
7Days leftCalculated QINF-FREI_DAT − today
8Released qtyQINF-FREI_MNG
9Ordered qtyQINF-BEST_MG
10Remaining released qtyCalculated QINF-FREI_MNG − QINF-BEST_MG (if a quantity limit applies)
11Block functionQINF-SPERRFKT
12Quality systemLFA1-QSSYS
13Certificate valid toQINF-QSSYSDAT
14Open PO qtyCalculated Σ (EKET-MENGE − EKET-WEMNG), items not deleted and not completed
15StatusCalculated Expired, no info record, quantity will be exceeded, expiring, certificate expiring, blocked or OK

Sample output

PlantVendorVendor nameMaterialMaterial descriptionRelease valid toDays leftReleased qtyOrdered qtyRemaining released qtyBlock functionQuality systemCertificate valid toOpen PO qtyStatus
1000100245Atlas AmbalajRM-1001Carton box 40x3012/15/20262850,00041,0009,000ISO900103/31/202712,000Quantity will be exceeded
1000100387Delta MetalRM-2040Steel sheet 2 mm11/10/2026-7ISO900110/31/20263,200Expired
2000100512Ege KimyaRM-3105Solvent-based paint01/20/202764ISO900112/31/2026800Certificate expiring
2000100630Kuzey KauçukRM-4220EPDM gasket 40 mm1,500No info record
A view built with fictional sample data; not real system data.

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.

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

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: Vendor Quality Info Record Release and Expiry Status Report