SAP ABAP Table QSTH_DB_SEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	QSTH_DB_SEL	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QSTH_DB_SEL	AUSWMGWRK1	T001W	WERKS	REF	C	N
2	QSTH_DB_SEL	KATALGART1	TQ15	KATALOGART	REF	C	N
3	QSTH_DB_SEL	LTEXTSPR	T002	SPRAS	REF	C	N
4	QSTH_DB_SEL	MANDANT	T000	MANDT	KEY	1	CN
5	QSTH_DB_SEL	MASSEINHSW	T006	MSEHI	REF	C	N
6	QSTH_DB_SEL	PROBENR	QASV	PROBENR	KEY	1	C
7	QSTH_DB_SEL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in