SAP ABAP Table QAPPV (Update table for inspection point)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	QAPPV	Table Relationship Diagram
Short Description	Update table for inspection point

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

Foreign Keys

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

History

Last changed by/on	SAP	20001204
SAP Release Created in