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
NULL Indicator is not set
X Indicator is set
SPEZUEBER Inspect with Material Specification QSPEZUEBER CHAR 1 0
NULL Indicator is not set
X Indicator is set
CONF Inspection Specifications from Configuration QCONF CHAR 1 0
NULL Indicator is not set
X Indicator is set
TLS Inspection Specifications from Batch Determination QCHARG CHAR 1 0
NULL Indicator is not set
X Indicator is set
APP Automatic Specification Assignment QAPP_D CHAR 1 0
NULL Indicator is not set
X Indicator is set
MER Inspect by Characteristics QMERK CHAR 1 0
NULL Indicator is not set
X Indicator is set
INSMK Post to Inspection Stock QINSMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
AVE Automatic Usage Decision Planned QAUTO_VE CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
DYN Skips Allowed QDYN CHAR 1 0
NULL Indicator is not set
X Indicator is set
MPB Enter the Sample Manually QMPB CHAR 1 0
NULL Indicator is not set
X Indicator is set
MST Trigger Sample Calculation Manually QMST CHAR 1 0
NULL Indicator is not set
X Indicator is set
EIN Serial Number Management Possible QEINZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
APA Preferred Inspection Type QAPA CHAR 1 0
NULL Indicator is not set
X Indicator is set
AFR Inspection for Handling Unit QAFR CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
NULL Insp. Plan/Assignment for Dependent Char. Specifications
X Inspection Plan/Assignment for Multiple Specifications

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