SAP MCIPMIS PMIS: Master data characteristics for PMIS before image Table data and field list

MCIPMIS is a standard SAP Table which is used to store PMIS: Master data characteristics for PMIS before image data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MCIPMIS table consists of various fields, each holding specific information or linking keys about PMIS: Master data characteristics for PMIS before image data available in SAP. These include OBJNR (Object Number for Status Management), STWAE (Statistics currency), WAERS (Currency Key), EQUNR (Equipment Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MCIPMIS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MCIPMIS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MCIPMIS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
OBJNR	Object Number for Status Management	QMOBJNR	CHAR	22	ONR00		J_OBJNR
STWAE	Statistics currency	STWAE	CUKY	5	TCURC		WAERS
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
BEGRU	PMIS: Authorization group for equipment	EAUTG	CHAR	4	T370B		IAUTG
EQTYP	Equipment category	EQTYP	CHAR	1	T370T		EQTYP	EQT
EQART	Type of Technical Object	EQART	CHAR	10	T370K		EQART
INVNR	Inventory number	INVNR	CHAR	25			INVNR_ANLA
ANSDT	Acquisition date	ANDTI	DATS	8			DATUM
ELIEF	Vendor number	ELIEF	CHAR	10	LFA1	ALPHA	LIFNR
HERST	Manufacturer of asset	HERST	CHAR	30			TEXT30
SERGE	Manufacturer serial number	SERGE	CHAR	30			CHAR30
TYPBZ	Manufacturer model number	TYPBZ	CHAR	20			TYPBZ
GERNR	Serial Number	GERNR	CHAR	18		GERNR	GERNR	SER
EQLFN	Consecutive numbering of EquipUsagePeriods on same day	EQLFN	NUMC	3			NUM03	EQL
BAUJJ	Year of construction	BAUJJ	CHAR	4		GJAHR	CJAHR
SDATE	Date	DATUM	DATS	8			DATUM
.INCLU--AP				0
CUOBJ	Configuration (internal object number)	CUOBJ	NUMC	18			CUOBJ	CUX
SERNR	Serial Number	GERNR	CHAR	18		GERNR	GERNR	SER
KMATN	Configurable Material	KMATN	CHAR	18	Assigned to domain	MATN1	MATNR		MAT1
.INCLU--AP				0
J_3GEIGNER	Owner	J_3GEIGNER	CHAR	12	Assigned to domain		J_3GEIGVER		J_3GEE
J_3GVERWAL	Administrator	J_3GVERWAL	CHAR	12	Assigned to domain		J_3GEIGVER		J_3GEV
J_3GKONDE	Material Pricing Group	KONDM	CHAR	2	T178		KONDM	VKM
J_3GEIFR	Indicator for Own/External Equipment	J_3GEIFR	CHAR	1			J_3GEIFR
J_3GEQART	Procurement Type for External Equipment	J_3GEQART	CHAR	10			J_3GEQART
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
TPLKZ	Functional location structure indicator	TPLKZ	CHAR	5	T370S		TPLKZ	ISR
FLTYP	Functional location category	FLTYP	CHAR	1	T370F		FLTYP	IFT
TPLMA	Superior functional location	TPLMA	CHAR	30	IFLOT	TPLNR	TPLNR		IFLM
PBEGRU	Technical object authorization group	IAUTG	CHAR	4	T370B		IAUTG
TRPNR	Reference functional location	TRPNR	CHAR	30	IRLOT		TRPNR	IRL	IRLM
MAPAR	Manufacturer part number	MAPAR	CHAR	30			MAPAR
IEQUI	Installation of equipment allowed at the functional location	IEQUI	CHAR	1			X
EINZL	Single equipment installation at functional location	EINZL	CHAR	1			XFELD
LGWID	Object ID of the Work Center	LGWID	NUMC	8	CRID		CR_OBJID
PM_OBJTY	Object Type of CIM Resources for Work Center	PM_OBJTY	CHAR	2			CR_OBJTY
ABCKZ	ABC indicator for technical object	ABCKZ	CHAR	1	T370C		ABCKZ
EQFNR	Sort field	EQFNR	CHAR	30			CHAR30
SWERK	Maintenance plant	SWERK	CHAR	4	T001W		WERKS	SWK
STORT	Asset location	STORT	CHAR	10	T499S		AP_STAND
MSGRP	Room	RAUMNR	CHAR	8			CHAR8
BEBER	Plant section	BEBER	CHAR	3	T357		BEBER	BBE
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
ANLNR	Main Asset Number	ANLN1	CHAR	12	ANLH	ALPHA	ANLN1	AN1
ANLUN	Asset Subnumber	ANLN2	CHAR	4	ANLA	ALPHA	ANLN2	AN2
DAUFN	Standing order number	DAUFN	CHAR	12	AUFK	ALPHA	AUFNR		ORDP
SKLSOB	PMIS: Object class	SKLSOB	CHAR	18			SKLOBJ
ZEITP	Event for which updating should take place	DZEITP	CHAR	2	TMC5		ZEITP
SUBMT	Material number for equipment	SSUBMT	CHAR	18	MARA	MATN1	MATNR	MAT
SERIALNR	Serial Number	GERNR	CHAR	18		GERNR	GERNR	SER
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1

Key field

Non-key field

< MCIPMCOUSR - PMIS: Reference for customer-specific cost and hour key figs MCIPMZ - PM communication structure - user >

How do I retrieve data from SAP table MCIPMIS using ABAP code

The following ABAP code Example will allow you to do a basic selection on MCIPMIS to SELECT all data from the table
DATA: WA_MCIPMIS TYPE MCIPMIS.

SELECT SINGLE *
FROM MCIPMIS
INTO CORRESPONDING FIELDS OF WA_MCIPMIS
WHERE...

How to access SAP table MCIPMIS

Within an ECC or HANA version of SAP you can also view further information about MCIPMIS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).