SAP ABAP Table QASPR (Result and specification record for the sample)

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	QASPR	Table Relationship Diagram
Short Description	Result and specification record for the sample

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	PROBENR	☐	QPROBENR	QPROBENR	NUMC	6	0	Sample Number	*
4	UPSLV	☐	QUPSL	QUPSL	CHAR	1	0	Data Base Access
5	MARK	☐	QMARK	QKZ	CHAR	1	0	Selection Field
6	STATUSV	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
7	ERSTELLERV	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
8	ERSTELLDAV	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
9	AENDERERV	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
10	AENDERDATV	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
11	ANNAHMEZ	☐	QANNAHMEZ	QINT2NEG	INT2	5	0	Acceptance Number
12	RUECKWEZ	☐	QRUECKWEZ	QANZAHL2	INT2	5	0	Rejection Number
13	KFAKTORNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
14	KFAKTOR	☐	QKFAKTOR	QKFAKTOR	FLTP	16	16	K-Factor for a Variable Inspection
15	ANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	*
16	BEWREGEL	☐	QBEWERT	QKEY1	CHAR	2	0	Valuation Rule	QDFM
17	FBNAME	☐	QFBNAME	FUNCNAME	CHAR	30	0	Name of Function Module	*
18	KZATTRFE	☐	QKZATTRFE	QKZ	CHAR	1	0	Attributive Inspection by Nonconforming Units
19	KZATTRFZ	☐	QKZATTRFZ	QKZ	CHAR	1	0	Attributive Inspection by Number of Defects
20	KZVARS	☐	QKZVARS	QKZ	CHAR	1	0	Variable Inspection by S-Method
21	KZCOD	☐	QKZCOD	QKZ	CHAR	1	0	Valuation by Code
22	KZMAN	☐	QKZMAN	QKZ	CHAR	1	0	Manual Valuation
23	KZQRK	☐	QKZQRK	QKZ	CHAR	1	0	Acceptance Using Control Chart
24	KZNULL	☐	QKZKNULL	QKZ	CHAR	1	0	Inspection Against Specification Limits (k = 0)
25	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
26	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
27	PROBMGFAK	☐	QPROBMGFAK	QPROBEFAK	DEC	5	2	Sample Unit Factor
28	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
29	STIPROUMF	☐	QSTIPROUMF	QANZAHL4	INT4	10	0	Sample Size that Must Be Inspected
30	PRUEFUMF	☐	QPRUEFUMF	QMENGEPLOS	QUAN	13	3	Quantity to Be Inspected
31	MENGENEINH	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
32	QRKNR	☐	QQRKNR	QQRKNR	NUMC	12	0	Control Chart Number	QASH
33	PRSTUFE	☐	QPRSTUFE	QPRSTUFE	NUMC	4	0	Inspection Stage	*
34	PRSCHAERFE	☐	QPRSCHAERF	QPRSCHAERF	NUMC	3	0	Inspection Severity	*
35	UPSLR	☐	QUPSL	QUPSL	CHAR	1	0	Data Base Access
36	STATUSR	☐	QBEASTATUS	QSTATUS	CHAR	1	0	Results Record Status	TQ76
37	ATTRIBUT	☐	QATTRIBUT	QATTRIBUT	CHAR	1	0	Attribute of the Results Record (Valid, Invalid,...)
38	QERGDATHPL	☐	QERGDATHPL	QERGDATH	CHAR	2	0	Planned Results Data Origin	*
39	QERGDATH	☐	QERGDATH	QERGDATH	CHAR	2	0	Origin of Results Data	TQ73
40	ERSTELLERR	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
41	ERSTELLDAR	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
42	AENDERERR	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
43	AENDERDATR	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
44	MBEWERTG	☐	QMBEWERTG	QEEBEWERTG	CHAR	1	0	Inspection Result Valuation
45	DBEWERTG	☐	QDBEWERTG	QEEBEWERTG	CHAR	1	0	Valuation of the Characteristic for Dynamic Modification
46	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
47	PRUEFDATUV	☐	QPRUEFDATV	DATUM	DATS	8	0	Inspection Start Date
48	PRUEFDATUB	☐	QPRUEFDATB	DATUM	DATS	8	0	End Date of the Inspection
49	PRUEFZEITV	☐	QPRUEFZTV	QZEIT	TIMS	6	0	Starting Time of the Inspection
50	PRUEFZEITB	☐	QPRUEFZTB	QZEIT	TIMS	6	0	End Time of the Inspection
51	PRUEFBEMKT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
52	PRLTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
53	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
54	PRFBEMSPRA	☐	QPRFBESPRA	SPRAS	LANG	1	0	Long Text Language for Inspection Description	*
55	ISTSTPUMF	☐	QISTSTPUMF	QANZAHL4	INT4	10	0	Number of Recorded Sample Units
56	ANZFEHLEH	☐	QANZFEHEH2	QANZAHL2	INT2	5	0	Number of Nonconforming Sample Units
57	ANTEILNI	☐	QNIANTEIL	QNOTINI	CHAR	1	0	Not Initialized for Fraction
58	ANTEIL	☐	QANTEIL	QSTATWERT	FLTP	16	16	Estimated Fraction of Nonconforming Sample Units
59	ANZFEHLER	☐	QANZFEHL2	QANZAHL2	INT2	5	0	Number of Defects Found
60	ANZWERTO	☐	QANZWERTO2	QANZAHL2	INT2	5	0	Number of Measured Values Above the Tolerance Range
61	ANZWERTU	☐	QANZWERTU2	QANZAHL2	INT2	5	0	Number of Measured Values Below the Tolerance Range
62	ANZWERTG	☐	QANZWERTG2	QANZAHL2	INT2	5	0	Number of Inspected Sample Units
63	MAXWERTNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
64	MEDIANNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
65	MINWERTNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
66	MITTELWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
67	VARIANZNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
68	MOMENT3NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
69	MOMENT4NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
70	ANTEILONI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
71	ANTEILUNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
72	MAXWERT	☐	QMAXWERT	QSTATWERT	FLTP	16	16	Maximum Value of the Valid Measured Values
73	MEDIANWERT	☐	QMEDIANWRT	QSTATWERT	FLTP	16	16	Median of Valid Measured Values
74	MINWERT	☐	QMINWERT	QSTATWERT	FLTP	16	16	Minimum Value of the Valid Measured Values
75	MITTELWERT	☐	QMITTELWRT	QSTATWERT	FLTP	16	16	Arithmetic Mean of Valid Measured Values
76	VARIANZ	☐	QVARIANZ	QSTATWERT	FLTP	16	16	Dispersion (Variance) of Valid Measured Values
77	MOMENT3	☐	QMOMENT3	QSTATWERT	FLTP	16	16	Third Central Moment of Valid Measured Values
78	MOMENT4	☐	QMOMENT4	QSTATWERT	FLTP	16	16	Fourth Central Moment of Valid Measured Values
79	ANTEILO	☐	QANTEILO	QSTATWERT	FLTP	16	16	Estimated Fraction Above the Tolerance Range
80	ANTEILU	☐	QANTEILU	QSTATWERT	FLTP	16	16	Estimated Fraction Below the Tolerance Range
81	KATALGART1	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
82	GRUPPE1	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
83	CODE1	☐	QCODE	QCODE	CHAR	4	0	Code	*
84	VERSION1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
85	KATALGART2	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
86	GRUPPE2	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
87	CODE2	☐	QCODE	QCODE	CHAR	4	0	Code	*
88	VERSION2	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
89	KATALGART3	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
90	GRUPPE3	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
91	CODE3	☐	QCODE	QCODE	CHAR	4	0	Code	*
92	VERSION3	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
93	KATALGART4	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
94	GRUPPE4	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
95	CODE4	☐	QCODE	QCODE	CHAR	4	0	Code	*
96	VERSION4	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
97	KATALGART5	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
98	GRUPPE5	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
99	CODE5	☐	QCODE	QCODE	CHAR	4	0	Code	*
100	VERSION5	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
101	FEHLKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17
102	STDABWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
103	STDABW	☐	QSTDAW	QSTATWERT	FLTP	16	16	Standard Deviation of Valid Measured Values
104	SPANNWEINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
105	SPANNWEITE	☐	QSPANNWEI	QSTATWERT	FLTP	16	16	Range of Valid Measured Values
106	SENDEFLAG	☐	QSENDEFLAG	QSENDEFLAG	CHAR	1	0	Characteristic Result Confirmation from Control Station
107	MASCHINE	☐	QMASCHINE	QEQUNR	CHAR	18	0	General Information
108	POSITION	☐	QPRPOS	QPRPOS	NUMC	4	0	Test Position
109	KATERG	☐	QKATERG	QKZ	CHAR	1	0	Catalog Confirmations Available
110	AENDBELEG	☐	QKZAENBEL	QKZ	CHAR	1	0	Create Change Documents During Results Recording
111	KZBEWERTG	☐	QKZBEWERTG	QKZBEWERTG	CHAR	1	0	Valuation Copied or Forced
112	ZEITERSTL	☐	QZEITERSTL	QZEIT	TIMS	6	0	Time at which data record was created
113	ZEITAEND	☐	QZEITAEND	QZEIT	TIMS	6	0	Time at which data record was last changed
114	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
115	FECODSELE	☐	QCODESELE	QCODE	CHAR	4	0	Selected Defect Code for Autom. Generation of Defect Records	*
116	FEGRPSELE	☐	QGRPSELE	QCODEGRP	CHAR	8	0	Code Group of the Default Record for Automatic Generation	*
117	.INCLUDE	☐				0	0	Structure enhancement for QMIS
118	STATUSROLD	☐	QBEASTATOD	QSTATUS	CHAR	1	0	Quality Status of Results Record Before Last Change	*
119	ORIGINAL_INPUT	☐	QORIGINAL_INPUT	CHAR25	CHAR	25	0	Original Value Before Input Processing
120	DIFF_DEC_PLACES	☐	QDIFF_DEC_PLACES	INT2	INT2	5	0	Different Number of Decimal Places
121	INPPROC_READY	☐	QINPPROC_READY	QKZ	CHAR	1	0	Input Processing Successfully Completed
122	SIGN_ID	☐	SIGN_GUID_22	SYSUUID_22	CHAR	22	0	Digital Signature: Signature Number as GUID with 22 Chars.
123	SIGN_STATE	☐	SIGN_STATE	SIGN_STATE	CHAR	1	0	Status of Signature Process

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QASPR	BEWREGEL	QDFM	FBKEY
2	QASPR	FEHLKLAS	TQ17	FEHLKLASSE
3	QASPR	KATALGART1	TQ15	KATALOGART
4	QASPR	KATALGART2	TQ15	KATALOGART
5	QASPR	KATALGART3	TQ15	KATALOGART
6	QASPR	KATALGART4	TQ15	KATALOGART
7	QASPR	KATALGART5	TQ15	KATALOGART
8	QASPR	LTEXTSPR	T002	SPRAS
9	QASPR	MENGENEINH	T006	MSEHI
10	QASPR	PROBEMGEH	T006	MSEHI
11	QASPR	QERGDATH	TQ73	QERGDATH
12	QASPR	QRKNR	QASH	QRKNR
13	QASPR	STATUSR	TQ76	STATUS
14	QASPR	STATUSV	TQ76	STATUS

History

Last changed by/on	SAP	20130529
SAP Release Created in