1. Home
  2. Resources
  3. SAP Tables
  4. DQMAT - Shortened QMAT Structure for Change Documents

SAP Table DQMAT

Shortened QMAT Structure for Change Documents

DQMAT (Shortened QMAT Structure for Change Documents) 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 DQMAT to other SAP tables.

DQMAT table fields

Field Data element Checktable Datatype Length Decimals
WERKS Plant WERKS_D CHAR 4 0
ART Inspection Type QPART CHAR 8 0
PPL Inspection with Task List QPPL 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
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
AVE Automatic Usage Decision QAVE_D CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
MMA Select Characteristics Manually QMMA_D 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
TLS Partial Lots Possible QTLS 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
NKMPR Field Not Used as of 3.0 Field Reserved for SAP QNKMPR DATS 8 0
PRFRQ Field Not Used as of 3.0 Field Reserved for SAP QPRFRQ DEC 3 0
MER Inspect by Characteristics QMERK CHAR 1 0
NULL Indicator is not set
X Indicator is set
FEH Only Defects Recording is Defined QFEHL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MPDAU Average Inspection Duration QMPDAU DEC 3 0
QKZVERF Procedure for Calculating Quality Score QKZVERF CHAR 2 0
QPMAT Allowed Share of Scrap (Percent) in Inspection Lot QAUSSCHUSS DEC 6 4
CHG Control of Inspection Lot Creation (Lot Summary) Q1WELOS CHAR 1 0
NULL An inspection lot for each document item
X An insp. lot per purch. order item, or order item and batch
Y Early lot creation for the order item
1 An insp. lot per material document, material and batch
2 An inspection lot for each material and batch
3 One Inspection Lot for Each Batch Split Item
SPROZ Inspection Percentage QSPROZ DEC 3 0
AKTIV Inspection Type - Material Combination is Active QMATAKTIV 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
SPEZUEBER Inspect with Material Specification QSPEZUEBER CHAR 1 0
NULL Indicator is not set
X Indicator is set
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 CHAR 12 0
CONF Inspection Specifications from Configuration QCONF 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
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