SAP ABAP Table WPQMAT (Extended QMAT Structure (Engineering Change Management))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MGA (Package) Application development R/3 material master from 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	WPQMAT	Table Relationship Diagram
Short Description	Extended QMAT Structure (Engineering Change Management)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	DATUM	☐	WJDPOSDAT	DATUM	DATS	8	0	POS interface: date
2	UTIME	☐	UTIME	UZEIT	TIMS	6	0	Time of Last Change
3	CHGFLAG	☐	WJDPOSFLAG	X	CHAR	1	0	POS interface: flag for certain field changes
4	.INCLUDE	☐				0	0	Inspection type - material parameters
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	PPL	☐	QPPL	QKZ	CHAR	1	0	Inspection with Task List
10	SPEZUEBER	☐	QSPEZUEBER	QKZ	CHAR	1	0	Inspect with Material Specification
11	CONF	☐	QCONF	QKZ	CHAR	1	0	Inspection Specifications from Configuration
12	TLS	☐	QCHARG	QKZ	CHAR	1	0	Inspection Specifications from Batch Determination
13	APP	☐	QAPP_D	QKZ	CHAR	1	0	Automatic Specification Assignment
14	MER	☐	QMERK	QKZ	CHAR	1	0	Inspect by Characteristics
15	INSMK	☐	QINSMK	QKZ	CHAR	1	0	Post to inspection stock
16	AVE	☐	QAUTO_VE	QKZ	CHAR	1	0	Automatic Usage Decision Planned
17	STICHPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	*
18	DYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	*
19	SPROZ	☐	QSPROZ	DEC3	DEC	3	0	Inspection Percentage
20	HPZ	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
21	DYN	☐	QDYN	QKZ	CHAR	1	0	Skips Allowed
22	MPB	☐	QMPB	QKZ	CHAR	1	0	Enter the Sample Manually
23	MST	☐	QMST	QKZ	CHAR	1	0	Trigger Sample Calculation Manually
24	EIN	☐	QEINZ	QKZ	CHAR	1	0	Serial Number Management Possible
25	MPDAU	☐	QMPDAU	DEC3	DEC	3	0	Average Inspection Duration
26	CHG	☐	Q1WELOS	Q1WELOS	CHAR	1	0	Control of Inspection Lot Creation (Lot Summary)	TQ32C
27	QKZVERF	☐	QKZVERF	QKZVERF	CHAR	2	0	Procedure for Calculating Quality Score	TQ06
28	QPMAT	☐	QAUSSCHUSS	QPMAT	DEC	6	4	Allowed Share of Scrap (Percent) in Inspection Lot
29	KZPRFKOST	☐	QKZPRFKOST	QKZ	CHAR	1	0	Record Appraisal Costs in Individual QM Order
30	AUFNR_CO	☐	QAUFNR_CO	AUFNR	CHAR	12	0	Order Number for Recording Appraisal Costs	AUFK
31	AKTIV	☐	QMATAKTIV	QKZ	CHAR	1	0	Inspection Type - Material Combination is Active
32	APA	☐	QAPA	QKZ	CHAR	1	0	Preferred Inspection Type
33	AFR	☐	QAFR	QKZ	CHAR	1	0	Inspection for Handling Unit
34	MMA	☐	Q_UNUSED01	CHAR1	CHAR	1	0	Field Not Used as of 3.0 Field Reserved for SAP
35	FEH	☐	Q_UNUSED01	CHAR1	CHAR	1	0	Field Not Used as of 3.0 Field Reserved for SAP
36	PRFRQ	☐	QPRFRQ	QPRFRQ	DEC	3	0	Field Not Used as of 3.0 Field Reserved for SAP
37	NKMPR	☐	QNKMPR	DATUM	DATS	8	0	Field Not Used as of 3.0 Field Reserved for SAP
38	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	WPQMAT	ART	TQ30	ART
2	WPQMAT	AUFNR_CO	AUFK	AUFNR
3	WPQMAT	CHG	TQ32C	EINWELOS
4	WPQMAT	MANDT	T000	MANDT
5	WPQMAT	MATNR	MARA	MATNR	KEY	1	N
6	WPQMAT	QKZVERF	TQ06	QKZVERF
7	WPQMAT	WERKS	T001W	WERKS	KEY	1	N

History

Last changed by/on	SAP	20050109
SAP Release Created in