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

Dictionary Type: Table
Description: PMIS: Master data characteristics for PMIS before image




ABAP Code to SELECT data from MCIPMIS
Related tables to MCIPMIS
Access table MCIPMIS




Table field list including key, data, relationships and ABAP select examples

MCIPMIS is a standard SAP Table which is used to store PMIS: Master data characteristics for PMIS before image data and is available within R/3 SAP systems 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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
OBJNRObject Number for Status Management QMOBJNRCHAR22ONR00J_OBJNR
STWAEStatistics currency STWAECUKY5TCURCWAERS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
BEGRUPMIS: Authorization group for equipment EAUTGCHAR4T370BIAUTG
EQTYPEquipment category EQTYPCHAR1T370TEQTYPEQT
EQARTType of Technical Object EQARTCHAR10T370KEQART
INVNRInventory number INVNRCHAR25INVNR_ANLA
ANSDTAcquisition date ANDTIDATS8DATUM
ELIEFVendor number ELIEFCHAR10LFA1ALPHALIFNR
HERSTManufacturer of asset HERSTCHAR30TEXT30
SERGEManufacturer serial number SERGECHAR30CHAR30
TYPBZManufacturer model number TYPBZCHAR20TYPBZ
GERNRSerial Number GERNRCHAR18GERNRGERNRSER
EQLFNConsecutive numbering of EquipUsagePeriods on same day EQLFNNUMC3NUM03EQL
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
SDATEDate DATUMDATS8DATUM
.INCLU--AP 0
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
KMATNConfigurable Material KMATNCHAR18Assigned to domainMATN1MATNRMAT1
.INCLU--AP 0
J_3GEIGNEROwner J_3GEIGNERCHAR12Assigned to domainJ_3GEIGVERJ_3GEE
J_3GVERWALAdministrator J_3GVERWALCHAR12Assigned to domainJ_3GEIGVERJ_3GEV
J_3GKONDEMaterial Pricing Group KONDMCHAR2T178KONDMVKM
J_3GEIFRIndicator for Own/External Equipment J_3GEIFRCHAR1J_3GEIFR
J_3GEQARTProcurement Type for External Equipment J_3GEQARTCHAR10J_3GEQART
TPLNRFunctional Location TPLNRCHAR30IFLOTTPLNRTPLNRIFLIFLM
TPLKZFunctional location structure indicator TPLKZCHAR5T370STPLKZISR
FLTYPFunctional location category FLTYPCHAR1T370FFLTYPIFT
TPLMASuperior functional location TPLMACHAR30IFLOTTPLNRTPLNRIFLM
PBEGRUTechnical object authorization group IAUTGCHAR4T370BIAUTG
TRPNRReference functional location TRPNRCHAR30IRLOTTRPNRIRLIRLM
MAPARManufacturer part number MAPARCHAR30MAPAR
IEQUIInstallation of equipment allowed at the functional location IEQUICHAR1X
EINZLSingle equipment installation at functional location EINZLCHAR1XFELD
LGWIDObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
PM_OBJTYObject Type of CIM Resources for Work Center PM_OBJTYCHAR2CR_OBJTY
ABCKZABC indicator for technical object ABCKZCHAR1T370CABCKZ
EQFNRSort field EQFNRCHAR30CHAR30
SWERKMaintenance plant SWERKCHAR4T001WWERKSSWK
STORTAsset location STORTCHAR10T499SAP_STAND
MSGRPRoom RAUMNRCHAR8CHAR8
BEBERPlant section BEBERCHAR3T357BEBERBBE
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ANLNRMain Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLUNAsset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
DAUFNStanding order number DAUFNCHAR12AUFKALPHAAUFNRORDP
SKLSOBPMIS: Object class SKLSOBCHAR18SKLOBJ
ZEITPEvent for which updating should take place DZEITPCHAR2TMC5ZEITP
SUBMTMaterial number for equipment SSUBMTCHAR18MARAMATN1MATNRMAT
SERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!