SAP table QINF (QM-Info Record for Material and Supplier)

SAP table QINF has 3 primary key fields being MANDT,MATNR,ZAEHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
ZAEHL Internal Counter for DB Objects NUMC 6 0 Q_COUNT
ERSTELLER Name of User who Created the Q-Info Record CHAR 12 0 QINFERST
ERSTELLDAT Create Date of Q-Info Record DATS 8 0 QINFERSTDT
AENDERER Name of User who Most Recently Changed the Q-Info Record CHAR 12 0 QINFAEND
AENDERDAT Change Date of Q-Info Record DATS 8 0 QINFAENDDT
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
LIEFERANT Vendor's account number CHAR 10 0 LFA1 ELIFN
WERK Plant CHAR 4 0 T001W WERKS_D
FREI_DAT Date Until Which the Release Is Valid DATS 8 0 QFREIDAT
FREI_MGKZ Release Quantity Is Active CHAR 1 0 QFREIMGKZ
ME Base Unit of Measure for the Material UNIT 3 0 T006 QBSTME
FREI_MNG Quantity Released for the Material QUAN 13 3 QFREIMG
BEST_MG Quantity Ordered for the Material QUAN 13 3 QBSTMG
DAT_RUECK Date when the Ordered Quantity Was Reset DATS 8 0 QRSDAT
SPERRGRUND Blocking Reason CHAR 40 0 QSPERRGR
SPRACHE Language Key LANG 1 0 T002 SPRAS
SPERRFKT Function That Will Be Blocked CHAR 2 0 TQ04A QSPERRFKT
QVVORH Quality Assurance Agreement Exists CHAR 1 0 QQSVVORH
NOINSP Inspection Control in the QM Info Record CHAR 1 0 QNOINSP
Inspection Active If Supplier Not Certified
1 Inspection Active Regardless of Supplier Certification
X No Inspection
QSSYSFAM Supplier's QM System CHAR 4 0 TQ02B QSSYS_IST
QSSYSDAT Validity Date of Certification DATS 8 0 QQSSYSDAT
VARIABNAHM Inspection Type for Insp. Lot Origin (Source Inspection) CHAR 8 0 TQ30 QINFVAR1
LTEXTKZ Inspection Characteristic Long Text Exists CHAR 1 0 QLTEXTKZ
SPRAS Language Key LANG 1 0 T002 SPRAS
PLOS Inspection Lot No. in QINF for Current Status NUMC 12 0 QALS QPLOSQINF
PLOS2 Inspection Lot No. in QINF for Next Status NUMC 12 0 QALS QPLOSQINF2
PPAP_IS_REQUIRED Production Part Approval Is Required CHAR 1 0 QPPAP_IS_REQUIRED
PPAP_LEVEL Production Part Approval for Part Submission Warrant CHAR 2 0 QPPAP_LEVEL
No Warrant
1 1: Warrant Only
2 2: Warrant with Product Samples and Limited Supporting Data
3 3: Warrant with Product Samples and Complete Supporting Data
4 4: Warrant and Other Requirements as Defined by the Customer
5 5: Warrant with Samples and Data Reviewed at Manufacturer
PPAP_STATUS Production Part Approval Status CHAR 2 0 QPPAP_STATUS
Not Required
01 New
02 In Process
03 Completed
PPAP_ID Production Part Approval Identifier CHAR 10 0 QPPAP_ID
STSMA Status Profile Assigned to Quality Info Record CHAR 8 0 TJ20 QSTSMAQINF
OBJNR QINF Object Number in Status Management CHAR 22 0 ONR00 QINFOBJNR
NOINSPABN No GR Inspection if Source Inspection Lot Exists CHAR 1 0 QNOWEABN
VORLABN Lot Creation Lead Time (in Days) for Source Inspection INT1 3 0 QVORLABN
REVLV Revision Level CHAR 2 0 REVLV
LOEKZ Deletion Flag CHAR 1 0 QLOEKZ
CERTCONTROL Control of Certificate Receipt CHAR 1 0 QCERTCONTROL
Standard certificate receipt (print, PDF, or FAX)
1 Electronic certificate with PDF and data transfer
2 Electronic certificate without PDF with data transfer
DUMMY_QINF_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QINF foreign key relationships

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