SAP ABAP Table COMES_INSP_CHAR (Characteristics for the Inspection Lot (MES Integration))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MES (Application Component) Integration with Manufacturing Execution Systems
     ⤷ CO_MES_INT (Package) Integration of Production w. Manufacturing Execution Systems

Basic Data

Table Category	INTTAB	Structure
Structure	COMES_INSP_CHAR	Table Relationship Diagram
Short Description	Characteristics for the Inspection Lot (MES Integration)

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	.INCLUDE	☐				0	0	Insp. specifications-insp. lot characs.
2	INSPLOT	☐	QIBPLOSNR	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	INSPOPER	☐	QIBPVORNR	VORNR	CHAR	4	0	Inspection Lot Operation Number
4	INSPCHAR	☐	QIBPMERKNR	NUMC4	NUMC	4	0	Insp. Lot Charac. No.
5	STATUS	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
6	CHAR_DESCR	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
7	CHAR_TYPE	☐	QCHAR_TYPE	QCHAR_TYPE	CHAR	2	0	Characteristic Type
8	CONFIRM_NO	☐	QRUECKNR	QRUECKNR	NUMC	8	0	Confirmation Number for Inspection Characteristic
9	OBLIGATORY	☐	QEIFRWANG	QRZWANG	CHAR	1	0	Required Confirmation for Inspection Characteristic
10	SINGLE_RES	☐	QSINGLERES	QKZ	CHAR	1	0	Single Results
11	SAMPLE_RES	☐	QSAMPLERES	QKZ	CHAR	1	0	Sample Results
12	CHAR_RES	☐	QCHARRES	QKZ	CHAR	1	0	Characteristic Results
13	SAMPLES	☐	QTSTICHPRO	QKZUMFS	CHAR	1	0	Partial Samples Possible
14	SAMPLES_NO	☐	QEIFSTPANZ	CHAR5	CHAR	5	0	Number of Planned Partial Samples
15	SCOPE	☐	QEIFSTUMF	NUM7	NUMC	7	0	Sample Size to Be Inspected in QM Subsystem
16	SCOPE_IND	☐	QPUMFKZ	QPUMFKZ	CHAR	1	0	Inspection Scope
17	DOCU_REQU	☐	QDOKUKZ	QDOKUKZ	CHAR	1	0	Documentation Required for Inspection Results
18	SERIALREQU	☐	QEIFSERNR	QKZ	CHAR	1	0	Serial Number To Be Recorded in QM Subsystem
19	INSP_POINT	☐	QKZRAST	QKZRAST	CHAR	1	0	Indicator: Sampling Procedure for Inspection Points
20	GRID	☐	QRASTER	QRASTER	NUMC	3	0	Inspection Frequency (Only for Inspection with Insp. Points)
21	MSTR_CHAR	☐	QMSTR_CHAR	CHAR8	CHAR	8	0	Master Characteristic
22	VMSTR_CHAR	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
23	PMSTR_CHAR	☐	QEIFPMKWRK	QZAEHLER	CHAR	4	0	Plant for Master Inspection Characteristic
24	METHOD	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	QMTB
25	METHOD_TXT	☐	QEIFPMTTXT	QKURZTEXT	CHAR	40	0	Short Text for Inspection Method
26	VMETHOD	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
27	PMETHOD	☐	QEIFMTBWRK	WERKS	CHAR	4	0	Plant for Inspection Method	T001W
28	SMPL_QUANT	☐	QEIFSTPFAK	NUM6	NUMC	6	0	Sample Unit of Measurement Factor for QM Subsystem
29	SMPL_UNIT	☐	QEIFMASS	MEINS	UNIT	3	0	Base Unit of Measure for the Inspection Lot	T006
30	SMPL_UNITT	☐	QMEASUNITT	TEXT20	CHAR	20	0	Short Text for Unit of Measure
31	SMPL_UNITC	☐	QMEASUNITC	CHAR3	CHAR	3	0	ISO Code for Unit of Measure
32	PHYS_SMPL	☐	QPHYSPROBE	QPROBENR	NUMC	6	0	Number of the Partial Sample	QASV
33	CH_WGT_COD	☐	QCH_WGT_CO	CHAR2	CHAR	2	0	Characteristic Weighting
34	CH_WGT_FAC	☐	QCH_WGT_FA	CHAR4	CHAR	4	0	Characteristic Weighting Factor
35	CH_WGT_TXT	☐	QCH_WGT_TX	TEXT40	CHAR	40	0	Text for Characteristic Weighting
36	FORMULA	☐	QEIFFORMEL	QEIFFORMEL	CHAR	120	0	Complete Formula for Linking Insp. Char. to QM Subsystems
37	INFOFIELD1	☐	QINFO_FLD1	TEXT10	CHAR	10	0	Info Field 1 from the Characteristic
38	INFOFIELD2	☐	QINFO_FLD2	TEXT20	CHAR	20	0	Info Field 2 from the Characteristic
39	INFOFIELD3	☐	QINFO_FLD3	TEXT40	CHAR	40	0	Info Field 3 from the Characteristic
40	DEC_PLACES	☐	QDEC_PLACE	CHAR3	CHAR	3	0	Number of Decimal Places
41	MEAS_UNIT	☐	QMEAS_UNIT	TEXT6	CHAR	6	0	Unit of Measurement (Internal Code)
42	MEAS_UNITT	☐	QMEASUNITT	TEXT20	CHAR	20	0	Short Text for Unit of Measure
43	MEAS_UNITC	☐	QMEASUNITC	CHAR3	CHAR	3	0	ISO Code for Unit of Measure
44	TARGET_VAL	☐	QTARGET_VA	QIFLTP	CHAR	22	0	Target Value
45	UP_TOL_LMT	☐	QUPTOL_LMT	QIFLTP	CHAR	22	0	Upper Tolerance Limit
46	LW_TOL_LMT	☐	QLWTOL_LMT	QIFLTP	CHAR	22	0	Lower Tolerance Limit
47	UP_LMT_1	☐	QUPLMT_1	QIFLTP	CHAR	22	0	Limit 1 (Upper)
48	LW_LMT_1	☐	QLWLMT_1	QIFLTP	CHAR	22	0	Limit 1 (Lower)
49	UP_LMT_2	☐	QUPLMT_2	QIFLTP	CHAR	22	0	Limit 2 (Upper)
50	LW_LMT_2	☐	QLWLMT_2	QIFLTP	CHAR	22	0	Limit 2 (Lower)
51	UP_PLS_LMT	☐	QUPPLS_LMT	QIFLTP	CHAR	22	0	Plausibility Limit (Upper)
52	LW_PLS_LMT	☐	QLWPLS_LMT	QIFLTP	CHAR	22	0	Plausibility Limit (Lower)
53	UP_CTRL_1	☐	QUP_CTRL_1	QIFLTP	CHAR	22	0	Action Limit 1 (Upper)
54	LW_CTRL_1	☐	QLW_CTRL_1	QIFLTP	CHAR	22	0	Lower Action Limit 1
55	UP_CTRL_2	☐	QUP_CTRL_2	QIFLTP	CHAR	22	0	Action Limit 2 (Upper)
56	LW_CTRL_2	☐	QLW_CTRL_2	QIFLTP	CHAR	22	0	Lower Action Limit 2
57	CC_NO	☐	QCC_NO	QQRKNR	NUMC	12	0	Control Chart Number in QM	QASH
58	CC_TYPE	☐	QCC_TYPE	QQRKART	CHAR	3	0	Control Chart Type	QPSH
59	CC_TYPE_T	☐	QCC_TYPE_T	TEXT40	CHAR	40	0	Short Text for Control Chart Type
60	SEL_SET1	☐	QSEL_SET	CHAR8	CHAR	8	0	Selected Set
61	PSEL_SET1	☐	QSEL_SET_P	CHAR4	CHAR	4	0	Plant for Selected Set
62	CAT_TYPE1	☐	QCAT_TYPE	CHAR1	CHAR	1	0	Catalog Type
63	SEL_SET2	☐	QSEL_SET	CHAR8	CHAR	8	0	Selected Set
64	PSEL_SET2	☐	QSEL_SET_P	CHAR4	CHAR	4	0	Plant for Selected Set
65	CAT_TYPE2	☐	QCAT_TYPE	CHAR1	CHAR	1	0	Catalog Type
66	SEL_SET3	☐	QSEL_SET	CHAR8	CHAR	8	0	Selected Set
67	PSEL_SET3	☐	QSEL_SET_P	CHAR4	CHAR	4	0	Plant for Selected Set
68	CAT_TYPE3	☐	QCAT_TYPE	CHAR1	CHAR	1	0	Catalog Type
69	SEL_SET4	☐	QSEL_SET	CHAR8	CHAR	8	0	Selected Set
70	PSEL_SET4	☐	QSEL_SET_P	CHAR4	CHAR	4	0	Plant for Selected Set
71	CAT_TYPE4	☐	QCAT_TYPE	CHAR1	CHAR	1	0	Catalog Type
72	SEL_SET5	☐	QSEL_SET	CHAR8	CHAR	8	0	Selected Set
73	PSEL_SET5	☐	QSEL_SET_P	CHAR4	CHAR	4	0	Plant for Selected Set
74	CAT_TYPE5	☐	QCAT_TYPE	CHAR1	CHAR	1	0	Catalog Type
75	VALN_TYPE	☐	QEIFBEWSP	QEIFBEWART	CHAR	1	0	Valuation Type for Sample for QM Subsystems
76	ACCEPT_NO	☐	QEIFANNAMZ	NUMC5	NUMC	5	0	Acceptance Number in Attrib. Insp. for QM Subsystems
77	REJECT_NO	☐	QEIFRUECKZ	NUMC5	NUMC	5	0	Rejection Number in Attributive Insp. for QM Subsystems
78	K_FACTOR	☐	QKFAKTORC	QKFAKTORC	CHAR	16	0	K-Factor for a Variable Inspection
79	SHARE_CALC	☐	QEIFANVERF	QEIFANVERF	CHAR	1	0	Fraction Calculation
80	CHARACTERISTIC_NAME	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
81	RES_ORG	☐	QERGDATHPL	QERGDATH	CHAR	2	0	Planned Results Data Origin	*
82	CLASSES	☐	QCLASSES	QKZ	CHAR	1	0	Classed Recording
83	NO_RECORDING	☐	QNO_RECORDING	QKZ	CHAR	1	0	No Characteristic Recording
84	INPPROC	☐	QINPPROC	CHAR3	CHAR	3	0	Parameters for Input Processing in QM Results Recording
85	FEHLREC	☐	QFEHLREC	QKZ	CHAR	1	0	Defects Recording Automatically Called Up

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COMES_INSP_CHAR	CC_NO	QASH	QRKNR
2	COMES_INSP_CHAR	CC_TYPE	QPSH	QRKART
3	COMES_INSP_CHAR	INSPLOT	QALS	PRUEFLOS
4	COMES_INSP_CHAR	METHOD	QMTB	PMTNR
5	COMES_INSP_CHAR	PHYS_SMPL	QASV	PROBENR
6	COMES_INSP_CHAR	PMETHOD	T001W	WERKS
7	COMES_INSP_CHAR	SMPL_UNIT	T006	MSEHI
8	COMES_INSP_CHAR	STATUS	TQ76	STATUS

History

Last changed by/on	SAP	20130529
SAP Release Created in