SAP Table MCIPMIS
PMIS: Master data characteristics for PMIS before image
MCIPMIS (PMIS: Master data characteristics for PMIS before image) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MCIPMIS to other SAP tables.
MCIPMIS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
OBJNR
Object Number for Status Management
|
QMOBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||
|
STWAE
Statistics currency
|
STWAE | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
BEGRU
PMIS: Authorization group for equipment
|
EAUTG | T370B |
CHAR
|
4 | 0 | |||||||||||
|
EQTYP
Equipment category
|
EQTYP | T370T |
CHAR
|
1 | 0 | |||||||||||
|
EQART
Type of Technical Object
|
EQART | T370K |
CHAR
|
10 | 0 | |||||||||||
|
INVNR
Inventory number
|
INVNR |
CHAR
|
25 | 0 | ||||||||||||
|
ANSDT
Acquisition date
|
ANDTI |
DATS
|
8 | 0 | ||||||||||||
|
ELIEF
Vendor number
|
ELIEF | LFA1 |
CHAR
|
10 | 0 | |||||||||||
|
HERST
Manufacturer of asset
|
HERST |
CHAR
|
30 | 0 | ||||||||||||
|
SERGE
Manufacturer serial number
|
SERGE |
CHAR
|
30 | 0 | ||||||||||||
|
TYPBZ
Manufacturer model number
|
TYPBZ |
CHAR
|
20 | 0 | ||||||||||||
|
GERNR
Serial Number
|
GERNR |
CHAR
|
18 | 0 | ||||||||||||
|
EQLFN
Consecutive numbering of EquipUsagePeriods on same day
|
EQLFN |
NUMC
|
3 | 0 | ||||||||||||
|
BAUJJ
Year of construction
|
BAUJJ |
CHAR
|
4 | 0 | ||||||||||||
|
SDATE
Date
|
DATUM |
DATS
|
8 | 0 | ||||||||||||
|
TPLNR
Functional Location
|
TPLNR | IFLOT |
CHAR
|
30 | 0 | |||||||||||
|
TPLKZ
Functional location structure indicator
|
TPLKZ | T370S |
CHAR
|
5 | 0 | |||||||||||
|
FLTYP
Functional location category
|
FLTYP | T370F |
CHAR
|
1 | 0 | |||||||||||
|
TPLMA
Superior functional location
|
TPLMA | IFLOT |
CHAR
|
30 | 0 | |||||||||||
|
PBEGRU
Technical object authorization group
|
IAUTG | T370B |
CHAR
|
4 | 0 | |||||||||||
|
TRPNR
Reference functional location
|
TRPNR | IRLOT |
CHAR
|
30 | 0 | |||||||||||
|
MAPAR
Manufacturer part number
|
MAPAR |
CHAR
|
30 | 0 | ||||||||||||
|
IEQUI
Installation of equipment allowed at the functional location
|
IEQUI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
EINZL
Single equipment installation at functional location
|
EINZL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
LGWID
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
PM_OBJTY
Object Type of CIM Resources for Work Center
|
PM_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
ABCKZ
ABC indicator for technical object
|
ABCKZ | T370C |
CHAR
|
1 | 0 | |||||||||||
|
EQFNR
Sort field
|
EQFNR |
CHAR
|
30 | 0 | ||||||||||||
|
SWERK
Maintenance plant
|
SWERK | T001W |
CHAR
|
4 | 0 | |||||||||||
|
STORT
Asset location
|
STORT | T499S |
CHAR
|
10 | 0 | |||||||||||
|
MSGRP
Room
|
RAUMNR |
CHAR
|
8 | 0 | ||||||||||||
|
BEBER
Plant section
|
BEBER | T357 |
CHAR
|
3 | 0 | |||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||
|
ANLNR
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||
|
ANLUN
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||||||
|
DAUFN
Standing order number
|
DAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||
|
SKLSOB
PMIS: Object class
|
SKLSOB |
CHAR
|
18 | 0 | ||||||||||||
|
ZEITP
Event for which updating should take place
|
DZEITP | TMC5 |
CHAR
|
2 | 0 | |||||||||||
|
SUBMT
Material number for equipment
|
SSUBMT | MARA |
CHAR
|
18 | 0 | |||||||||||
|
SERIALNR
Serial Number
|
GERNR |
CHAR
|
18 | 0 | ||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||
MCIPMIS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MCIPMIS | ABCKZ | SYST | MANDT |
T370C
ABC indicator for technical objects
|
MANDT |
| MCIPMIS | ABCKZ | MCIPMIS | ABCKZ |
T370C
ABC indicator for technical objects
|
ABCKZ |
| MCIPMIS | ANLNR | MCIPMIS | ANLNR |
ANLH
Main asset number
|
ANLN1 |
| MCIPMIS | ANLNR | SYST | MANDT |
ANLH
Main asset number
|
MANDT |
| MCIPMIS | ANLNR | MCIPMIS | BUKRS |
ANLH
Main asset number
|
BUKRS |
| MCIPMIS | ANLUN | SYST | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| MCIPMIS | ANLUN | MCIPMIS | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| MCIPMIS | ANLUN | MCIPMIS | ANLNR |
ANLA
Asset Master Record Segment
|
ANLN1 |
| MCIPMIS | ANLUN | MCIPMIS | ANLUN |
ANLA
Asset Master Record Segment
|
ANLN2 |
| MCIPMIS | BEBER | MCIPMIS | SWERK |
T357
Plant Section
|
WERKS |
| MCIPMIS | BEBER | MCIPMIS | BEBER |
T357
Plant Section
|
BEBER |
| MCIPMIS | BEBER | SYST | MANDT |
T357
Plant Section
|
MANDT |
| MCIPMIS | BEGRU | SYST | MANDT |
T370B
Technical object authorization group
|
MANDT |
| MCIPMIS | BEGRU | MCIPMIS | BEGRU |
T370B
Technical object authorization group
|
BEGRU |
| MCIPMIS | BUKRS | SYST | MANDT |
T001
Company Codes
|
MANDT |
| MCIPMIS | BUKRS | MCIPMIS | BUKRS |
T001
Company Codes
|
BUKRS |
| MCIPMIS | DAUFN | SYST | MANDT |
AUFK
Order master data
|
MANDT |
| MCIPMIS | DAUFN | MCIPMIS | DAUFN |
AUFK
Order master data
|
AUFNR |
| MCIPMIS | ELIEF | SYST | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| MCIPMIS | ELIEF | MCIPMIS | ELIEF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| MCIPMIS | EQART | SYST | MANDT |
T370K
Type of technical object
|
MANDT |
| MCIPMIS | EQART | MCIPMIS | EQART |
T370K
Type of technical object
|
EQART |
| MCIPMIS | EQTYP | SYST | MANDT |
T370T
Equipment categories
|
MANDT |
| MCIPMIS | EQTYP | MCIPMIS | EQTYP |
T370T
Equipment categories
|
EQTYP |
| MCIPMIS | EQUNR | SYST | MANDT |
EQUI
Equipment master data
|
MANDT |
| MCIPMIS | EQUNR | MCIPMIS | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| MCIPMIS | FLTYP | SYST | MANDT |
T370F
Functional Location Category
|
MANDT |
| MCIPMIS | FLTYP | MCIPMIS | FLTYP |
T370F
Functional Location Category
|
FLTYP |
| MCIPMIS | GSBER | SYST | MANDT |
TGSB
Business Areas
|
MANDT |
| MCIPMIS | GSBER | MCIPMIS | GSBER |
TGSB
Business Areas
|
GSBER |
| MCIPMIS | KOKRS | MCIPMIS | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| MCIPMIS | KOKRS | SYST | MANDT |
TKA01
Controlling Areas
|
MANDT |
| MCIPMIS | KOSTL | SYST | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| MCIPMIS | KOSTL | MCIPMIS | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| MCIPMIS | KOSTL | MCIPMIS | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| MCIPMIS | KOSTL | SYST | DATUM |
CSKS
Cost Center Master Data
|
DATBI |
| MCIPMIS | LGWID | MCIPMIS | LGWID |
CRID
CIM Resource - Entities
|
OBJID |
| MCIPMIS | LGWID | SYST | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| MCIPMIS | LGWID | MCIPMIS | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| MCIPMIS | MANDT | MCIPMIS | MANDT |
T000
Clients
|
MANDT |
| MCIPMIS | MATNR | MCIPMIS | MATNR |
MARA
General Material Data
|
MATNR |
| MCIPMIS | MATNR | MCIPMIS | MANDT |
MARA
General Material Data
|
MANDT |
| MCIPMIS | OBJNR | MCIPMIS | MANDT |
ONR00
General Object Number
|
MANDT |
| MCIPMIS | OBJNR | MCIPMIS | OBJNR |
ONR00
General Object Number
|
OBJNR |
| MCIPMIS | PBEGRU | MCIPMIS | PBEGRU |
T370B
Technical object authorization group
|
BEGRU |
| MCIPMIS | PBEGRU | SYST | MANDT |
T370B
Technical object authorization group
|
MANDT |
| MCIPMIS | STORT | SYST | MANDT |
T499S
Location
|
MANDT |
| MCIPMIS | STORT | MCIPMIS | SWERK |
T499S
Location
|
WERKS |
| MCIPMIS | STORT | MCIPMIS | STORT |
T499S
Location
|
STAND |
| MCIPMIS | STWAE | MCIPMIS | MANDT |
TCURC
Currency Codes
|
MANDT |
| MCIPMIS | STWAE | MCIPMIS | STWAE |
TCURC
Currency Codes
|
WAERS |
| MCIPMIS | SUBMT | MCIPMIS | MANDT |
MARA
General Material Data
|
MANDT |
| MCIPMIS | SUBMT | MCIPMIS | SUBMT |
MARA
General Material Data
|
MATNR |
| MCIPMIS | SWERK | SYST | MANDT |
T001W
Plants/Branches
|
MANDT |
| MCIPMIS | SWERK | MCIPMIS | SWERK |
T001W
Plants/Branches
|
WERKS |
| MCIPMIS | TPLKZ | SYST | MANDT |
T370S
Functional Location Structure Indicators
|
MANDT |
| MCIPMIS | TPLKZ | MCIPMIS | TPLKZ |
T370S
Functional Location Structure Indicators
|
TPLKZ |
| MCIPMIS | TPLMA | SYST | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| MCIPMIS | TPLMA | MCIPMIS | TPLMA |
IFLOT
Functional Location (Table)
|
TPLNR |
| MCIPMIS | TPLNR | SYST | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| MCIPMIS | TPLNR | MCIPMIS | TPLNR |
IFLOT
Functional Location (Table)
|
TPLNR |
| MCIPMIS | TRPNR | SYST | MANDT |
IRLOT
Reference Functional Location (Table)
|
MANDT |
| MCIPMIS | TRPNR | MCIPMIS | TRPNR |
IRLOT
Reference Functional Location (Table)
|
TRPNR |
| MCIPMIS | WAERS | MCIPMIS | MANDT |
TCURC
Currency Codes
|
MANDT |
| MCIPMIS | WAERS | MCIPMIS | WAERS |
TCURC
Currency Codes
|
WAERS |
| MCIPMIS | ZEITP | MCIPMIS | ZEITP |
TMC5
Business Events for Statistics Updating
|
ZEITP |