P_ReportedBreakdown

Reported Breakdown | view: PREPBD | Extraction: Not supported | Component: Maintenance Notifications
Tables used: QMEL, QMIH, EQUI, EQUZ, IFLOT, ILOA
Column Name Description
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
Column Name Description
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionStartTime Start of Malfunction (Time)
MalfunctionEndDate End of Malfunction (Date)
MalfunctionEndTime End of Malfunction (Time)
OperationStartDate Start-up Date of the Technical Object
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
NotifProcessingPhase Notification Processing Phase Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
TechnicalObject Technical Object EAMS_TEC_OBJ
MaintObjectDowntimeDuration Breakdown Duration FLTP
MalfunctionStartDateTime null
MalfunctionEndDateTime null
Master Data Relations Join Conditions
Equipment Number
  • Client
  • Equipment Number
  • P_REPORTEDBREAKDOWN.MANDT == EQUI.MANDT
  • P_REPORTEDBREAKDOWN.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • P_REPORTEDBREAKDOWN.MANDT == IFLOT.MANDT
  • P_REPORTEDBREAKDOWN.FUNCTIONALLOCATION == IFLOT.TPLNR
Order Number
  • Client
  • Order Number
  • P_REPORTEDBREAKDOWN.MANDT == AUFK.MANDT
  • P_REPORTEDBREAKDOWN.MAINTENANCEORDER == AUFK.AUFNR
Plant for Work Center
  • Plant for Work Center
  • Client
  • P_REPORTEDBREAKDOWN.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • P_REPORTEDBREAKDOWN.MANDT == T001W.MANDT
Unit for Breakdown Duration
  • Unit for Breakdown Duration
  • Client
  • P_REPORTEDBREAKDOWN.MAINTOBJDOWNTIMEDURATIONUNIT == T006.MSEHI
  • P_REPORTEDBREAKDOWN.MANDT == T006.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • P_REPORTEDBREAKDOWN.MAINTPRIORITYTYPE == T356.ARTPR
  • P_REPORTEDBREAKDOWN.MANDT == T356.MANDT
  • P_REPORTEDBREAKDOWN.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • P_REPORTEDBREAKDOWN.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_REPORTEDBREAKDOWN.MANDT == T356A.MANDT
Notification Type
  • Client
  • Notification Type
  • P_REPORTEDBREAKDOWN.MANDT == TQ80.MANDT
  • P_REPORTEDBREAKDOWN.NOTIFICATIONTYPE == TQ80.QMART
Foreign key work center
  • Client
  • Object ID of the Work Center
  • ?
  • P_REPORTEDBREAKDOWN.MANDT == CRID.MANDT
  • P_REPORTEDBREAKDOWN.WORKCENTERINTERNALID == CRID.OBJID
  • P_REPORTEDBREAKDOWN.[column in domain "CR_OBJTY"] == CRID.OBJTY