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 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||
SPEZUEBER | Inspect with Material Specification | QSPEZUEBER | CHAR | 1 | 0 |
Possible values
|
||||||
CONF | Inspection Specifications from Configuration | QCONF | CHAR | 1 | 0 |
Possible values
|
||||||
TLS | Inspection Specifications from Batch Determination | QCHARG | CHAR | 1 | 0 |
Possible values
|
||||||
APP | Automatic Specification Assignment | QAPP_D | CHAR | 1 | 0 |
Possible values
|
||||||
MER | Inspect by Characteristics | QMERK | CHAR | 1 | 0 |
Possible values
|
||||||
INSMK | Post to Inspection Stock | QINSMK | CHAR | 1 | 0 |
Possible values
|
||||||
AVE | Automatic Usage Decision Planned | QAUTO_VE | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
DYN | Skips Allowed | QDYN | CHAR | 1 | 0 |
Possible values
|
||||||
MPB | Enter the Sample Manually | QMPB | CHAR | 1 | 0 |
Possible values
|
||||||
MST | Trigger Sample Calculation Manually | QMST | CHAR | 1 | 0 |
Possible values
|
||||||
EIN | Serial Number Management Possible | QEINZ | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
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 |
Possible values
|
||||||
APA | Preferred Inspection Type | QAPA | CHAR | 1 | 0 |
Possible values
|
||||||
AFR | Inspection for Handling Unit | QAFR | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
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 | QMAT | CHG | TQ32C | Lot creation allowed values for the origin | EINWELOS |
QMAT | CHG | TQ32 | HERKUNFT | TQ32C | Lot creation allowed values for the origin | HERKUNFT |
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 | MANDT | T001W | Plants/Branches | MANDT |
QMAT | WERKS | QMAT | WERKS | T001W | Plants/Branches | WERKS |