SAP ABAP Table QASR (Sample results 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	TRANSP	Transparent table
Transparent table	QASR	Table Relationship Diagram
Short Description	Sample results for inspection characteristics

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	VORGLFNR	☑	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
4	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
5	PROBENR	☑	QSTIPRONR	QPROBENR	NUMC	6	0	Number of the Partial Sample	QASV
6	SATZSTATUS	☐	QBEASTATUS	QSTATUS	CHAR	1	0	Results Record Status	TQ76
7	ATTRIBUT	☐	QATTRIBUT	QATTRIBUT	CHAR	1	0	Attribute of the Results Record (Valid, Invalid,...)
8	QERGDATH	☐	QERGDATH	QERGDATH	CHAR	2	0	Origin of Results Data	TQ73
9	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
10	ERSTELLDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
11	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
12	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
13	MBEWERTG	☐	QMBEWERTG	QEEBEWERTG	CHAR	1	0	Inspection Result Valuation
14	DBEWERTG	☐	QDBEWERTG	QEEBEWERTG	CHAR	1	0	Valuation of the Characteristic for Dynamic Modification
15	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
16	PRUEFDATUV	☐	QPRUEFDATV	DATUM	DATS	8	0	Inspection Start Date
17	PRUEFDATUB	☐	QPRUEFDATB	DATUM	DATS	8	0	End Date of the Inspection
18	PRUEFZEITV	☐	QPRUEFZTV	QZEIT	TIMS	6	0	Starting Time of the Inspection
19	PRUEFZEITB	☐	QPRUEFZTB	QZEIT	TIMS	6	0	End Time of the Inspection
20	PRUEFBEMKT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
21	PRLTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
22	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
23	ISTSTPUMF	☐	QISTSTPUMF	QANZAHL4	INT4	10	0	Number of Recorded Sample Units
24	ANZFEHLEH	☐	QANZFEHEH2	QANZAHL2	INT2	5	0	Number of Nonconforming Sample Units
25	ANTEILNI	☐	QNIANTEIL	QNOTINI	CHAR	1	0	Not Initialized for Fraction
26	ANTEIL	☐	QANTEIL	QSTATWERT	FLTP	16	16	Estimated Fraction of Nonconforming Sample Units
27	ANZFEHLER	☐	QANZFEHL2	QANZAHL2	INT2	5	0	Number of Defects Found
28	ANZWERTO	☐	QANZWERTO2	QANZAHL2	INT2	5	0	Number of Measured Values Above the Tolerance Range
29	ANZWERTU	☐	QANZWERTU2	QANZAHL2	INT2	5	0	Number of Measured Values Below the Tolerance Range
30	ANZWERTG	☐	QANZWERTG2	QANZAHL2	INT2	5	0	Number of Inspected Sample Units
31	MAXWERTNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
32	MEDIANNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
33	MINWERTNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
34	MITTELWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
35	VARIANZNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
36	MOMENT3NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
37	MOMENT4NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
38	ANTEILONI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
39	ANTEILUNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
40	MAXWERT	☐	QMAXWERT	QSTATWERT	FLTP	16	16	Maximum Value of the Valid Measured Values
41	MEDIANWERT	☐	QMEDIANWRT	QSTATWERT	FLTP	16	16	Median of Valid Measured Values
42	MINWERT	☐	QMINWERT	QSTATWERT	FLTP	16	16	Minimum Value of the Valid Measured Values
43	MITTELWERT	☐	QMITTELWRT	QSTATWERT	FLTP	16	16	Arithmetic Mean of Valid Measured Values
44	VARIANZ	☐	QVARIANZ	QSTATWERT	FLTP	16	16	Dispersion (Variance) of Valid Measured Values
45	MOMENT3	☐	QMOMENT3	QSTATWERT	FLTP	16	16	Third Central Moment of Valid Measured Values
46	MOMENT4	☐	QMOMENT4	QSTATWERT	FLTP	16	16	Fourth Central Moment of Valid Measured Values
47	ANTEILO	☐	QANTEILO	QSTATWERT	FLTP	16	16	Estimated Fraction Above the Tolerance Range
48	ANTEILU	☐	QANTEILU	QSTATWERT	FLTP	16	16	Estimated Fraction Below the Tolerance Range
49	KATALGART1	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
50	GRUPPE1	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
51	CODE1	☐	QCODE	QCODE	CHAR	4	0	Code	*
52	VERSION1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
53	KATALGART2	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
54	GRUPPE2	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
55	CODE2	☐	QCODE	QCODE	CHAR	4	0	Code	*
56	VERSION2	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
57	KATALGART3	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
58	GRUPPE3	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
59	CODE3	☐	QCODE	QCODE	CHAR	4	0	Code	*
60	VERSION3	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
61	KATALGART4	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
62	GRUPPE4	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
63	CODE4	☐	QCODE	QCODE	CHAR	4	0	Code	*
64	VERSION4	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
65	KATALGART5	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
66	GRUPPE5	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
67	CODE5	☐	QCODE	QCODE	CHAR	4	0	Code	*
68	VERSION5	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
69	FEHLKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17
70	SENDEFLAG	☐	QSENDEFLAG	QSENDEFLAG	CHAR	1	0	Characteristic Result Confirmation from Control Station
71	MASCHINE	☐	QMASCHINE	QEQUNR	CHAR	18	0	General Information
72	POSITION	☐	QPRPOS	QPRPOS	NUMC	4	0	Test Position
73	AENDBELEG	☐	QKZAENBEL	QKZ	CHAR	1	0	Create Change Documents During Results Recording
74	KZBEWERTG	☐	QKZBEWERTG	QKZBEWERTG	CHAR	1	0	Valuation Copied or Forced
75	ZEITERSTL	☐	QZEITERSTL	QZEIT	TIMS	6	0	Time at which data record was created
76	ZEITAEND	☐	QZEITAEND	QZEIT	TIMS	6	0	Time at which data record was last changed
77	ORIGINAL_INPUT	☐	QORIGINAL_INPUT	CHAR25	CHAR	25	0	Original Value Before Input Processing
78	DIFF_DEC_PLACES	☐	QDIFF_DEC_PLACES	INT2	INT2	5	0	Different Number of Decimal Places
79	INPPROC_READY	☐	QINPPROC_READY	QKZ	CHAR	1	0	Input Processing Successfully Completed
80	SIGN_ID	☐	SIGN_GUID_22_CHG	SYSUUID_22	CHAR	22	0	Digital Signature for Process
81	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	QASR	FEHLKLAS	TQ17	FEHLKLASSE	REF	C	N
2	QASR	KATALGART1	TQ15	KATALOGART	REF	C	N
3	QASR	KATALGART2	TQ15	KATALOGART	REF	C	N
4	QASR	KATALGART3	TQ15	KATALOGART	REF	C	N
5	QASR	KATALGART4	TQ15	KATALOGART	REF	C	N
6	QASR	KATALGART5	TQ15	KATALOGART	REF	C	N
7	QASR	LTEXTSPR	T002	SPRAS	REF	C	N
8	QASR	MANDANT	T000	MANDT	KEY	1	CN
9	QASR	PROBENR	QASV	PROBENR	KEY	1	C
10	QASR	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
11	QASR	QERGDATH	TQ73	QERGDATH	REF	C	N
12	QASR	SATZSTATUS	TQ76	STATUS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in