SAP ABAP Table QAISR1 (Structure for uploading sample results from QM subsystem)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QEIF (Package) QM interfaces inspection processing

Basic Data

Table Category	INTTAB	Structure
Structure	QAISR1	Table Relationship Diagram
Short Description	Structure for uploading sample results from QM subsystem

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	SATZART	☑	QEIFART	QEIFART	CHAR	3	0	Record Types for QM Interface - Subsystems
2	RUECKMELNR	☑	QRUECKNR	QRUECKNR	NUMC	8	0	Confirmation Number for Inspection Characteristic
3	PROBENR	☑	QSTIPRONR	QPROBENR	NUMC	6	0	Number of the Partial Sample	QASV
4	KZLPROBE	☐	QEIFKZENDE	QKZ	CHAR	1	0	Last Original Value, Sample or Inspection Point
5	KZABSCHL	☐	QEIFABSCHL	QKZ	CHAR	1	0	Close Characteristic or Sample
6	KZBEWEEXT	☐	QEIFBEWE	QKZ	CHAR	1	0	Copy Valuation from External System
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	*
9	GRUPPE1	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
10	CODE1	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
11	GRUPPE2	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
12	CODE2	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
13	GRUPPE3	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
14	CODE3	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
15	GRUPPE4	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
16	CODE4	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
17	GRUPPE5	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
18	CODE5	☐	QCODE	QCODE	CHAR	4	0	Code	QPCD
19	ANZWERTG	☐	QEIFANZWRT	NUMC4	NUMC	4	0	No. of Valid Values for Sample Results Upload to QM subsys.
20	ANZFEHLEH	☐	QEIFAFHLEH	CHAR4	CHAR	4	0	Number of Nonconforming Units for QM Subsystem Interface
21	ANZFEHLER	☐	QEIFANZFHL	CHAR4	CHAR	4	0	Number of Defects for Sample Confirmation Using QM-IDI
22	ANZWERTO	☐	QEIFAWERTO	CHAR4	CHAR	4	0	Number of Values Above Tolerance Limit (Sample)
23	ANZWERTU	☐	QEIFAWERTU	CHAR4	CHAR	4	0	Number of Values Below the Tolerance Limit (Sample)
24	MITTELWERT	☐	QMITTEWRTC	QSTATWERTC	CHAR	16	0	Arithmetic Mean of Valid Measured Values
25	VARIANZ	☐	QVARIANZC	QSTATWERTC	CHAR	16	0	Dispersion (Variance) of Valid Measured Values
26	MAXWERT	☐	QMAXWERTC	QSTATWERTC	CHAR	16	0	Maximum Value of the Valid Measured Values
27	MEDIANWERT	☐	QMEDIAWRTC	QSTATWERTC	CHAR	16	0	Median of Valid Measured Values
28	MINWERT	☐	QMINWERTC	QSTATWERTC	CHAR	16	0	Minimum Value of the Valid Measured Values
29	PRUEFDATUV	☐	QEIFPRDATV	DATUM	DATS	8	0	Inspection Start Date (QM Subsystem Interface)
30	PRUEFDATUB	☐	QEIFPRDATB	DATUM	DATS	8	0	Inspection End Date (QM Subsystem Interface)
31	PRUEFZEITV	☐	QEIFPRZTV	QZEIT	TIMS	6	0	Inspection Start Time (QM Subsystem Interface)
32	PRUEFZEITB	☐	QEIFPRZTB	QZEIT	TIMS	6	0	Inspection End Time (QM Subsystem Interface)
33	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
34	MASCHINE	☐	QMASCHINE	QEQUNR	CHAR	18	0	General Information
35	POSITION	☐	QEIFPOSMAS	CHAR4	CHAR	4	0	Position on the Machine (QM Interface - Subsystem)
36	PRUEFBEMKT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
37	MBEWERTGPR	☐	QEIFMPRBEW	QEEBEWERTG	CHAR	1	0	Valuation of Sample for Usage Decision
38	FEHLKLASPR	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17
39	MBEWERTGMK	☐	QMBEWERTG	QEEBEWERTG	CHAR	1	0	Inspection Result Valuation
40	FEHLKLASMK	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAISR1	CODE1	QPCD	CODE
2	QAISR1	CODE2	QPCD	CODE	KEY	1	CN
3	QAISR1	CODE3	QPCD	CODE	KEY	1	CN
4	QAISR1	CODE4	QPCD	CODE	KEY	1	CN
5	QAISR1	CODE5	QPCD	CODE	KEY	1	CN
6	QAISR1	FEHLKLASMK	TQ17	FEHLKLASSE	KEY	1	CN
7	QAISR1	FEHLKLASPR	TQ17	FEHLKLASSE	KEY	1	CN
8	QAISR1	GRUPPE1	QPGR	CODEGRUPPE	KEY	1	CN
9	QAISR1	GRUPPE2	QPGR	CODEGRUPPE	KEY	1	CN
10	QAISR1	GRUPPE3	QPGR	CODEGRUPPE	KEY	1	CN
11	QAISR1	GRUPPE4	QPGR	CODEGRUPPE	KEY	1	CN
12	QAISR1	GRUPPE5	QPGR	CODEGRUPPE	KEY	1	CN
13	QAISR1	PROBENR	QASV	PROBENR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in