C_MaintObjBreakdownQuery

Maintenance Object Breakdown Query | view: CMNTOBJBDQ | 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
📏 Unit of Measure for Display (UnitOfMeasure):
TimeBetweenRepairInHours Time Between Repair
TotalRepairTimeInHours Time To Repair
MeanRepairTimeInHours PMIS: Mean Time To Repair
MeanTimeBetweenRepairInHours PMIS: Mean 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
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionStartTime Start of Malfunction (Time)
MalfunctionEndDate End of Malfunction (Date)
MalfunctionEndTime End of Malfunction (Time)
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
Column Name Description Domain name
TechnicalObjectLabel Technical Object Identifier
TechnicalObject Technical Object EAMS_TEC_OBJ
AssetManufacturerName Manufacturer of Asset TEXT30
AssetRoom Room CHAR8
ConstructionMonth Month of Construction
ConstructionYear Year of construction
MainWorkCenter Main work center for maintenance tasks ARBPL
MaintObjectFreeDefinedAttrib Sort Field CHAR30
MaintenanceActivityType Maintenance Activity Type ILART
ManufacturerPartTypeName Manufacturer model number TYPBZ
NotifProcessingPhase Notification Processing Phase
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WorkCenter Work Center 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
NumberOfReportedBreakdowns Number of machine breakdowns reported MCZAEHLER
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_MAINTOBJBREAKDOWNQUERY.ABCINDICATOR == T370C.ABCKZ
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T370C.MANDT
Assembly
  • Client
  • Assembly
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == MARA.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.ASSEMBLY == MARA.MATNR
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T499S.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.ASSETLOCATION == T499S.STAND
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANT == T499S.WERKS
Catalog Profile
  • Client
  • Catalog Profile
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T352B.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.CATALOGPROFILE == T352B.RBNR
Company Code
  • Client
  • Company Code
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T001.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.COMPANYCODE == T001.BUKRS
Construction type material of the object
  • Client
  • Construction type material of the object
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == MARA.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.CONSTRUCTIONMATERIAL == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == TKA01.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Controlling Area
  • ?
  • Cost Center
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == CSKS.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTOBJBREAKDOWNQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTOBJBREAKDOWNQUERY.COSTCENTER == CSKS.KOSTL
Equipment Number
  • Client
  • Equipment Number
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == EQUI.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.EQUIPMENT == EQUI.EQUNR
Order Number
  • Order Number
  • Client
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == AUFK.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T001W.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANT == T001W.WERKS
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T001W.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
Priority
  • Priority Type
  • Client
  • Priority
  • C_MAINTOBJBREAKDOWNQUERY.MAINTPRIORITYTYPE == T356.ARTPR
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T356.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • C_MAINTOBJBREAKDOWNQUERY.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T356A.MANDT
Plant
  • Client
  • Plant
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T001W.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINWORKCENTERPLANT == T001W.WERKS
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T005.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MANUFACTURERCOUNTRY == T005.LAND1
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • C_MAINTOBJBREAKDOWNQUERY.PLANTSECTION == T357.BEBER
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T357.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANT == T357.WERKS
Type of Technical Object
  • Client
  • Type of Technical Object
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T370K.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.TECHNICALOBJECTTYPE == T370K.EQART
Functional Location
  • Client
  • Functional Location
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == IFLOT.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.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
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T024I.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • C_MAINTOBJBREAKDOWNQUERY.MANDT == T399I.MANDT
  • C_MAINTOBJBREAKDOWNQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK