SAP ABAP Table MCIQF (Notification item 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	MCIQF	Table Relationship Diagram
Short Description	Notification item 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
3	FENUM	☐	FELFD	FELFD	NUMC	4	0	Item Number in Item Record	QMFE
4	FEKAT	☐	SFEKAT	QKATART	CHAR	1	0	Catalog type - damage	TQ15
5	FEGRP	☐	SFEGRP	QCODEGRP	CHAR	8	0	PMIS:Code group - damage	*
6	FECOD	☐	SFECOD	QCODE	CHAR	4	0	PMIS: Damage	*
7	OTKAT	☐	STLKAT	QKATART	CHAR	1	0	Catalog type - object part	TQ15
8	OTGRP	☐	STLGRP	QCODEGRP	CHAR	8	0	PMIS: Code group - object part	*
9	SOTEIL	☐	STLCOD	QCODE	CHAR	4	0	PMIS: Object part	*
10	BAUTL	☐	SBAUTL	MATNR	CHAR	18	0	Assembly item	MARA
11	URKAT	☐	SURKAT	QKATART	CHAR	1	0	Catalog type - cause of damage	TQ15
12	URGRP	☐	SURGRP	QCODEGRP	CHAR	8	0	PMIS: Code group - cause of damage	*
13	SURCOD	☐	SURCOD	QCODE	CHAR	4	0	PMIS: Cause of damage	*
14	MNKAT	☐	SMNKAT	QKATART	CHAR	1	0	Catalog type - Activity	*
15	MNGRP	☐	SMNGRP	QCODEGRP	CHAR	8	0	PMIS: code group - activity	*
16	SMNCOD	☐	SMNCOD	QCODE	CHAR	4	0	PMIS: Activity	*
17	FEQKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	*
18	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
19	PROBENR	☐	QPROBENR	QPROBENR	NUMC	6	0	Sample Number	*
20	.INCLUDE	☐				0	0	PMIS communication structure: PMCO key terms
21	OBJNR	☐	BP_OBJEKT	J_OBJNR	CHAR	22	0	Object number	*
22	COCUR	☐	BP_WAERS	WAERS	CUKY	5	0	Currency	*
23	BELTP	☐	BP_INOUT	BP_INOUT	NUMC	1	0	Debit type
24	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
25	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
26	ACPOS	☐	ACPOS	ACPOS	CHAR	14	0	Value category	*
27	VERSN	☐	BP_VERSION	BP_VERSION	CHAR	3	0	Planning/budgeting version	*
28	PERBL	☐	PERBL	PERBL	NUMC	3	0	Period block
29	WRTCO	☐	BP_WPL	WERTV8	CURR	15	2	Period value in ledger currency
30	CODAT	☐	IACODATE	DATUM	DATS	8	0	PMIS: Beginning date of the current posting period
31	MENTP	☐	MENTP	GRTYP	CHAR	1	0	Quantity Type
32	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	*
33	MENCO	☐	MEGXXX	MENGV8	QUAN	15	3	Total Quantity
34	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
35	.INCLUDE	☐				0	0	PMIS: Additional fields PM notification item
36	SSCODE	☐	SSCODE	MCZAEHLER	DEC	9	0	PMIS: No.of damages
37	SUCODE	☐	SUCODE	MCZAEHLER	DEC	9	0	PMIS: No. of cause of damage codes
38	STCODE	☐	STCODE	MCZAEHLER	DEC	9	0	PMIS: No. of object part codes
39	SACODE	☐	SACODE	MCZAEHLER	DEC	9	0	PMIS: number of activity codes
40	SMNGFA	☐	SMNGFA	MCZAEHLER	DEC	9	0	Activity factor
41	.INCLUDE	☐				0	0	PMIS: Additional fields for job costs
42	IAKOSIST	☐	DGESKOSIST	WERTV8	CURR	15	2	Total(actual) maintenance costs
43	IAKOSPLAN	☐	DGESKOPLAN	WERTV8	CURR	15	2	Total plant maintenance costs (planned)
44	IAERTRAG	☐	DGESERTRAG	WERTV8	CURR	15	2	Total plant maintenance revenues (actual)
45	IAPERKOSE	☐	DPERKOSEIG	WERTV8	CURR	15	2	PMIS: PM costs for internal wages
46	IAPERKOSF	☐	DPERKOSFRD	WERTV8	CURR	15	2	PMIS: PM costs for external wages
47	IAMATKOSE	☐	DMATKOSEIG	WERTV8	CURR	15	2	PMIS: PM costs for internal material
48	IAMATKOSF	☐	DMATKOSFRD	WERTV8	CURR	15	2	PMIS: PM costs for external material
49	IADIENKOS	☐	DDIENLKOST	WERTV8	CURR	15	2	PMIS: PM costs for services
50	IASONKOST	☐	DSONSTKOST	WERTV8	CURR	15	2	PMIS: Miscellaneous PM costs
51	KOSTCURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
52	.INCLUDE	☐				0	0	PMIS: User structure PM notification item
53	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
54	.INCLUDE	☐				0	0	QMIS field attributes indicators (Q notifications/defects)
55	ZHLPROBL	☐	QZHLPROBL	INT4	INT4	10	0	Problem Frequency
56	ZHLFEHL	☐	QZHLFEHL	QANZAHL4	INT4	10	0	Number of Defects
57	ZHLFPRF	☐	QZHLFPRF	QANZAHL4	INT4	10	0	No. of Defective Units To Be Inspected
58	ZHLPROPOS	☐	QZHLPROPOS	INT4	INT4	10	0	No. of Problem Items
59	SUMFBEW	☐	QSUMFBEW	QSTATWERT	FLTP	16	16	Total of Defect Valuations
60	FMGFRD	☐	QMGFRD	MENGE	QUAN	13	3	Defective Quantity for Item (External)
61	FMGEIG	☐	QMGEIG	MENGE	QUAN	13	3	Defective Quantity for Item (Internal)
62	FMGEIN	☐	QMGEIN	MEINS	UNIT	3	0	Unit of Measure for Item	*
63	ANZFEHLER	☐	QMISANZFE4	INT4	INT4	10	0	Number of Defects Found
64	FEHLBEW	☐	QFEHLBEW	FLTP	FLTP	16	16	Defect Valuation
65	UNITFLBEW	☐	QUNITFLBEW	MEINS	UNIT	3	0	Unit for Defect Valuation	*
66	.INCLUDE	☐				0	0	Additional structure to QMIS notifications: characteristics
67	QMISKEYGRP	☐	QMISKEYGRP	QMISKEYGRP	CHAR	9	0	Combination of Catalog Type and Code Group for Problem
68	QFECOD	☐	QMISFECOD	QMISCODE	CHAR	4	0	Problem Code
69	QKEYGRP_UR	☐	QMIS_URGRP	QMISKEYGRP	CHAR	9	0	Combination of Catalog Type and Code Group for Cause
70	QURCOD	☐	QMISURCOD	QMISCODE	CHAR	4	0	Cause Code
71	QKEYGRP_OT	☐	QMIS_OTGRP	QMISKEYGRP	CHAR	9	0	Combination of Catalog Type + Code Group for Defect Location
72	QOTCOD	☐	QMISOTCOD	QMISCODE	CHAR	4	0	Defect Location Code
73	QKEYGRP_MN	☐	QMIS_MNGRP	QMISKEYGRP	CHAR	9	0	Combination of Catalog Type and Code Group for Activity
74	QMNCOD	☐	QMISMNCOD	QMISCODE	CHAR	4	0	Activity Code
75	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
76	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	*
77	.INCLUDE	☐				0	0	QMIS user fields Q notifications/defects (items)
78	DUMMYQ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
79	.INCLUDE	☐				0	0	PMIS: Reference for customer-specific cost and hour key figs
80	SAPCOSTS	☐	DCUSTCOSTS	WERTV8	CURR	15	2	PMIS: template for freely definable value/cost key figure
81	SAPHOURS	☐	DCUSTHOURS	MENGV8	QUAN	15	3	PMIS: Template for freely definable quantity/hour key figure

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCIQF	BAUTL	MARA	MATNR
2	MCIQF	FEKAT	TQ15	KATALOGART
3	MCIQF	FENUM	QMFE	FENUM
4	MCIQF	MANDT	T000	MANDT
5	MCIQF	OTKAT	TQ15	KATALOGART
6	MCIQF	QMNUM	QMEL	QMNUM
7	MCIQF	URKAT	TQ15	KATALOGART

History

Last changed by/on	SAP	20130529
SAP Release Created in