SAP ABAP Table MCQAVE (Usage decision: interface to QIS)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG02 (Package) QM quality information system

Basic Data

Table Category	INTTAB	Structure
Structure	MCQAVE	Table Relationship Diagram
Short Description	Usage decision: interface to QIS

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	.INCLUDE	☐				0	0	Inspection processing: Usage decision
2	MANDANT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
4	KZART	☐	QKZART	QKZART	CHAR	1	0	Inspection Lot, Partial Lot, Single Unit, Interval
5	ZAEHLER	☐	QVEZAEHLER	QVERSNR	CHAR	6	0	Counter for Usage Decision
6	VKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
7	VWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	VAUSWAHLMG	☐	QVMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set of the Usage Decision	QPAM
9	VCODEGRP	☐	QVGRUPPE	QCODEGRP	CHAR	8	0	Code Group of the Usage Decision	QPGR
10	VCODE	☐	QVCODE	QCODE	CHAR	4	0	Usage Decision Code	QPCD
11	VERSIONAM	☐	QVERSVE	QVERSNR	CHAR	6	0	Version Number of the Selected Set Record
12	VERSIONCD	☐	QVERSNRCD	QVERSNR	CHAR	6	0	Version Number of the Code Record
13	VBEWERTUNG	☐	QBEWERTUNG	QBEWERTUNG	CHAR	1	0	Code Valuation
14	DBEWERTUNG	☐	QDBEWERT	QBEWERTUNG	CHAR	1	0	Dynamic Modif. Valuation According to Worst Case Principle
15	VFOLGEAKTI	☐	QFOLGEAKTI	QFOLGEAKTI	CHAR	8	0	Follow-Up Action	TQ07
16	QKENNZAHL	☐	QKENNZAHL	QKENNZAHL	DEC	3	0	Quality Score
17	LTEXTKZ	☐	QLTEXTAVE	QKZ	CHAR	1	0	Long Text for Usage Decision
18	VNAME	☐	QVNAME	QAENDERER	CHAR	12	0	Person who Made the Usage Decision
19	VDATUM	☐	QVEDATUM	DATUM	DATS	8	0	Date of Code Used for Usage Decision
20	VEZEITERF	☐	QVEZEITERF	QZEIT	TIMS	6	0	Time when Usage Decision Was Recorded
21	VAENAME	☐	QVAENAME	QAENDERER	CHAR	12	0	Person who Changed the Usage Decision
22	VAEDATUM	☐	QVAEDATUM	DATUM	DATS	8	0	Change Date of Usage Decision
23	VEZEITAEN	☐	QVEZEITAEN	QZEIT	TIMS	6	0	Time when Usage Decision Changed
24	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
25	TEILLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	QALT
26	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
27	.INCLUDE	☐				0	0	Additional structure
28	QKZDEF	☐	QQKZDEF	QQKZDEF	CHAR	2	0	Definition of Quality Score Classes	*
29	OBGRKL_A	☐	QOBGRKL_A	QKENNZAHL	DEC	3	0	Upper Limit of Quality Score Class A
30	UNGRKL_A	☐	QUNGRKL_A	QKENNZAHL	DEC	3	0	Lower Limit of Quality Score Class A
31	OBGRKL_B	☐	QOBGRKL_B	QKENNZAHL	DEC	3	0	Upper Limit of Quality Score Class B
32	UNGRKL_B	☐	QUNGRKL_B	QKENNZAHL	DEC	3	0	Lower Limit of Quality Score Class B
33	OBGRKL_C	☐	QOBGRKL_C	QKENNZAHL	DEC	3	0	Upper Limit of Quality Score Class C
34	UNGRKL_C	☐	QUNGRKL_C	QKENNZAHL	DEC	3	0	Lower Limit of Quality Score Class C
35	OBGRKL_D	☐	QOBGRKL_D	QKENNZAHL	DEC	3	0	Upper Limit of Quality Score Class D
36	UNGRKL_D	☐	QUNGRKL_D	QKENNZAHL	DEC	3	0	Lower Limit of Quality Score Class D
37	OBGRKL_E	☐	QOBGRKL_E	QKENNZAHL	DEC	3	0	Upper Limit of Quality Score Class E
38	UNGRKL_E	☐	QUNGRKL_E	QKENNZAHL	DEC	3	0	Lower Limit of Quality Score Class E
39	QKZ2	☐	QQKZ2	QSTATWERT	FLTP	16	16	Quality Score Squared
40	DLZEIT	☐	QDLZEIT	QSTATWERT	FLTP	16	16	Lead Time in Days
41	DLZEIT2	☐	QDLZT2	QSTATWERT	FLTP	16	16	Lead Time Squared
42	EINHTAG	☐	QEINHTAG	MEINS	UNIT	3	0	Lead Time Unit (Day)	*
43	.INCLUDE	☐				0	0	User structure: usage decision
44	UDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCQAVE	MANDANT	T000	MANDT	KEY	1	CN
2	MCQAVE	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
3	MCQAVE	STAFO	TMCB	STAFO	REF	C	CN
4	MCQAVE	TEILLOS	QALT	TEILLOS	REF	C	C
5	MCQAVE	VAUSWAHLMG	QPAM	AUSWAHLMGE	REF	1	CN
6	MCQAVE	VCODE	QPCD	CODE	REF	1	CN
7	MCQAVE	VCODEGRP	QPGR	CODEGRUPPE	REF	1	CN
8	MCQAVE	VFOLGEAKTI	TQ07	FOLGEAKTI	REF	C	CN
9	MCQAVE	VKATART	TQ15	KATALOGART
10	MCQAVE	VWERKS	T001W	WERKS

History

Last changed by/on	SAP	20041209
SAP Release Created in	470