C_MalfunctionReportInvlmnts

Malfunction Report User Involvements | view: CMALFREPINVL | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: EAM_OSTOBJSTS, QMEL, AFIH, AFKO, AFKO, AFVC, QMIH, JSTO, JEST, BUT000, EAM_OSTAT, EQUI, EQKT, EQUZ, IFLOS, IFLOS, IFLOT, IFLOT, IFLOTX, ILOA, AUFK, AUFK, ADCP, ADR6, ADRC, ADRP, USR21, T356, T356_T, CRTX, TJ30, CRHD, ADR2, ADR2, ITOBCUST, IFLOUSR
Column Name Description
MaintObjectInternalID FK Object Number for Status Management
StatusObject FK Object Number for Status Management
ObjectType Object Type
Column Name Description
Column Name Description
Column Name Description
MalfunctionEndDate End of Malfunction (Date)
MalfunctionEndTime End of Malfunction (Time)
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionStartTime Start of Malfunction (Time)
NotificationCreationDate Date of Notification
NotificationCreationTime Time of Notification
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
Column Name Description Domain name
PersonInvolved Personnel Number PERSNO
MaintenanceNotification Notification Number QMNUM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
MaintenanceOrderDesc Description TEXT40
NotificationText Short Text TEXT40
ReporterFullName Full Name of Person TEXT80
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
ItemCounter null
Master Data Relations Join Conditions
Overall Status
  • Client
  • ?
  • Overall Status
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == EAM_OSTAT.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.[column in domain "EAM_OVERALL_STATUS_PROFILE"] == EAM_OSTAT.OVERALL_STATUS_PROFILE
  • C_MALFUNCTIONREPORTINVLMNTS.EAMOVERALLOBJECTSTATUS == EAM_OSTAT.OVERALL_STATUS
Equipment Number
  • Client
  • Equipment Number
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == EQUI.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.EQUIPMENT == EQUI.EQUNR
Order Number
  • Client
  • Order Number
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == AUFK.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.MAINTENANCEORDER == AUFK.AUFNR
Plant for Work Center
  • Plant for Work Center
  • Client
  • C_MALFUNCTIONREPORTINVLMNTS.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == T001W.MANDT
Priority
  • ?
  • Client
  • Priority
  • C_MALFUNCTIONREPORTINVLMNTS.[column in domain "ARTPR"] == T356.ARTPR
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == T356.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.MAINTPRIORITY == T356.PRIOK
Effect on Operation
  • Client
  • Effect on Operation
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == T357A.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.MALFUNCTIONEFFECT == T357A.AUSWK
Notification Type
  • Client
  • Notification Type
  • C_MALFUNCTIONREPORTINVLMNTS.MANDT == TQ80.MANDT
  • C_MALFUNCTIONREPORTINVLMNTS.NOTIFICATIONTYPE == TQ80.QMART