MCIPMIS SAP (PMIS: Master data characteristics for PMIS before image) Table details
Dictionary Type: Table
Description: PMIS: Master data characteristics for PMIS before image
Description: PMIS: Master data characteristics for PMIS before image
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 |
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 |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects