SAP ABAP Table MCIPMIS (PMIS: Master data characteristics for PMIS before image)

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	TRANSP	Transparent table
Transparent table	MCIPMIS	Table Relationship Diagram
Short Description	PMIS: Master data characteristics for PMIS before image

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	OBJNR	☑	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
3	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
4	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
5	.INCLUDE	☐				0	0	PMIS: PM equipment master
6	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
7	BEGRU	☐	EAUTG	IAUTG	CHAR	4	0	PMIS: Authorization group for equipment	T370B
8	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
9	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
10	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
11	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
12	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
13	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
14	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
15	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
16	GERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
17	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
18	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
19	SDATE	☐	DATUM	DATUM	DATS	8	0	Date
20	.INCLUDE	☐				0	0	PMIS: PM technical location master
21	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
22	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
23	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
24	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
25	PBEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
26	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
27	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
28	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
29	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
30	LGWID	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
31	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
32	.INCLUDE	☐				0	0	PMIS: Location data
33	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
34	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
35	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
36	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
37	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
38	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
39	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
40	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
41	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
42	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
43	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
44	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
45	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
46	SKLSOB	☐	SKLSOB	SKLOBJ	CHAR	18	0	PMIS: Object class
47	ZEITP	☐	DZEITP	ZEITP	CHAR	2	0	Event for which updating should take place	TMC5
48	SUBMT	☐	SSUBMT	MATNR	CHAR	18	0	Material number for equipment	MARA
49	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
50	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCIPMIS	ABCKZ	T370C	ABCKZ
2	MCIPMIS	ANLNR	ANLH	ANLN1
3	MCIPMIS	ANLUN	ANLA	ANLN2
4	MCIPMIS	BEBER	T357	BEBER
5	MCIPMIS	BEGRU	T370B	BEGRU
6	MCIPMIS	BUKRS	T001	BUKRS
7	MCIPMIS	DAUFN	AUFK	AUFNR
8	MCIPMIS	ELIEF	LFA1	LIFNR
9	MCIPMIS	EQART	T370K	EQART
10	MCIPMIS	EQTYP	T370T	EQTYP
11	MCIPMIS	EQUNR	EQUI	EQUNR
12	MCIPMIS	FLTYP	T370F	FLTYP
13	MCIPMIS	GSBER	TGSB	GSBER
14	MCIPMIS	KOKRS	TKA01	KOKRS
15	MCIPMIS	KOSTL	CSKS	KOSTL
16	MCIPMIS	LGWID	CRID	OBJID
17	MCIPMIS	MANDT	T000	MANDT		1	CN
18	MCIPMIS	MATNR	MARA	MATNR
19	MCIPMIS	OBJNR	ONR00	OBJNR	KEY	1	C
20	MCIPMIS	PBEGRU	T370B	BEGRU
21	MCIPMIS	STORT	T499S	STAND
22	MCIPMIS	STWAE	TCURC	WAERS
23	MCIPMIS	SUBMT	MARA	MATNR
24	MCIPMIS	SWERK	T001W	WERKS
25	MCIPMIS	TPLKZ	T370S	TPLKZ
26	MCIPMIS	TPLMA	IFLOT	TPLNR
27	MCIPMIS	TPLNR	IFLOT	TPLNR
28	MCIPMIS	TRPNR	IRLOT	TRPNR
29	MCIPMIS	WAERS	TCURC	WAERS
30	MCIPMIS	ZEITP	TMC5	ZEITP

History

Last changed by/on	SAP	20130529
SAP Release Created in