SAP Table QMAT_D01

Fields to be printed in the QA08

QMAT_D01 (Fields to be printed in the QA08) 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_D01 to other SAP tables.

QMAT_D01 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
MAKTX Material Description (Short Text) MAKTX CHAR 40 0

QMAT_D01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QMAT_D01 ART QMAT_D01 MANDT TQ30 Inspection types MANDT
QMAT_D01 ART QMAT_D01 ART TQ30 Inspection types ART
QMAT_D01 AUFNR_CO QMAT_D01 MANDT AUFK Order master data MANDT
QMAT_D01 AUFNR_CO QMAT_D01 AUFNR_CO AUFK Order master data AUFNR
QMAT_D01 CHG TQ32 HERKUNFT TQ32C Lot creation allowed values for the origin HERKUNFT
QMAT_D01 CHG QMAT_D01 CHG TQ32C Lot creation allowed values for the origin EINWELOS
QMAT_D01 MANDT QMAT_D01 MANDT T000 Clients MANDT
QMAT_D01 MATNR QMAT_D01 MATNR MARA General Material Data MATNR
QMAT_D01 MATNR QMAT_D01 MANDT MARA General Material Data MANDT
QMAT_D01 QKZVERF QMAT_D01 QKZVERF TQ06 Procedure for Calculating the Quality Score QKZVERF
QMAT_D01 QKZVERF QMAT_D01 MANDT TQ06 Procedure for Calculating the Quality Score MANDT
QMAT_D01 WERKS QMAT_D01 MANDT T001W Plants/Branches MANDT
QMAT_D01 WERKS QMAT_D01 WERKS T001W Plants/Branches WERKS