SAP Table QMAT
Inspection type - material parameters
QMAT (Inspection type - material parameters) 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 QMAT to other SAP tables.
QMAT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
ART
Inspection Type
|
QPART | TQ30 |
CHAR
|
8 | 0 | |||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||
|
PPL
Inspection with Task List
|
QPPL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SPEZUEBER
Inspect with Material Specification
|
QSPEZUEBER |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CONF
Inspection Specifications from Configuration
|
QCONF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TLS
Inspection Specifications from Batch Determination
|
QCHARG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
APP
Automatic Specification Assignment
|
QAPP_D |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MER
Inspect by Characteristics
|
QMERK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
INSMK
Post to Inspection Stock
|
QINSMK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AVE
Automatic Usage Decision Planned
|
QAUTO_VE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
STICHPRVER
Sampling Procedure
|
QSTPRVER |
CHAR
|
8 | 0 | ||||||||
|
DYNREGEL
Dynamic Modification Rule
|
QDYNREGEL |
CHAR
|
3 | 0 | ||||||||
|
SPROZ
Inspection Percentage
|
QSPROZ |
DEC
|
3 | 0 | ||||||||
|
HPZ
100% Inspection
|
QHPZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DYN
Skips Allowed
|
QDYN |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MPB
Enter the Sample Manually
|
QMPB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MST
Trigger Sample Calculation Manually
|
QMST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
EIN
Serial Number Management Possible
|
QEINZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MPDAU
Average Inspection Duration
|
QMPDAU |
DEC
|
3 | 0 | ||||||||
|
CHG
Control of Inspection Lot Creation (Lot Summary)
|
Q1WELOS | TQ32C |
CHAR
|
1 | 0 | |||||||
|
QKZVERF
Procedure for Calculating Quality Score
|
QKZVERF | TQ06 |
CHAR
|
2 | 0 | |||||||
|
QPMAT
Allowed Share of Scrap (Percent) in Inspection Lot
|
QAUSSCHUSS |
DEC
|
6 | 4 | ||||||||
|
KZPRFKOST
Record Appraisal Costs in Individual QM Order
|
QKZPRFKOST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AUFNR_CO
Order Number for Recording Appraisal Costs
|
QAUFNR_CO | AUFK |
CHAR
|
12 | 0 | |||||||
|
AKTIV
Inspection Type - Material Combination is Active
|
QMATAKTIV |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
APA
Preferred Inspection Type
|
QAPA |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AFR
Inspection for Handling Unit
|
QAFR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MMA
Field Not Used as of 3.0 Field Reserved for SAP
|
Q_UNUSED01 |
CHAR
|
1 | 0 | ||||||||
|
FEH
Field Not Used as of 3.0 Field Reserved for SAP
|
Q_UNUSED01 |
CHAR
|
1 | 0 | ||||||||
|
PRFRQ
Field Not Used as of 3.0 Field Reserved for SAP
|
QPRFRQ |
DEC
|
3 | 0 | ||||||||
|
NKMPR
Field Not Used as of 3.0 Field Reserved for SAP
|
QNKMPR |
DATS
|
8 | 0 | ||||||||
|
MS_FLAG
Indicator: Multiple Specifications
|
Q_MS_FLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
QMAT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QMAT | ART | QMAT | MANDT |
TQ30
Inspection types
|
MANDT |
| QMAT | ART | QMAT | ART |
TQ30
Inspection types
|
ART |
| QMAT | AUFNR_CO | QMAT | MANDT |
AUFK
Order master data
|
MANDT |
| QMAT | AUFNR_CO | QMAT | AUFNR_CO |
AUFK
Order master data
|
AUFNR |
| QMAT | CHG | TQ32 | HERKUNFT |
TQ32C
Lot creation allowed values for the origin
|
HERKUNFT |
| QMAT | CHG | QMAT | CHG |
TQ32C
Lot creation allowed values for the origin
|
EINWELOS |
| QMAT | MANDT | QMAT | MANDT |
T000
Clients
|
MANDT |
| QMAT | MATNR | QMAT | MANDT |
MARA
General Material Data
|
MANDT |
| QMAT | MATNR | QMAT | MATNR |
MARA
General Material Data
|
MATNR |
| QMAT | QKZVERF | QMAT | MANDT |
TQ06
Procedure for Calculating the Quality Score
|
MANDT |
| QMAT | QKZVERF | QMAT | QKZVERF |
TQ06
Procedure for Calculating the Quality Score
|
QKZVERF |
| QMAT | WERKS | QMAT | WERKS |
T001W
Plants/Branches
|
WERKS |
| QMAT | WERKS | QMAT | MANDT |
T001W
Plants/Branches
|
MANDT |