SAP ABAP Table QAPPS (Selection table for inspection points)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ QM-IM (Application Component) Quality Inspection
     ⤷ QLPP (Package) QM inspection points

Basic Data

Table Category	INTTAB	Structure
Structure	QAPPS	Table Relationship Diagram
Short Description	Selection table for inspection points

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	KZSEL	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)
2	.INCLUDE	☐				0	0	Inspection point
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
5	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
6	PROBENR	☐	QPROBENRPP	QPROBENR	NUMC	6	0	Sample Number (Based on an Inspection Point)	QASV
7	TEILLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	QALT
8	PPSORTKEY	☐	QPPSORTKEY	QPPSORT	CHAR	70	0	Key Field (Sort Field) for Inspection Point
9	MENGE	☐	QMENGEPP	MENG13	QUAN	13	3	Inspection Point Yield
10	MENGE_A	☐	QMENGEPPA	MENG13	QUAN	13	3	Scrap for Inspection Point
11	MENGE_N	☐	QMENGEPPN	MENG13	QUAN	13	3	Rework Quantity for The Inspection Point
12	MENGENEINH	☐	QPPMEINH	MEINS	UNIT	3	0	Unit of Measure for the Inspection Point	T006
13	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
14	EQUNRAKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
15	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
16	TPLNRAKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
17	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	QPRS
18	PHYNRAKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
19	USERC1	☐	QUSRCHAR18	QUSRCHAR18	CHAR	18	0	User Field for 18 Characters
20	USERC1AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
21	USERC2	☐	QUSRCHAR10	QUSRCHAR10	CHAR	10	0	User Field for 10 Characters
22	USERC2AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
23	USERN1	☐	QUSRNUMC10	QUSRNUMC10	NUMC	10	0	User Field for 10 Digits
24	USERN1AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
25	USERN2	☐	QUSRNUMC3	QUSRNUMC3	NUMC	3	0	User Field for 3 Digits
26	USERN2AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
27	USERD1	☐	QUSRDATS	QUSRDATS	DATS	8	0	User Field for Date
28	USERD1AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
29	USERT1	☐	QUSRTIMS	QUSRTIMS	TIMS	6	0	User Field for Time
30	USERT1AKT	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
31	VKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
32	VWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
33	VAUSWAHLMG	☐	QVMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set of the Usage Decision	QPAM
34	VCODEGRP	☐	QVGRUPPE	QCODEGRP	CHAR	8	0	Code Group of the Usage Decision	QPGR
35	VCODE	☐	QVCODE	QCODE	CHAR	4	0	Usage Decision Code	QPCD
36	VBEWERTUNG	☐	QBEWERTUNG	QBEWERTUNG	CHAR	1	0	Code Valuation
37	KZBEWERT	☐	QPPBEWERT	QPPBEWERT	CHAR	1	0	Valuation Status Inspection Point
38	KZFERTIG	☐	QPPFERTIG	QPPFERTIG	CHAR	1	0	Inspection Point Status
39	KZPTLBEST	☐	QKZPTLBEST	QKZ	CHAR	1	0	Inspection with Stock-Related Partial Lot Assignment
40	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
41	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
42	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
43	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
44	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
45	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
46	ENTSTEHDAT	☐	QENTDATPP	DATUM	DATS	8	0	Date of Inspection Point Creation
47	ENTSTEHZT	☐	QENTZEITPP	QZEIT	TIMS	6	0	Time of Inspection Point Creation
48	ERSTELLER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
49	ERSTELDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
50	ERSTELZEIT	☐	QZEITERSTL	QZEIT	TIMS	6	0	Time at which data record was created
51	AENDERER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
52	AENDERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
53	AENDERZEIT	☐	QZEITAEND	QZEIT	TIMS	6	0	Time at which data record was last changed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAPPS	EQUNR	EQUI	EQUNR	KEY	C	CN
2	QAPPS	MANDT	T000	MANDT
3	QAPPS	MENGENEINH	T006	MSEHI
4	QAPPS	PHYNR	QPRS	PHYNR	KEY	C	CN
5	QAPPS	PROBENR	QASV	PROBENR	KEY	1	CN
6	QAPPS	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
7	QAPPS	TEILLOS	QALT	TEILLOS	KEY	1	CN
8	QAPPS	TPLNR	IFLOT	TPLNR	KEY	C	CN
9	QAPPS	VAUSWAHLMG	QPAM	AUSWAHLMGE	REF	C	CN
10	QAPPS	VCODE	QPCD	CODE	REF	C	CN
11	QAPPS	VCODEGRP	QPGR	CODEGRUPPE	REF	C	CN
12	QAPPS	VKATART	TQ15	KATALOGART	REF	1	N
13	QAPPS	VWERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20001204
SAP Release Created in