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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
NOINSP
Inspection Control in the QM Info Record
|
QNOINSP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
CERTCONTROL
Control of Certificate Receipt
|
QCERTCONTROL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
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 | ME |
T006
Units of Measurement
|
MSEHI |
| QINF | ME | QINF | MANDT |
T006
Units of Measurement
|
MANDT |
| 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 | MANDT |
TQ02B
QM system
|
MANDT |
| QINF | QSSYSFAM | QINF | QSSYSFAM |
TQ02B
QM system
|
QSSYSFAM |
| QINF | SPERRFKT | QINF | SPERRFKT |
TQ04A
Functions that can be blocked
|
SPERRFKT |
| QINF | SPERRFKT | QINF | MANDT |
TQ04A
Functions that can be blocked
|
MANDT |
| 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 |