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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
NOINSP | Inspection Control in the QM Info Record | QNOINSP | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
CERTCONTROL | Control of Certificate Receipt | QCERTCONTROL | CHAR | 1 | 0 |
Possible values
|
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 |