SAP ABAP Table QAMSV (Specifications for inspection characteristics)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QE (Package) QM results recording

Basic Data

Table Category	INTTAB	Structure
Structure	QAMSV	Table Relationship Diagram
Short Description	Specifications for inspection characteristics

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	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
2	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
3	UPSLV	☐	QUPSL	QUPSL	CHAR	1	0	Data Base Access
4	MARK	☐	QEEMARK	QKZ	CHAR	1	0	Selection Field
5	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
6	PLNKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
7	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
8	PHYSPROBE	☐	QPHYSPROBE	QPROBENR	NUMC	6	0	Number of the Partial Sample	*
9	STATUSV	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
10	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
11	TSTICHPRKZ	☐	QTSTICHPRO	QKZUMFS	CHAR	1	0	Partial Samples Possible
12	NOINPUTKZ	☐	QNOINPUT	QKZ	CHAR	1	0	Results Are Calculated Internally
13	NIPLANMKKZ	☐	QNIPLANMK	QKZ	CHAR	1	0	Unplanned Characteristic
14	QMTB_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	*
16	PMTVERSION	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
17	QPMK_WERKS	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
18	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	*
19	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
20	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
21	KURZTEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
22	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
23	LTXTEKZ	☐	QLTEXTEKZ	QKZ	CHAR	1	0	Long Text for Physical-Sample Drawing of a Characteristic
24	LTXTENTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	PRUEFQUALI	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
26	FORMEL1	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
27	FORMEL2	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
28	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
29	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
30	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
31	CODEGR9U	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
32	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	*
33	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
34	CODEGR9O	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
35	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	*
36	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
37	KATAB1	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
38	KATALGART1	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
39	AUSWMENGE1	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
40	AUSWMGWRK1	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
41	AUSWVERS1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
42	AUSWDAT1	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
43	KATAB2	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
44	KATALGART2	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
45	AUSWMENGE2	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
46	AUSWMGWRK2	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
47	AUSWVERS2	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
48	AUSWDAT2	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
49	KATAB3	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
50	KATALGART3	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
51	AUSWMENGE3	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
52	AUSWMGWRK3	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
53	AUSWVERS3	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
54	AUSWDAT3	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
55	KATAB4	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
56	KATALGART4	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
57	AUSWMENGE4	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
58	AUSWMGWRK4	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
59	AUSWVERS4	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
60	AUSWDAT4	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
61	KATAB5	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
62	KATALGART5	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
63	AUSWMENGE5	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
64	AUSWMGWRK5	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
65	AUSWVERS5	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
66	AUSWDAT5	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
67	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
68	MASSEINHSW	☐	QMGEH6	MSEC6	CHAR	6	0	Measurement Unit in Which Quantitative Data Is Maintained	T006C
69	MASSEINHOB	☐	QMGEH6	MSEC6	CHAR	6	0	Measurement Unit in Which Quantitative Data Is Maintained	*
70	MASSEINHUN	☐	QMGEH6	MSEC6	CHAR	6	0	Measurement Unit in Which Quantitative Data Is Maintained	*
71	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
72	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
73	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
74	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
75	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
76	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
77	TOLERWKZ	☐	QTOLERWKZ	QKZ	CHAR	1	0	Tolerance Change Is Active
78	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
79	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
80	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
81	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
82	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
83	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
84	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
85	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
86	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
87	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
88	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
89	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
90	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
91	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
92	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
93	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
94	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
95	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	*
96	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
97	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
98	ANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	*
99	BEWREGEL	☐	QBEWERT	QKEY1	CHAR	2	0	Valuation Rule	QDFM
100	FBNAME	☐	QFBNAME	FUNCNAME	CHAR	30	0	Name of Function Module	*
101	KZATTRFE	☐	QKZATTRFE	QKZ	CHAR	1	0	Attributive Inspection by Nonconforming Units
102	KZATTRFZ	☐	QKZATTRFZ	QKZ	CHAR	1	0	Attributive Inspection by Number of Defects
103	KZVARS	☐	QKZVARS	QKZ	CHAR	1	0	Variable Inspection by S-Method
104	KZCOD	☐	QKZCOD	QKZ	CHAR	1	0	Valuation by Code
105	KZMAN	☐	QKZMAN	QKZ	CHAR	1	0	Manual Valuation
106	KZUMFS	☐	QKZUMFS	QKZUMFS	CHAR	1	0	Multiple Samples
107	KZNULL	☐	QKZKNULL	QKZ	CHAR	1	0	Inspection Against Specification Limits (k = 0)
108	PROBMGFAK	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
109	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
110	SOLLSTPUMF	☐	QGESUMF	QANZAHL4	INT4	10	0	Sample Size that Has to Be Inspected for a Characteristic
111	PRUEFUMF	☐	QPRUEFUMF	QMENGEPLOS	QUAN	13	3	Quantity to Be Inspected
112	MENGENEINH	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
113	HPZ	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
114	SOLLSTPANZ	☐	QSOSTPANZ	QANZAHL2	INT2	5	0	Number of Planned Partial Samples
115	ANTEILKZ	☐	QANTEILKZ	QKZ	CHAR	1	0	Take Share Estimate into Account
116	RUECKMELNR	☐	QRUECKNR	QRUECKNR	NUMC	8	0	Confirmation Number for Inspection Characteristic
117	KZEINSTELL	☐	QKZEINSTMK	QKZEINSTMK	CHAR	1	0	Characteristic Type
118	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
119	ANNAHMEZ	☐	QANNAHMEZ	QINT2NEG	INT2	5	0	Acceptance Number
120	RUECKWEZ	☐	QRUECKWEZ	QANZAHL2	INT2	5	0	Rejection Number
121	KFAKTORNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
122	KFAKTOR	☐	QKFAKTOR	QKFAKTOR	FLTP	16	16	K-Factor for a Variable Inspection
123	TQ15TSW1	☐	QTQ15TSW	QSWORTPK	CHAR	12	0	Keyword for Catalog Type 1 of the Inspection Characteristic
124	QPAMKTXT1	☐	QPAMKTXT	QKURZTEXT	CHAR	40	0	Short Text for Selected Set or Code Group
125	QPAMSP1	☐	QPAMSP	SPRAS	LANG	1	0	Language Key for Long Text for Selected Set/Code Group	T002
126	QPAMLTXT1	☐	QLTEXTMGE	QKZ	CHAR	1	0	Long Text Exists for the Selected Set
127	TQ15TSW2	☐	QTQ15TSW	QSWORTPK	CHAR	12	0	Keyword for Catalog Type 1 of the Inspection Characteristic
128	QPAMKTXT2	☐	QPAMKTXT	QKURZTEXT	CHAR	40	0	Short Text for Selected Set or Code Group
129	QPAMSP2	☐	QPAMSP	SPRAS	LANG	1	0	Language Key for Long Text for Selected Set/Code Group	T002
130	QPAMLTXT2	☐	QLTEXTMGE	QKZ	CHAR	1	0	Long Text Exists for the Selected Set
131	TQ15TSW3	☐	QTQ15TSW	QSWORTPK	CHAR	12	0	Keyword for Catalog Type 1 of the Inspection Characteristic
132	QPAMKTXT3	☐	QPAMKTXT	QKURZTEXT	CHAR	40	0	Short Text for Selected Set or Code Group
133	QPAMSP3	☐	QPAMSP	SPRAS	LANG	1	0	Language Key for Long Text for Selected Set/Code Group	T002
134	QPAMLTXT3	☐	QLTEXTMGE	QKZ	CHAR	1	0	Long Text Exists for the Selected Set
135	TQ15TSW4	☐	QTQ15TSW	QSWORTPK	CHAR	12	0	Keyword for Catalog Type 1 of the Inspection Characteristic
136	QPAMKTXT4	☐	QPAMKTXT	QKURZTEXT	CHAR	40	0	Short Text for Selected Set or Code Group
137	QPAMSP4	☐	QPAMSP	SPRAS	LANG	1	0	Language Key for Long Text for Selected Set/Code Group	T002
138	QPAMLTXT4	☐	QLTEXTMGE	QKZ	CHAR	1	0	Long Text Exists for the Selected Set
139	TQ15TSW5	☐	QTQ15TSW	QSWORTPK	CHAR	12	0	Keyword for Catalog Type 1 of the Inspection Characteristic
140	QPAMKTXT5	☐	QPAMKTXT	QKURZTEXT	CHAR	40	0	Short Text for Selected Set or Code Group
141	QPAMSP5	☐	QPAMSP	SPRAS	LANG	1	0	Language Key for Long Text for Selected Set/Code Group	T002
142	QPAMLTXT5	☐	QLTEXTMGE	QKZ	CHAR	1	0	Long Text Exists for the Selected Set
143	KEINTOLKZ	☐	QKEINTOLKZ	QKZ	CHAR	1	0	No Tolerance Limit Defined
144	SUMPROBKZ	☐	QSUMPROBKZ	QKZ	CHAR	1	0	Summarized Characteristic Results for Multiple Samples
145	MITTEL1WKZ	☐	QMITTEL1KZ	QKZ	CHAR	1	0	Summ. Recording of Mean Value if Target Sample Size = 1
146	FELDKZ1	☐	QDUMMYKZ	QKZ	CHAR	1	0	Field Selection Not Used Before
147	FELDKZ2	☐	QDUMMYKZ	QKZ	CHAR	1	0	Field Selection Not Used Before
148	FELDKZ3	☐	QDUMMYKZ	QKZ	CHAR	1	0	Field Selection Not Used Before
149	FELDKZ4	☐	QDUMMYKZ	QKZ	CHAR	1	0	Field Selection Not Used Before
150	FELDKZ5	☐	QDUMMYKZ	QKZ	CHAR	1	0	Field Selection Not Used Before
151	KATVORG	☐	QKATVORG	QKZ	CHAR	1	0	Catalog Specifications Available

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAMSV	AUSWMGWRK1	T001W	WERKS
2	QAMSV	AUSWMGWRK2	T001W	WERKS
3	QAMSV	AUSWMGWRK3	T001W	WERKS
4	QAMSV	AUSWMGWRK4	T001W	WERKS
5	QAMSV	AUSWMGWRK5	T001W	WERKS
6	QAMSV	BEWREGEL	QDFM	FBKEY
7	QAMSV	KATALGART1	TQ15	KATALOGART
8	QAMSV	KATALGART2	TQ15	KATALOGART
9	QAMSV	KATALGART3	TQ15	KATALOGART
10	QAMSV	KATALGART4	TQ15	KATALOGART
11	QAMSV	KATALGART5	TQ15	KATALOGART
12	QAMSV	LTXTENTSPR	T002	SPRAS
13	QAMSV	MASSEINHSW	T006C	MSEH6
14	QAMSV	MENGENEINH	T006	MSEHI
15	QAMSV	MERKGEW	TQ17A	MERKKLASSE
16	QAMSV	PROBEMGEH	T006	MSEHI
17	QAMSV	PRUEFQUALI	TQ11	PRFQL
18	QAMSV	QMTB_WERKS	T001W	WERKS
19	QAMSV	QPAMSP1	T002	SPRAS
20	QAMSV	QPAMSP2	T002	SPRAS
21	QAMSV	QPAMSP3	T002	SPRAS
22	QAMSV	QPAMSP4	T002	SPRAS
23	QAMSV	QPAMSP5	T002	SPRAS
24	QAMSV	STATUSV	TQ76	STATUS

History

Last changed by/on	SAP	20130529
SAP Release Created in