SAP MCIPMB PM communication structure Table data and field list

MCIPMB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "PM communication structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MCIPMB TYPE MCIPMB.

The MCIPMB table consists of various fields, each holding specific information or linking keys about PM communication structure data available in SAP. These include MANDT (Client), STWAE (Statistics currency), HWAER (Local Currency), WAERS (Currency Key)... 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. .

MCIPMB structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MCIPMB structure 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 MCIPMB 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
SUPKZStatistics update indicator (post in/post out) SUPKZCHAR1SUPKZ
MANDTClient MANDTCLNT3T000MANDT
STWAEStatistics currency STWAECUKY5TCURCWAERS
HWAERLocal Currency HWAERCUKY5TCURCWAERS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
STCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
EINHTAGLead Time Unit (Day) QEINHTAGUNIT3Assigned to domainCUNITMEINS
QMNUMNotification No QMNUMCHAR12QMELALPHAQMNUMIQM
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
ARTPRPriority Type ARTPRCHAR2T356AARTPR
PRIOKPriority PRIOKCHAR1T356PRIOKPRIOK
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime, at Which Record Was Added ERZEITTIMS6UHRZT
QMDATDate of Notification QMDATDATS8DATUM
MZEITTime of Notification MZEITTIMS6UHRZT
QMNAMName of Person Reporting Notification QMNAMCHAR12USNAM
STRMNRequired start date STRMNDATS8DATUM
STRURRequired Start Time STRURTIMS6UZEIT
LTRMNRequired End Date LTRMNDATS8DATUM
LTRURRequested End Time LTRURTIMS6UZEIT
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
KUNUMCustomer Number KUNUMCHAR10KNA1ALPHAKUNNRKUN
QMDABDate for Notification Completion QMDABDATS8DATUM
QMZABCompletion Time of Notification QMZABTIMS6UZEIT
RBNRCatalog Profile RBNRCHAR9T352BRBNR
BEZDTNotification Reference Date BEZDTDATS8DATUM
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
BAUTLAssembly BAUTLCHAR18MARAMATN1MATNRMAT
EBORTInstallation Point for Subitem EBORTCHAR20TEXT20
MSAUSBreakdown Indicator MSAUSCHAR1XFELD
AUSVNStart of Malfunction (Date) AUSVNDATS8DATUM
AUSBSEnd of Malfunction (Date) AUSBSDATS8DATUM
AUZTVStart of Malfunction (Time) AUZTVTIMS6UHRZT
AUZTBEnd of Malfunction (Time) AUZTBTIMS6UHRZT
AUSZTBreakdown Duration AUSZTFLTP16(16) FLTP
MAUEHUnit for Breakdown Duration MAUEHUNIT3T006CUNITMEINS
BTPLNFunctional Location Affected BTPLNCHAR30IFLOTTPLNRTPLNRIFLIFLM
BEQUIEquipment Affected BEQUICHAR18EQUIALPHAEQUNREQN
AUSWKEffect on Operation AUSWKCHAR1T357AAUSWK
VERFVAvailability Before Malfunction VERFVNUMC3NUM3
VERFNAvailability After Malfunction VERFNNUMC3NUM3
VERFMAvailability After Completion of Task VERFMNUMC3NUM3
ANLZVSystem Condition Before Malfunction ANLZVCHAR1T357ZANLAZ
ANLZNSystem Condition After Malfunction ANLZNCHAR1T357ZANLAZ
ANLZESystem Condition After Completion of Task ANLZECHAR1T357ZANLAZ
INSPKName of Person Responsible for Technical Inspection INSPKCHAR12USNAM
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
DATANDate of Technical Inspection DATANDATS8DATUM
SKLSOBPMIS: Object class SKLSOBCHAR18SKLOBJ
SUBMTMaterial number for equipment SSUBMTCHAR18MARAMATN1MATNRMAT
CROBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
ARBPLObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
ARBPLWERKPlant for Work Center QARBPWERKSCHAR4T001WWERKSWRK
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
FEARTReport Type for Defects Recording QFEARTCHAR8TQ86QFEARTQFE
HERSTELLERNumber of Manufacturer QLIFNRCHAR10LFA1ALPHALIFNRLIF
LIFNUMVendor Account Number LIFNUMCHAR10LFA1ALPHALIFNRLIF
BUNAMEAuthor of a Q/PM Notification BUNAMECHAR12USR02XUBNAMEXUS
MAWERKPlant for Material QMAWERKSCHAR4T001WWERKSWRK
QMKATCatalog Type - Coding QMKATCHAR1Assigned to domainQKATART
QMGRPCode Group - Coding QMGRPCHAR8Assigned to domainQCODEGRP
QMCODCoding QMCODCHAR4Assigned to domainQCODE
MGFRDDefective Quantity (External) MGFRDQUAN13(3) MENGE
MGEINBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MGEIGDefective Quantity (Internal) MGEIGQUAN13(3) MENGE
RKMNGComplaint Quantity RKMNGQUAN13(3) MENGE
RGMNGReturn Delivery Quantity RGMNGQUAN13(3) MENGE
RKDATDate of Return Delivery RKDATDATS8DATUM
SERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
KZLOESCHDelete Data Record KZLOESCHCHAR1CHAR1
VBELNSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDAUFSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
SMOFNNo.of recorded notifications SMOFNDEC9MCZAEHLER
SMMABNo. of completed notifications SMMABDEC9MCZAEHLER
SABTGNo. processing days creation to completion SABTGDEC9MCZAEHLER
SMSAUSNumber of actual machine breakdowns SMSAUSDEC9MCZAEHLER
SAUSZTTime To Repair SAUSZTQUAN13(3) MENG13
SEQTBRTime Between Repair SEQTBRQUAN13(3) MENG13
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SGMSAUSNumber of machine breakdowns reported SGMSAUSDEC9MCZAEHLER
SGAUSZTDowntime entered SGAUSZTQUAN13(3) MENG13
SUNITUnit for Breakdown Duration MAUEHUNIT3T006CUNITMEINS
SSCODEPMIS: No.of damages SSCODEDEC9MCZAEHLER
SUCODEPMIS: No. of cause of damage codes SUCODEDEC9MCZAEHLER
SACODEPMIS: number of activity codes SACODEDEC9MCZAEHLER
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
ZHLMELDNo. of Notifications QZHLMELDINT410INT4
ZHLMOFNNo. of Notifications with Status Outstanding QZHLMOFNINT410INT4
ZHLMIARNo. of Notifications with Status Being Processed QZHLMIARINT410INT4
ZHLMMABNo. of Notifications with Status Completed QZHLMMABINT410INT4
ZHLMRSTNo. of Notifications with Stauts Reset QZHLMRSTINT410INT4
ZHLMASSNo. of Tasks QZHLMASSINT410INT4
ZHLMAOFNumber of Tasks with Status 'Outstanding' or 'Released' QZHLMAOFINT410INT4
ZHLMAERNo. of Tasks with Status Completed QZHLMAERINT410INT4
ZHLMERFNo. of Tasks with Status Successful QZHLMERFINT410INT4
SMMGEIGTotal Defective Quantity (Internal) QSMMGEIGQUAN17(3) QKUMMENGE
SMMGFRDTotal Defective Quantity (External) QSMMGFRDQUAN17(3) QKUMMENGE
SMRGMNGTotal Quantity Returned QSMRGMNGQUAN17(3) QKUMMENGE
SMRKMNGTotal Complaint Quantity QSMRKMNGQUAN17(3) QKUMMENGE
QKEYGRP_QMCombination of Catalog Type and Code Group for Coding QMIS_QMGRPCHAR9QMISKEYGRP
QQMCODCode for the Coding QMISQMCODCHAR4QMISCODE
DUMMYQSingle-Character Indicator CHAR1CHAR1CHAR1
APRIOOrder priority CO_APRIOCHAR1CHAR1
AUARTOrder Type AUFARTCHAR4Assigned to domainAUFARTAAT
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
IPHASMaintenance Processing Phase PM_PHASECHAR1PM_PHASE
ILARTMaintenance activity type ILACHAR3Assigned to domainILARTH_T350I
PLKNZMaintenance order planning indicator AUF_PLKNZCHAR1AUF_PLKNZ
REVNRRevision for Plant Maintenance and Customer Service REVNICHAR8Assigned to domainREVNI
GEWRKObject ID of the Work Center LGWIDNUMC8Assigned to domainCR_OBJID
ADDATPM Order: Reference Date ADDATDATS8DATUM
MATSVService product MATSVCHAR18Assigned to domainMATN1MATNRMATMAT1
MNGSPService product quantity MNGSPQUAN13(3) MENG13
MEHSPBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
IAOFNPMIS: number of maintenance orders created IAOFNDEC9MCZAEHLER
IAABGPMIS: number of completed maintenance orders IAABGDEC9MCZAEHLER
IASOFPMIS: no. of maintenance tasks to be performed immediately IASOFORTDEC9MCZAEHLER
IAUNGPLPMIS: number of unplanned maintenance orders IAUNGPLDEC9MCZAEHLER
IAPLANMPMIS: number of planned maintenance orders IAPLANMDEC9MCZAEHLER
USER4Total maintenance costs (estimated) DGESKOSSCHCURR15(2) WERTV8
IABUDGETOrder budget value (total) DAUFTBUDGCURR15(2) WERTV8
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
ANSWTAcquisition Value ANSWTCURR13(2) WERT
SNUMEQPMIS: Total number of pieces of equipment SNUMEQDEC9MCZAEHLER
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
STPOENPMIS: No. of functional locations w/o equipment installed STPOENDEC9MCZAEHLER
STPSENPMIS: No.of functional locations w.collective installation STPSENDEC9MCZAEHLER
STPEENPMIS: No.of functional locations w.individual installation STPEENDEC9MCZAEHLER
SNUMTPPMIS: Total number of functional locations SNUMTPDEC9MCZAEHLER
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
FLEET_NUMIdentification number for fleet object FLEET_NUMCHAR18FLEET_NUM
FLEET_VINManufacturer Vehicle Identification Number for Fleet Object FLEET_VINCHAR30FLEET_VIN
CHASIS_NUMChassis number CHASSIS_NUMCHAR30CHASSIS_NUM
LICENS_NUMLicense plate number LICENSE_NUMCHAR15LICENSE_NUM
PRI_CALCIndicator to determine the calculation method f. consumption PRI_CALCCHAR1PRI_CALC
NUM_AXLENumber of Axles in Fleet Object NUM_AXLENUMC2NUM2
MAX_OCCUPMaximum number of occupants MAX_OCCUPANTSNUMC4NUM4
FLEET_USEUsage indicator FLEET_USECHAR1FLEET_USE
ENG_TYPEEngine type ENGINE_TYPECHAR10ENGINE_TYPE
ENG_POWERPower at specific number of revolutions per minute ENGINE_POWERQUAN13(3) MENG13
UNIT_POWERPower unit UNIT_POWERUNIT3Assigned to domainCUNITMEINS
REVOLUTIONRevolutions per minute REVOLUTIONSNUMC7NUM7
ENGINE_CYLNumber of cylinders ENGINE_CYLNUMC2NUM2
ENGINE_CAPEngine capacity ENGINE_CAPQUAN13(3) MENG13
UNIT_CAPUnit for engine capacity measurement UNIT_CAPUNIT3Assigned to domainCUNITMEINS
FUEL_PRIConsumable Type of Primary Fuel FUEL_PRICHAR12FLUID_TYPE
GROSS_WGTTotal Weight Allowed GROSS_WGTQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
PMIS_FUELPMIS: Fuel meter PMIS_FUELFLTP16(16) IMRC_FLTPS
PMIS_DISTPMIS: Distance PMIS_DISTANCEFLTP16(16) IMRC_FLTPS
PMIS_TIMEPMIS: Operating time PMIS_TIMEFLTP16(16) IMRC_FLTPS
PMIS_MASSPMIS: Fuel Counter (Mass) PMIS_MASSFLTP16(16) IMRC_FLTPS
IAMENDISTTPMIS: Quantity Key Figure for Reserved Trip Segment DMENDISTTQUAN15(3) MENGV15
IAMENOPHRSPMIS: Quantity Key Figure for Operating Hours DMENOPHRSQUAN15(3) MENGV15
IAMENFLVOLPMIS: Fuel Volume Quantity Key Figure DMENFLVOLQUAN15(3) MENGV15
IAMENFLMSSPMIS: Fuel Mass Quantity Key Figure DMENFLMSSQUAN15(3) MENGV15
IAFUELDISTPMIS: Fuel Consumption According to Distance Covered DFUELDISTQUAN15(3) MENGV15
IAFUELTIMEPMIS: Fuel Consumption According to Working Hours DFUELTIMEQUAN15(3) MENGV15
IAMASSDISTPMIS: Fuel Mass According to Distance Covered DMASSDISTQUAN15(3) MENGV15
IAMASSTIMEPMIS: Fuel Mass According to Working Hours DMASSTIMEQUAN15(3) MENGV15
IATTLCDISTPMIS: Total Actual Costs per Reserved Route DTTLCOSTDQUAN15(3) MENGV15
IATTLCOPTMPMIS: Total Actual Costs per Operating Hour DTTLCOSTTQUAN15(3) MENGV15
DUNITPMIS: Unit Field for Distance Covered DDUNITUNIT3Assigned to domainCUNITMEINS
TUNITPMIS: Unit Field for Operating Hours DTUNITUNIT3Assigned to domainCUNITMEINS
FUNITPMIS: Unit Field for Fuel Volumes DFUNITUNIT3Assigned to domainCUNITMEINS
MUNITPMIS: Unit Field for Volume Mass DMUNITUNIT3Assigned to domainCUNITMEINS
FDUNITPMIS: Unit Field for Fuel Consumption per Route DFDUNITUNIT3Assigned to domainCUNITMEINS
FTUNITPMIS: Unit for Fuel Consumption per Hour of Operation DFTUNITUNIT3Assigned to domainCUNITMEINS
MTUNITPMIS: Unit Field for Fuel Mass per Operating Hour DMTUNITUNIT3Assigned to domainCUNITMEINS
MDUNITPMIS: Unit Field for Fuel Mass per Route DMDUNITUNIT3Assigned to domainCUNITMEINS
CDUNITPMIS: Unit for Actual Costs per Reserved Route DCDUNITUNIT3Assigned to domainCUNITMEINS
CTUNITPMIS: Unit for Actual Costs per Operating Hour DCTUNITUNIT3Assigned to domainCUNITMEINS
UNSYSUnit System DUNSYSCHAR3CHAR3
.INCLU--AP 0
MCUPDIndicator whether statistical record was updated MCUPDCHAR1X
ATINNInternal characteristic ATINNNUMC10Assigned to domainATINNATINN
ATWRTCharacteristic Value ATWRTCHAR30ATWRT
KLARTClass Type KLASSENARTCHAR3Assigned to domainKLASSENARTKAR
KONOBProduct allocation object KONOBCHAR18Assigned to domainKONOBKOB
CHKEYGRPCharacteristics combination CHKEYGRPNUMC10VTINT
CHCOMBKEYCombination value key CHCOMBKEYNUMC5NUM05
CLINTCharacteristics combination CHKEYGRPNUMC10VTINT
LNPOSCombination value key CHCOMBKEYNUMC5NUM05
BLTYPDocument category for document index updates BLTYPCHAR2BLTYP
KOBLNRDocument number: document index update KOBLNRCHAR10ALPHABELNR

Key field Non-key field



How do I retrieve data from SAP structure MCIPMB using ABAP code?

As MCIPMB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCIPMB as there is no data to select.

How to access SAP table MCIPMB

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

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