SAP ABAP View QSTH_DB_SEL (QM Stabi: Selection of Stability Study History Detail Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ QM-IM (Application Component) Quality Inspection
     ⤷ QSTABI (Package) Stability Study

Basic Data

View Type	D	Database View
Database View	QSTH_DB_SEL
Short Description	QM Stabi: Selection of Stability Study History Detail Data
Root table	QALS	Inspection lot record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QALS	QALS
2	AFVC
3	QAMV
4	QASR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QALS	MANDANT	JL	EQ				0	0
2	QAMV	MANDANT	JR	EQ			AND	0	0
3	QALS	PRUEFLOS	JL	EQ				0	0
4	QAMV	PRUEFLOS	JR	EQ			AND	0	0
5	QALS	MANDANT	JL	EQ				0	0
6	AFVC	MANDT	JR	EQ			AND	0	0
7	QALS	AUFPL	JL	EQ				0	0
8	AFVC	AUFPL	JR	EQ			AND	0	0
9	AFVC	APLZL	JL	EQ				0	0
10	QAMV	VORGLFNR	JR	EQ			AND	0	0
11	QALS	MANDANT	JL	EQ				0	0
12	QASR	MANDANT	JR	EQ			AND	0	0
13	QALS	PRUEFLOS	JL	EQ				0	0
14	QASR	PRUEFLOS	JR	EQ			AND	0	0
15	AFVC	APLZL	JL	EQ				0	0
16	QASR	VORGLFNR	JR	EQ			AND	0	0
17	QAMV	MERKNR	JL	EQ				0	0
18	QASR	MERKNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDANT	QALS	MANDANT		☐	MANDT	☐	Client
2	PRUEFLOS	QALS	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
3	VORGLFNR	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
4	MERKNR	QAMV	MERKNR		☐	QMERKNRP	☐	Inspection Characteristic Number
5	PROBENR	QASR	PROBENR		☐	QSTIPRONR	☐	Number of the Partial Sample
6	VERWMERKM	QAMV	VERWMERKM		☐	QMERKNR	☐	Master Inspection Characteristics
7	MKVERSION	QAMV	MKVERSION		☐	QVERSNRMK	☐	Version Number of the Master Inspection Characteristic
8	MKKTEXT	QAMV	KURZTEXT		☐	QMKKURZTXT	☐	Short Text for the Inspection Characteristic
9	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
10	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
11	RUECKMELNR	QAMV	RUECKMELNR		☐	QRUECKNR	☐	Confirmation Number for Inspection Characteristic
12	STEUERKZ	QAMV	STEUERKZ		☐	QMKCONTROL	☐	Cntrl Indicator String for Insp. Char./Master Insp. Char.
13	STELLEN	QAMV	STELLEN		☐	QSTELLEN	☐	Number of Places to the Right of a Decimal Point (Accuracy)
14	MASSEINHSW	QAMV	MASSEINHSW		☐	QMASSEH	☐	Unit of Measurement, in Which Quantitative Data Is Stored
15	SOLLWERT	QAMV	SOLLWERT		☐	QSOLLWERTE	☐	Target Value for a Quantitative Characteristic
16	SOLLWNI	QAMV	SOLLWNI		☐	QNINITIAL	☐	Value Not Initial if Set
17	TOLERANZOB	QAMV	TOLERANZOB		☐	QTOLOB	☐	Upper Specification Limit
18	TOLOBNI	QAMV	TOLOBNI		☐	QNINITIAL	☐	Value Not Initial if Set
19	TOLERANZUN	QAMV	TOLERANZUN		☐	QTOLUN	☐	Lower Tolerance Limit
20	TOLUNNI	QAMV	TOLUNNI		☐	QNINITIAL	☐	Value Not Initial if Set
21	KATAB1	QAMV	KATAB1		☐	QKTTAB	☐	Catalog Entry Is a Selected Set
22	AUSWMENGE1	QAMV	AUSWMENGE1		☐	QCGRAUSW	☐	Assigned Code Group or Selected Set
23	AUSWMGWRK1	QAMV	AUSWMGWRK1		☐	QWERKAUSW	☐	Plant of the Assigned Selected Set
24	AUSWVERS1	QAMV	AUSWVERS1		☐	QVERSNR	☐	Version Number
25	AUSWDAT1	QAMV	AUSWDAT1		☐	QVERSDAT	☐	Key Date for Version Selection
26	NIPLANMKKZ	QAMV	NIPLANMKKZ		☐	QNIPLANMK	☐	Unplanned Characteristic
27	MITTELWNI	QASR	MITTELWNI		☐	QNINITIAL	☐	Value Not Initial if Set
28	ATTRIBUT	QASR	ATTRIBUT		☐	QATTRIBUT	☐	Attribute of the Results Record (Valid, Invalid,...)
29	MITTELWERT	QASR	MITTELWERT		☐	QMITTELWRT	☐	Arithmetic Mean of Valid Measured Values
30	MBEWERTG	QASR	MBEWERTG		☐	QMBEWERTG	☐	Inspection Result Valuation
31	KATALGART1	QASR	KATALGART1		☐	QKATAUSW	☐	Catalog Type of Assigned Code Group or Selected Set
32	GRUPPE1	QASR	GRUPPE1		☐	QCODEGRP	☐	Code Group
33	CODE1	QASR	CODE1		☐	QCODE	☐	Code
34	VERSION1	QASR	VERSION1		☐	QVERSNR	☐	Version Number
35	PRUEFBEMKT	QASR	PRUEFBEMKT		☐	QKURZTEXT	☐	Short Text
36	PRLTEXTKZ	QASR	PRLTEXTKZ		☐	QLTEXTKZ	☐	Inspection Characteristic Long Text Exists
37	LTEXTSPR	QASR	LTEXTSPR		☐	SPRAS	☐	Language Key
38	ANZFEHLEH	QASR	ANZFEHLEH		☐	QANZFEHEH2	☐	Number of Nonconforming Sample Units
39	ANZFEHLER	QASR	ANZFEHLER		☐	QANZFEHL2	☐	Number of Defects Found

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	110