SAP ABAP Table QMAT (Inspection type - material parameters)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QA (Package) QM master data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QMAT	Table Relationship Diagram
Short Description	Inspection type - material parameters

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ART	☑	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	PPL	☐	QPPL	QKZ	CHAR	1	0	Inspection with Task List
6	SPEZUEBER	☐	QSPEZUEBER	QKZ	CHAR	1	0	Inspect with Material Specification
7	CONF	☐	QCONF	QKZ	CHAR	1	0	Inspection Specifications from Configuration
8	TLS	☐	QCHARG	QKZ	CHAR	1	0	Inspection Specifications from Batch Determination
9	APP	☐	QAPP_D	QKZ	CHAR	1	0	Automatic Specification Assignment
10	MER	☐	QMERK	QKZ	CHAR	1	0	Inspect by Characteristics
11	INSMK	☐	QINSMK	QKZ	CHAR	1	0	Post to inspection stock
12	AVE	☐	QAUTO_VE	QKZ	CHAR	1	0	Automatic Usage Decision Planned
13	STICHPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	*
14	DYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	*
15	SPROZ	☐	QSPROZ	DEC3	DEC	3	0	Inspection Percentage
16	HPZ	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
17	DYN	☐	QDYN	QKZ	CHAR	1	0	Skips Allowed
18	MPB	☐	QMPB	QKZ	CHAR	1	0	Enter the Sample Manually
19	MST	☐	QMST	QKZ	CHAR	1	0	Trigger Sample Calculation Manually
20	EIN	☐	QEINZ	QKZ	CHAR	1	0	Serial Number Management Possible
21	MPDAU	☐	QMPDAU	DEC3	DEC	3	0	Average Inspection Duration
22	CHG	☐	Q1WELOS	Q1WELOS	CHAR	1	0	Control of Inspection Lot Creation (Lot Summary)	TQ32C
23	QKZVERF	☐	QKZVERF	QKZVERF	CHAR	2	0	Procedure for Calculating Quality Score	TQ06
24	QPMAT	☐	QAUSSCHUSS	QPMAT	DEC	6	4	Allowed Share of Scrap (Percent) in Inspection Lot
25	KZPRFKOST	☐	QKZPRFKOST	QKZ	CHAR	1	0	Record Appraisal Costs in Individual QM Order
26	AUFNR_CO	☐	QAUFNR_CO	AUFNR	CHAR	12	0	Order Number for Recording Appraisal Costs	AUFK
27	AKTIV	☐	QMATAKTIV	QKZ	CHAR	1	0	Inspection Type - Material Combination is Active
28	APA	☐	QAPA	QKZ	CHAR	1	0	Preferred Inspection Type
29	AFR	☐	QAFR	QKZ	CHAR	1	0	Inspection for Handling Unit
30	MMA	☐	Q_UNUSED01	CHAR1	CHAR	1	0	Field Not Used as of 3.0 Field Reserved for SAP
31	FEH	☐	Q_UNUSED01	CHAR1	CHAR	1	0	Field Not Used as of 3.0 Field Reserved for SAP
32	PRFRQ	☐	QPRFRQ	QPRFRQ	DEC	3	0	Field Not Used as of 3.0 Field Reserved for SAP
33	NKMPR	☐	QNKMPR	DATUM	DATS	8	0	Field Not Used as of 3.0 Field Reserved for SAP
34	MS_FLAG	☐	Q_MS_FLG	Q_MS_FLG	CHAR	1	0	Indicator: Multiple Specifications

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QMAT	ART	TQ30	ART
2	QMAT	AUFNR_CO	AUFK	AUFNR		1	CN
3	QMAT	CHG	TQ32C	EINWELOS
4	QMAT	MANDT	T000	MANDT
5	QMAT	MATNR	MARA	MATNR	KEY	1	N
6	QMAT	QKZVERF	TQ06	QKZVERF		1	CN
7	QMAT	WERKS	T001W	WERKS	KEY	1	N

History

Last changed by/on	SAP	20050109
SAP Release Created in