P_MaintObjBreakdownCube

Maintenance Object Breakdown Private Cube | view: PMNTOBJBDC | Extraction: Not supported | Component: Maintenance Notifications
Tables used: SCAL_TT_DATE, QMEL, AFIH, AFKO, QMIH, JSTO, JEST, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, AUFK, PRPS, CRHD, ITOBCUST, IFLOUSR
Column Name Description
LeadingMaintNotification Leading Maintenance Notification
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
TotalRepairTimeInHours Time To Repair
TimeBetweenRepairInHours Time Between Repair
Column Name Description
EffectiveMalfunctionStartDate Effective Malfunction Start Date
EffectiveMalfunctionEndDate Effective Malfunction End Date
EffectiveMalfunctionStartTime Effective Malfunction Start Time
EffectiveMalfunctionEndTime Effective Malfunction End Time
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
NotifProcessingPhase Notification Processing Phase Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
Column Name Description Domain name
TechnicalObject Technical Object EAMS_TEC_OBJ
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction
ConstructionMonth Month of Construction
AssetRoom Room CHAR8
WorkCenter Work Center ARBPL
MaintObjectFreeDefinedAttrib Sort Field CHAR30
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
MaintenanceActivityType Maintenance Activity Type ILART
MainWorkCenter Main work center for maintenance tasks ARBPL
BreakdownYear Maintenance Object Breakdown Year NUM4
BreakdownQuarter Maintenance Object Breakdown Quarter NUM1
BreakdownMonth Maintenance Object Breakdown Month NUM2
BreakdownWeek Maintenance Object Breakdown Week NUM2
BreakdownDay Maintenance Object Breakdown Day NUM2
EffctvMalfunctionStartDateTime null
EffctvMalfunctionEndDateTime null
NumberOfReportedBreakdowns Number of machine breakdowns reported MCZAEHLER
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T370C.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.ABCINDICATOR == T370C.ABCKZ
Assembly
  • Assembly
  • Client
  • P_MAINTOBJBREAKDOWNCUBE.ASSEMBLY == MARA.MATNR
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == MARA.MANDT
Location of maintenance object
  • Client
  • Maintenance Plant
  • Location of maintenance object
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T499S.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T499S.WERKS
  • P_MAINTOBJBREAKDOWNCUBE.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • P_MAINTOBJBREAKDOWNCUBE.AUTHORIZATIONGROUP == T370B.BEGRU
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T370B.MANDT
Catalog Profile
  • Client
  • Catalog Profile
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T352B.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.CATALOGPROFILE == T352B.RBNR
Company Code
  • Company Code
  • Client
  • P_MAINTOBJBREAKDOWNCUBE.COMPANYCODE == T001.BUKRS
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T001.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == MARA.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == TKA01.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • P_MAINTOBJBREAKDOWNCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == CSKS.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • P_MAINTOBJBREAKDOWNCUBE.COSTCENTER == CSKS.KOSTL
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == EQUI.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.EQUIPMENT == EQUI.EQUNR
Order Number
  • Order Number
  • Client
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == AUFK.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T001W.WERKS
Plant for Work Center
  • Client
  • Plant for Work Center
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
Priority
  • Client
  • Priority Type
  • Priority
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T356.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T356A.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITYTYPE == T356A.ARTPR
Plant
  • Client
  • Plant
  • Plant
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • P_MAINTOBJBREAKDOWNCUBE.PLANT == T001W.WERKS
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • P_MAINTOBJBREAKDOWNCUBE.MANUFACTURERCOUNTRY == T005.LAND1
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T005.MANDT
Notification Type
  • Client
  • Notification Type
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == TQ80.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.NOTIFICATIONTYPE == TQ80.QMART
Plant
  • Client
  • Plant
  • Plant
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • P_MAINTOBJBREAKDOWNCUBE.PLANT == T001W.WERKS
Plant Section
  • Client
  • Maintenance Plant
  • Plant Section
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T357.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T357.WERKS
  • P_MAINTOBJBREAKDOWNCUBE.PLANTSECTION == T357.BEBER
Type of Technical Object
  • Client
  • Type of Technical Object
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T370K.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.TECHNICALOBJECTTYPE == T370K.EQART
Functional Location
  • Client
  • Functional Location
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == IFLOT.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.TECHOBJINSTALLATIONLOCATION == IFLOT.TPLNR
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T024I.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTOBJBREAKDOWNCUBE.MANDT == T399I.MANDT
  • P_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK