I_MaintObjBreakdownCube

Maintenance Object Breakdown Cube | view: IMNTOBJBDC | TRAN | 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

🔑 Keys (2)
💰 Amounts
∑ Quantities (2)
📅 Dates (8)
☰ Categorical (3)
Other (18)
🔗 Relations (24)

Column Name	Description
LeadingMaintNotification	Leading Maintenance Notification
MaintenanceNotification	Notification Number

Column Name	Description

Column Name	Description
📏 Unit of Measure for Display (UnitOfMeasure):
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
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
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
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
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	`I_MAINTOBJBREAKDOWNCUBE.ABCINDICATOR == T370C.ABCKZ` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T370C.MANDT`
Assembly Assembly Client	`I_MAINTOBJBREAKDOWNCUBE.ASSEMBLY == MARA.MATNR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == MARA.MANDT`
Location of maintenance object Location of maintenance object Maintenance Plant Client	`I_MAINTOBJBREAKDOWNCUBE.ASSETLOCATION == T499S.STAND` `I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T499S.WERKS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T499S.MANDT`
Technical Object Authorization Group Technical Object Authorization Group Client	`I_MAINTOBJBREAKDOWNCUBE.AUTHORIZATIONGROUP == T370B.BEGRU` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T370B.MANDT`
Catalog Profile Catalog Profile Client	`I_MAINTOBJBREAKDOWNCUBE.CATALOGPROFILE == T352B.RBNR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T352B.MANDT`
Company Code Company Code Client	`I_MAINTOBJBREAKDOWNCUBE.COMPANYCODE == T001.BUKRS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T001.MANDT`
Construction type material of the object Client Construction type material of the object	`I_MAINTOBJBREAKDOWNCUBE.MANDT == MARA.MANDT` `I_MAINTOBJBREAKDOWNCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR`
Controlling Area Controlling Area Client	`I_MAINTOBJBREAKDOWNCUBE.CONTROLLINGAREA == TKA01.KOKRS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == TKA01.MANDT`
Cost Center ? Cost Center Controlling Area Client	`I_MAINTOBJBREAKDOWNCUBE.[column in domain "DATBI"] == CSKS.DATBI` `I_MAINTOBJBREAKDOWNCUBE.COSTCENTER == CSKS.KOSTL` `I_MAINTOBJBREAKDOWNCUBE.CONTROLLINGAREA == CSKS.KOKRS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == CSKS.MANDT`
Equipment Number Equipment Number Client	`I_MAINTOBJBREAKDOWNCUBE.EQUIPMENT == EQUI.EQUNR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == EQUI.MANDT`
Order Number Order Number Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEORDER == AUFK.AUFNR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == AUFK.MANDT`
Maintenance Plant Maintenance Plant Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T001W.WERKS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT`
Plant for Work Center Plant for Work Center Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT`
Priority Priority Type Priority Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITYTYPE == T356.ARTPR` `I_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITY == T356.PRIOK` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T356.MANDT`
Priority Type Priority Type Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTPRIORITYTYPE == T356A.ARTPR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T356A.MANDT`
Plant Client Plant Plant	`I_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT` `I_MAINTOBJBREAKDOWNCUBE.MAINWORKCENTERPLANT == T001W.WERKS` `I_MAINTOBJBREAKDOWNCUBE.PLANT == T001W.WERKS`
Country/Region of Manufacture Country/Region of Manufacture Client	`I_MAINTOBJBREAKDOWNCUBE.MANUFACTURERCOUNTRY == T005.LAND1` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T005.MANDT`
Notification Type Client Notification Type	`I_MAINTOBJBREAKDOWNCUBE.MANDT == TQ80.MANDT` `I_MAINTOBJBREAKDOWNCUBE.NOTIFICATIONTYPE == TQ80.QMART`
Plant Client Plant Plant	`I_MAINTOBJBREAKDOWNCUBE.MANDT == T001W.MANDT` `I_MAINTOBJBREAKDOWNCUBE.MAINWORKCENTERPLANT == T001W.WERKS` `I_MAINTOBJBREAKDOWNCUBE.PLANT == T001W.WERKS`
Plant Section Maintenance Plant Plant Section Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANT == T357.WERKS` `I_MAINTOBJBREAKDOWNCUBE.PLANTSECTION == T357.BEBER` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T357.MANDT`
Type of Technical Object Type of Technical Object Client	`I_MAINTOBJBREAKDOWNCUBE.TECHNICALOBJECTTYPE == T370K.EQART` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T370K.MANDT`
Functional Location Functional Location Client	`I_MAINTOBJBREAKDOWNCUBE.TECHOBJINSTALLATIONLOCATION == IFLOT.TPLNR` `I_MAINTOBJBREAKDOWNCUBE.MANDT == IFLOT.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP` `I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`I_MAINTOBJBREAKDOWNCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `I_MAINTOBJBREAKDOWNCUBE.MANDT == T399I.MANDT`