SAP ABAP Table MCIQFB (Notification item PMIS communication structure)

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	MCIQFB	Table Relationship Diagram
Short Description	Notification item PMIS communication structure

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	470