C_Malfunctionreport

Repair Malfunction Job List | view: CMALFUNCREPORT | 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, TJ30, CRHD, ADR2, ADR2, ITOBCUST, IFLOUSR
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)
NotificationCreationDate Date of Notification
NotificationCreationTime Time of Notification
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
MaintNotifSourceApplication Source Application Show values
Column Name Description Domain name
NotificationText Short Text TEXT40
MaintenanceOrderDesc Description TEXT40
WorkCenter Work Center ARBPL
MaintPriorityColorCode null
MaintPriorityDesc Priority Text TEXT20
TechnicalObject Technical Object EAMS_TEC_OBJ
TechObjIsEquipOrFuncnlLocDesc Description of Technical Object Type /PLMB/GOS_OTYPE_DESC
FunctionalLocationLabelName Functional Location Label ILOM_STRNO
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
TechnicalObjectDescription Technical Object Description TEXT40
FunctionalLocationName Description of functional location TEXT40
EquipmentName Description of technical object TEXT40
PersonResponsible Personnel Number
ReporterFullName Full Name of Person
CreatedByUser Name of Person Responsible for Creating the Object USNAM
NotificationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
MalfunctionStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
MalfunctionEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PersonInvolved Person Involved in Maintenance Job PERNR
Master Data Relations Join Conditions
Overall Status
  • Client
  • Profile for Overall Status
  • Overall Status
  • C_MALFUNCTIONREPORT.MANDT == EAM_OSTAT.MANDT
  • C_MALFUNCTIONREPORT.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTAT.OVERALL_STATUS_PROFILE
  • C_MALFUNCTIONREPORT.EAMOVERALLOBJECTSTATUS == EAM_OSTAT.OVERALL_STATUS
Profile for Overall Status
  • Client
  • Profile for Overall Status
  • C_MALFUNCTIONREPORT.MANDT == EAM_OSTPROF.MANDT
  • C_MALFUNCTIONREPORT.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTPROF.OVERALL_STATUS_PROFILE
Equipment Number
  • Client
  • Equipment Number
  • C_MALFUNCTIONREPORT.MANDT == EQUI.MANDT
  • C_MALFUNCTIONREPORT.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • C_MALFUNCTIONREPORT.MANDT == IFLOT.MANDT
  • C_MALFUNCTIONREPORT.FUNCTIONALLOCATION == IFLOT.TPLNR
Order Number
  • Order Number
  • Client
  • C_MALFUNCTIONREPORT.MAINTENANCEORDER == AUFK.AUFNR
  • C_MALFUNCTIONREPORT.MANDT == AUFK.MANDT
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_MALFUNCTIONREPORT.MANDT == T001W.MANDT
  • C_MALFUNCTIONREPORT.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
Priority
  • Priority Type
  • Client
  • Priority
  • C_MALFUNCTIONREPORT.MAINTPRIORITYTYPE == T356.ARTPR
  • C_MALFUNCTIONREPORT.MANDT == T356.MANDT
  • C_MALFUNCTIONREPORT.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • C_MALFUNCTIONREPORT.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_MALFUNCTIONREPORT.MANDT == T356A.MANDT
Effect on Operation
  • Effect on Operation
  • Client
  • C_MALFUNCTIONREPORT.MALFUNCTIONEFFECT == T357A.AUSWK
  • C_MALFUNCTIONREPORT.MANDT == T357A.MANDT
Time Zone for Notification
  • Client
  • Time Zone for Notification
  • C_MALFUNCTIONREPORT.MANDT == TTZZ.CLIENT
  • C_MALFUNCTIONREPORT.NOTIFICATIONTIMEZONE == TTZZ.TZONE
Notification Type
  • Client
  • Notification Type
  • C_MALFUNCTIONREPORT.MANDT == TQ80.MANDT
  • C_MALFUNCTIONREPORT.NOTIFICATIONTYPE == TQ80.QMART
Foreign key work center
  • Client
  • Work Center
  • Object ID of the Work Center
  • ?
  • C_MALFUNCTIONREPORT.MANDT == CRID.MANDT
  • C_MALFUNCTIONREPORT.WORKCENTER == CRID.OBJID
  • C_MALFUNCTIONREPORT.WORKCENTERINTERNALID == CRID.OBJID
  • C_MALFUNCTIONREPORT.[column in domain "CR_OBJTY"] == CRID.OBJTY