SAP Table QINF

QM-info record for material and vendor

QINF (QM-info record for material and vendor) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QINF to other SAP tables.

QINF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
ZAEHL Internal Counter for DB Objects Q_COUNT NUMC 6 0
ERSTELLER Name of User who Created the Q-Info Record QINFERST CHAR 12 0
ERSTELLDAT Create Date of Q-Info Record QINFERSTDT DATS 8 0
AENDERER Name of User who Most Recently Changed the Q-Info Record QINFAEND CHAR 12 0
AENDERDAT Change Date of Q-Info Record QINFAENDDT DATS 8 0
LIEFERANT Vendor Account Number ELIFN LFA1 CHAR 10 0
WERK Plant WERKS_D T001W CHAR 4 0
FREI_DAT Date Until Which the Release Is Valid QFREIDAT DATS 8 0
FREI_MGKZ Release Quantity Is Active QFREIMGKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ME Base Unit of Measure for the Material QBSTME T006 UNIT 3 0
FREI_MNG Quantity Released for the Material QFREIMG QUAN 13 3
BEST_MG Quantity Ordered for the Material QBSTMG QUAN 13 3
DAT_RUECK Date when the Ordered Quantity Was Reset QRSDAT DATS 8 0
SPERRGRUND Blocking reason QSPERRGR CHAR 40 0
SPRACHE Language Key SPRAS T002 LANG 1 0
SPERRFKT Function That Will Be Blocked QSPERRFKT TQ04A CHAR 2 0
QVVORH Quality Assurance Agreement Exists QQSVVORH CHAR 1 0
NULL Indicator is not set
X Indicator is set
NOINSP Inspection Control in the QM Info Record QNOINSP CHAR 1 0
NULL Inspection active, if vendor is not certified
X No inspection
1 Inspection active, independent of vendor certification
QSSYSFAM Vendor's QM system QSSYS_IST TQ02B CHAR 4 0
QSSYSDAT Validity date of certification QQSSYSDAT DATS 8 0
VARIABNAHM Inspection Type for Insp. Lot Origin (Source Inspection) QINFVAR1 TQ30 CHAR 8 0
LTEXTKZ Inspection Characteristic Long Text Exists QLTEXTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
SPRAS Language Key SPRAS T002 LANG 1 0
PLOS Inspection Lot No. in QINF for Current Status QPLOSQINF QALS NUMC 12 0
PLOS2 Inspection Lot No. in QINF for Next Status QPLOSQINF2 QALS NUMC 12 0
STSMA Status Profile Assigned to Quality Info Record QSTSMAQINF TJ20 CHAR 8 0
OBJNR QINF Object Number in Status Management QINFOBJNR ONR00 CHAR 22 0
NOINSPABN No GR Inspection if Source Inspection Lot Exists QNOWEABN CHAR 1 0
NULL Indicator is not set
X Indicator is set
VORLABN Lot Creation Lead Time (in Days) for Source Inspection QVORLABN INT1 3 0
REVLV Revision Level REVLV CHAR 2 0
LOEKZ Deletion Flag QLOEKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
CERTCONTROL Control of Certificate Receipt QCERTCONTROL CHAR 1 0
NULL Standard certificate receipt (print, PDF, or FAX)
1 Electronic certificate with PDF and data transfer
2 Electronic certificate without PDF with data transfer

QINF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QINF LIEFERANT QINF MANDT LFA1 Vendor Master (General Section) MANDT
QINF LIEFERANT QINF LIEFERANT LFA1 Vendor Master (General Section) LIFNR
QINF MANDT QINF MANDT T000 Clients MANDT
QINF MATNR QINF MANDT MARA General Material Data MANDT
QINF MATNR QINF MATNR MARA General Material Data MATNR
QINF ME QINF MANDT T006 Units of Measurement MANDT
QINF ME QINF ME T006 Units of Measurement MSEHI
QINF OBJNR QINF MANDT ONR00 General Object Number MANDT
QINF OBJNR QINF OBJNR ONR00 General Object Number OBJNR
QINF PLOS QINF MANDT QALS Inspection lot record MANDANT
QINF PLOS QINF PLOS QALS Inspection lot record PRUEFLOS
QINF PLOS2 QINF MANDT QALS Inspection lot record MANDANT
QINF PLOS2 QINF PLOS2 QALS Inspection lot record PRUEFLOS
QINF QSSYSFAM QINF QSSYSFAM TQ02B QM system QSSYSFAM
QINF QSSYSFAM QINF MANDT TQ02B QM system MANDT
QINF SPERRFKT QINF MANDT TQ04A Functions that can be blocked MANDT
QINF SPERRFKT QINF SPERRFKT TQ04A Functions that can be blocked SPERRFKT
QINF SPRACHE QINF SPRACHE T002 Language Keys (Component BC-I18) SPRAS
QINF SPRAS QINF SPRAS T002 Language Keys (Component BC-I18) SPRAS
QINF STSMA QINF MANDT TJ20 Status profiles MANDT
QINF STSMA QINF STSMA TJ20 Status profiles STSMA
QINF VARIABNAHM QINF MANDT TQ30 Inspection types MANDT
QINF VARIABNAHM QINF VARIABNAHM TQ30 Inspection types ART
QINF WERK QINF MANDT T001W Plants/Branches MANDT
QINF WERK QINF WERK T001W Plants/Branches WERKS