MCIPMIS

PMIS: Master data characteristics for PMIS before image | #transactional | Component: Reporting
Column Name Description
MANDT FK Client
OBJNR FK Object Number for Status Management
Column Name Description
Column Name Description
Column Name Description
ANSDT Acquisition date
SDATE Date
Column Name Description
J_3GEIFR Indicator for Own/External Equipment Show values
IEQUI Installation of equipment allowed at the functional location Show values
EINZL Single equipment installation at functional location Show values
PM_OBJTY Object Type of CIM Resources for Work Center Show values
Column Name Description Domain name
INVNR Inventory number INVNR_ANLA
HERST Manufacturer of Asset TEXT30
SERGE Manufacturer's Serial Number CHAR30
TYPBZ Manufacturer model number TYPBZ
GERNR Serial Number GERNR
EQLFN Consecutive numbering of EquipUsagePeriods on same day NUM03
BAUJJ Year of construction CJAHR
J_3GEIGNER Owner J_3GEIGVER
J_3GVERWAL Administrator J_3GEIGVER
J_3GEQART Procurement Type for External Equipment J_3GEQART
MAPAR Manufacturer part number MAPAR
EQFNR Sort Field CHAR30
MSGRP Room CHAR8
SKLSOB PMIS: Object class SKLOBJ
SERIALNR Serial Number GERNR
Master Data Relations Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • MCIPMIS.ABCKZ == T370C.ABCKZ
  • MCIPMIS.MANDT == T370C.MANDT
Asset Subnumber
  • Asset Subnumber
  • Company Code
  • Main Asset Number
  • MCIPMIS.MANDT == ANLA.MANDT
  • MCIPMIS.ANLUN == ANLA.ANLN2
  • MCIPMIS.BUKRS == ANLA.BUKRS
  • MCIPMIS.ANLNR == ANLA.ANLN1
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • MCIPMIS.BEBER == T357.BEBER
  • MCIPMIS.MANDT == T357.MANDT
  • MCIPMIS.SWERK == T357.WERKS
PMIS: Authorization group for equipment
  • MCIPMIS.MANDT == T370B.MANDT
  • MCIPMIS.BEGRU == T370B.BEGRU
Company Code
  • MCIPMIS.MANDT == T001.MANDT
  • MCIPMIS.BUKRS == T001.BUKRS
Standing order number
  • Standing order number
  • Client
  • MCIPMIS.DAUFN == AUFK.AUFNR
  • MCIPMIS.MANDT == AUFK.MANDT
Vendor number
  • MCIPMIS.MANDT == LFA1.MANDT
  • MCIPMIS.ELIEF == LFA1.LIFNR
Type of Technical Object
  • MCIPMIS.MANDT == T370K.MANDT
  • MCIPMIS.EQART == T370K.EQART
Equipment category
  • Equipment category
  • Client
  • MCIPMIS.EQTYP == T370T.EQTYP
  • MCIPMIS.MANDT == T370T.MANDT
Equipment Number
  • Equipment Number
  • Client
  • MCIPMIS.EQUNR == EQUI.EQUNR
  • MCIPMIS.MANDT == EQUI.MANDT
Functional location category
  • MCIPMIS.MANDT == T370F.MANDT
  • MCIPMIS.FLTYP == T370F.FLTYP
Business Area
  • MCIPMIS.MANDT == TGSB.MANDT
  • MCIPMIS.GSBER == TGSB.GSBER
Material Price Group
  • MCIPMIS.MANDT == T178.MANDT
  • MCIPMIS.J_3GKONDE == T178.KONDM
Controlling Area
  • MCIPMIS.MANDT == TKA01.MANDT
  • MCIPMIS.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • MCIPMIS.MANDT == CSKS.MANDT
  • MCIPMIS.[column in domain "DATBI"] == CSKS.DATBI
  • MCIPMIS.KOSTL == CSKS.KOSTL
  • MCIPMIS.KOKRS == CSKS.KOKRS
Object ID of the Work Center
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • MCIPMIS.LGWID == CRID.OBJID
  • MCIPMIS.PM_OBJTY == CRID.OBJTY
  • MCIPMIS.MANDT == CRID.MANDT
Client MCIPMIS.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MCIPMIS.MATNR == MARA.MATNR
  • MCIPMIS.MANDT == MARA.MANDT
Technical Object Authorization Group
  • MCIPMIS.MANDT == T370B.MANDT
  • MCIPMIS.PBEGRU == T370B.BEGRU
Asset location
  • Asset location
  • Client
  • Maintenance Plant
  • MCIPMIS.STORT == T499S.STAND
  • MCIPMIS.MANDT == T499S.MANDT
  • MCIPMIS.SWERK == T499S.WERKS
Statistics Currency
  • MCIPMIS.MANDT == TCURC.MANDT
  • MCIPMIS.STWAE == TCURC.WAERS
Material number for equipment
  • Material number for equipment
  • Client
  • MCIPMIS.SUBMT == MARA.MATNR
  • MCIPMIS.MANDT == MARA.MANDT
Maintenance Plant
  • MCIPMIS.MANDT == T001W.MANDT
  • MCIPMIS.SWERK == T001W.WERKS
Functional Location Structure Indicator
  • MCIPMIS.MANDT == T370S.MANDT
  • MCIPMIS.TPLKZ == T370S.TPLKZ
Superior functional location
  • MCIPMIS.MANDT == IFLOT.MANDT
  • MCIPMIS.TPLMA == IFLOT.TPLNR
Functional Location
  • MCIPMIS.MANDT == IFLOT.MANDT
  • MCIPMIS.TPLNR == IFLOT.TPLNR
Reference functional location
  • Reference functional location
  • Client
  • MCIPMIS.TRPNR == IRLOT.TRPNR
  • MCIPMIS.MANDT == IRLOT.MANDT
Currency Key
  • MCIPMIS.MANDT == TCURC.MANDT
  • MCIPMIS.WAERS == TCURC.WAERS
Event for which updating should take place MCIPMIS.ZEITP == TMC5.ZEITP