Menu

SAP Table QINF

QM-info record for material and vendor

The table QINF (QM-info record for material and vendor) is a standard table in SAP ERP. It belongs to the package QB.

Technical Information

Table QINF
Short Text QM-info record for material and vendor
Package QB
Table Type Transparent Table

Fields for Table QINF

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