SAP ABAP Table MCIQM (Notification header PMIS communication struct.)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-IS-REP (Application Component) Reporting
     ⤷ MCI (Package) R/3 appl. development: Plant Maintenance Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCIQM	Table Relationship Diagram
Short Description	Notification header PMIS communication struct.

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	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
2	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
3	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
4	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
8	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
9	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
10	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
11	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
12	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
13	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
14	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
15	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
18	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
19	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
20	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
21	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
22	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
23	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
24	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
25	MSAUS	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
26	AUSVN	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
27	AUSBS	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
28	AUZTV	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
29	AUZTB	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
30	AUSZT	☐	AUSZT	FLTP	FLTP	16	16	Breakdown Duration
31	MAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
32	BTPLN	☐	BTPLN	TPLNR	CHAR	30	0	Functional Location Affected	IFLOT
33	BEQUI	☐	BEQUI	EQUNR	CHAR	18	0	Equipment Affected	EQUI
34	AUSWK	☐	AUSWK	AUSWK	CHAR	1	0	Effect on Operation	T357A
35	VERFV	☐	VERFV	NUM3	NUMC	3	0	Availability Before Malfunction
36	VERFN	☐	VERFN	NUM3	NUMC	3	0	Availability After Malfunction
37	VERFM	☐	VERFM	NUM3	NUMC	3	0	Availability After Completion of Task
38	ANLZV	☐	ANLZV	ANLAZ	CHAR	1	0	System Condition Before Malfunction	T357Z
39	ANLZN	☐	ANLZN	ANLAZ	CHAR	1	0	System Condition After Malfunction	T357Z
40	ANLZE	☐	ANLZE	ANLAZ	CHAR	1	0	System Condition After Completion of Task	T357Z
41	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
42	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
43	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
44	SKLSOB	☐	SKLSOB	SKLOBJ	CHAR	18	0	PMIS: Object class
45	SUBMT	☐	SSUBMT	MATNR	CHAR	18	0	Material number for equipment	MARA
46	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
47	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
48	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
49	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
50	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
51	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
52	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
53	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	USR02
54	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
55	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	*
56	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
57	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
58	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
59	MGEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
60	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
61	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
62	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
63	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
64	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
65	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
66	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
67	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
68	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
69	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
70	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
71	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
72	.INCLUDE	☐				0	0	Additional fields - PMIS notification header
73	SMOFN	☐	SMOFN	MCZAEHLER	DEC	9	0	No.of recorded notifications
74	SMMAB	☐	SMMAB	MCZAEHLER	DEC	9	0	No. of completed notifications
75	SABTG	☐	SABTG	MCZAEHLER	DEC	9	0	No. processing days creation to completion
76	SMSAUS	☐	SMSAUS	MCZAEHLER	DEC	9	0	Number of actual machine breakdowns
77	SAUSZT	☐	SAUSZT	MENG13	QUAN	13	3	Time To Repair
78	SEQTBR	☐	SEQTBR	MENG13	QUAN	13	3	Time Between Repair
79	SPMON	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
80	SGMSAUS	☐	SGMSAUS	MCZAEHLER	DEC	9	0	Number of machine breakdowns reported
81	SGAUSZT	☐	SGAUSZT	MENG13	QUAN	13	3	Downtime entered
82	SUNIT	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
83	SSCODE	☐	SSCODE	MCZAEHLER	DEC	9	0	PMIS: No.of damages
84	SUCODE	☐	SUCODE	MCZAEHLER	DEC	9	0	PMIS: No. of cause of damage codes
85	SACODE	☐	SACODE	MCZAEHLER	DEC	9	0	PMIS: number of activity codes
86	.INCLUDE	☐				0	0	PMIS: User structure PM notification header
87	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
88	.INCLUDE	☐				0	0	QMIS field attributes indicators (Q notifications/defects)
89	ZHLMELD	☐	QZHLMELD	INT4	INT4	10	0	No. of Notifications
90	ZHLMOFN	☐	QZHLMOFN	INT4	INT4	10	0	No. of Notifications with Status Outstanding
91	ZHLMIAR	☐	QZHLMIAR	INT4	INT4	10	0	No. of Notifications with Status Being Processed
92	ZHLMMAB	☐	QZHLMMAB	INT4	INT4	10	0	No. of Notifications with Status Completed
93	ZHLMRST	☐	QZHLMRST	INT4	INT4	10	0	No. of Notifications with Stauts Reset
94	ZHLMASS	☐	QZHLMASS	INT4	INT4	10	0	No. of Tasks
95	ZHLMAOF	☐	QZHLMAOF	INT4	INT4	10	0	Number of Tasks with Status 'Outstanding' or 'Released'
96	ZHLMAER	☐	QZHLMAER	INT4	INT4	10	0	No. of Tasks with Status Completed
97	ZHLMERF	☐	QZHLMERF	INT4	INT4	10	0	No. of Tasks with Status Successful
98	SMMGEIG	☐	QSMMGEIG	QKUMMENGE	QUAN	17	3	Total Defective Quantity (Internal)
99	SMMGFRD	☐	QSMMGFRD	QKUMMENGE	QUAN	17	3	Total Defective Quantity (External)
100	SMRGMNG	☐	QSMRGMNG	QKUMMENGE	QUAN	17	3	Total Quantity Returned
101	SMRKMNG	☐	QSMRKMNG	QKUMMENGE	QUAN	17	3	Total Complaint Quantity
102	QKEYGRP_QM	☐	QMIS_QMGRP	QMISKEYGRP	CHAR	9	0	Combination of Catalog Type and Code Group for Coding
103	QQMCOD	☐	QMISQMCOD	QMISCODE	CHAR	4	0	Code for the Coding
104	.INCLUDE	☐				0	0	QMIS user data Q notifications/defects
105	DUMMYQ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCIQM	ANLZE	T357Z	ANLAZ
2	MCIQM	ANLZN	T357Z	ANLAZ
3	MCIQM	ANLZV	T357Z	ANLAZ
4	MCIQM	ARBPL	CRID	OBJID
5	MCIQM	ARBPLWERK	T001W	WERKS
6	MCIQM	ARTPR	T356A	ARTPR
7	MCIQM	AUFNR	AUFK	AUFNR
8	MCIQM	AUSWK	T357A	AUSWK
9	MCIQM	BAUTL	MARA	MATNR
10	MCIQM	BEQUI	EQUI	EQUNR
11	MCIQM	BTPLN	IFLOT	TPLNR
12	MCIQM	BUNAME	USR02	BNAME
13	MCIQM	EKORG	T024E	EKORG
14	MCIQM	FEART	TQ86	FEART
15	MCIQM	HERSTELLER	LFA1	LIFNR
16	MCIQM	INGRP	T024I	INGRP
17	MCIQM	IWERK	T399I	IWERK
18	MCIQM	KDAUF	VBUK	VBELN
19	MCIQM	KDPOS	VBUP	POSNR
20	MCIQM	KUNUM	KNA1	KUNNR
21	MCIQM	LIFNUM	LFA1	LIFNR
22	MCIQM	MATNR	MARA	MATNR
23	MCIQM	MAUEH	T006	MSEHI
24	MCIQM	MAWERK	T001W	WERKS
25	MCIQM	MGEIN	T006	MSEHI
26	MCIQM	PRIOK	T356	PRIOK
27	MCIQM	QMART	TQ80	QMART
28	MCIQM	QMNUM	QMEL	QMNUM
29	MCIQM	RBNR	T352B	RBNR
30	MCIQM	SPART	TSPA	SPART
31	MCIQM	SUBMT	MARA	MATNR
32	MCIQM	SUNIT	T006	MSEHI
33	MCIQM	VBELN	VBUK	VBELN
34	MCIQM	VKORG	TVKO	VKORG
35	MCIQM	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20110901
SAP Release Created in