C_MaintObjBreakdownQuery

DDL: C_MAINTOBJBREAKDOWNQUERY SQL: CMNTOBJBDQ Type: view CONSUMPTION
61 Fields 1 Data Sources 1 Fiori Apps

Maintenance Object Breakdown Query

C_MaintObjBreakdownQuery is a Consumption CDS View that provides data about "Maintenance Object Breakdown Query" in SAP S/4HANA. It reads from 1 data source (I_MaintObjBreakdownCube) and exposes 61 fields with key fields LeadingMaintNotification, MaintenanceNotification. It is used in 1 Fiori application: Analytical List Page for Technical Object Breakdown Analysis.

Data Sources (1)

SourceAliasJoin Type
I_MaintObjBreakdownCube I_MaintObjBreakdownCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMNTOBJBDQ view
EndUserText.label Maintenance Object Breakdown Query view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
OData.publish true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey MaintenanceNotification view

Fiori Apps (1)

App IDApp NameTypeDescription
F2812 Analytical List Page for Technical Object Breakdown Analysis Analytical As a maintenance planner or maintenance technician you can use this app to analyze how often and how long a technical object remains in malfunction state and may not be available for operational use. You can also get information about similar objects type to identify common issues that may be reducing availability of plant to operate at required capacity.

Analytical List Page for Technical Object Breakdown Analysis

Business Role: Maintenance Planner

With this app you can analyze the causes of a particular breakdown more closely and calculate the distribution of duration of the various breakdowns or repairs. You can also find out the cause behind a short or long breakdown period, or the period between two consecutive breakdowns.

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY LeadingMaintNotification LeadingMaintNotification
KEY MaintenanceNotification MaintenanceNotification Notification
MaintenanceOrder MaintenanceOrder Order
TechnicalObjectLabel TechnicalObjectLabel Technical Object Label
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjInstallationLocation TechObjInstallationLocation Installation Location
TechnicalObject TechnicalObject Technical Object
Equipment Equipment Equipment check
TechnicalObjectType TechnicalObjectType Text object
CatalogProfile CatalogProfile Catalog Profile
ABCIndicator ABCIndicator ABC Indicator
Assembly Assembly Pegged Reqmt
AssetLocation AssetLocation Location
AssetManufacturerName AssetManufacturerName Manufacturer
AssetRoom AssetRoom Room
CompanyCode CompanyCode Receiver Company Code
ConstructionMaterial ConstructionMaterial ConstType
ConstructionMonth ConstructionMonth
ConstructionYear ConstructionYear
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
MaintObjectFreeDefinedAttrib MaintObjectFreeDefinedAttrib Sort Field
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintenanceActivityType MaintenanceActivityType MaintActivType
MaintenanceObjectIsDown MaintenanceObjectIsDown Breakdown
MaintenancePlannerGroup MaintenancePlannerGroup Maintenance Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant Plant for work Center
ManufacturerCountry ManufacturerCountry Country/Region of Manufacturing
ManufacturerPartTypeName ManufacturerPartTypeName Model number
NotifProcessingPhase NotifProcessingPhase Notification Phase
PlantSection PlantSection Plant Section
WBSElement WBSElement WBS Internal ID
WorkCenter WorkCenter Work Center
BreakdownYear BreakdownYear
BreakdownQuarter BreakdownQuarter
BreakdownMonth BreakdownMonth
BreakdownWeek BreakdownWeek
BreakdownDay BreakdownDay
EffectiveMalfunctionStartDate EffectiveMalfunctionStartDate
EffectiveMalfunctionEndDate EffectiveMalfunctionEndDate
EffectiveMalfunctionStartTime EffectiveMalfunctionStartTime Effective Malfunction Start Time
EffectiveMalfunctionEndTime EffectiveMalfunctionEndTime Effective Malfunction End Time
UnitOfMeasure UnitOfMeasure Unit Of Measure
NumberOfReportedBreakdowns NumberOfReportedBreakdowns
TimeBetweenRepairInHours TimeBetweenRepairInHours
TotalRepairTimeInHours TotalRepairTimeInHours
MeanRepairTimeInHours
MeanTimeBetweenRepairInHours Mean Time Between Repair
MalfunctionStartDate MalfunctionStartDate Malfunct. Start
MalfunctionStartTime MalfunctionStartTime Mal. Start (T.)
MalfunctionEndDate MalfunctionEndDate Malfunct. End
MalfunctionEndTime MalfunctionEndTime Malfunction End
EffctvMalfunctionStartDateTime EffctvMalfunctionStartDateTime Effective Malfunction Start
EffctvMalfunctionEndDateTime EffctvMalfunctionEndDateTime Effective Malfunction End
MalfunctionStartDateTime MalfunctionStartDateTime Malfunction Start
MalfunctionEndDateTime MalfunctionEndDateTime Malfunction End

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MaintObjBreakdownQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMNTOBJBDQ

CREATE VIEW C_MaintObjBreakdownQuery AS
SELECT
  LeadingMaintNotification,
  MaintenanceNotification,
  MaintenanceOrder,
  TechnicalObjectLabel,
  TechObjIsEquipOrFuncnlLoc,
  TechObjInstallationLocation,
  TechnicalObject,
  Equipment,
  TechnicalObjectType,
  CatalogProfile,
  ABCIndicator,
  Assembly,
  AssetLocation,
  AssetManufacturerName,
  AssetRoom,
  CompanyCode,
  ConstructionMaterial,
  ConstructionMonth,
  ConstructionYear,
  ControllingArea,
  CostCenter,
  MainWorkCenter,
  MainWorkCenterPlant,
  MaintObjectFreeDefinedAttrib,
  MaintPriority,
  MaintPriorityType,
  MaintenanceActivityType,
  MaintenanceObjectIsDown,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  MaintenanceWorkCenterPlant,
  ManufacturerCountry,
  ManufacturerPartTypeName,
  NotifProcessingPhase,
  PlantSection,
  WBSElement,
  WorkCenter,
  BreakdownYear,
  BreakdownQuarter,
  BreakdownMonth,
  BreakdownWeek,
  BreakdownDay,
  EffectiveMalfunctionStartDate,
  EffectiveMalfunctionEndDate,
  EffectiveMalfunctionStartTime,
  EffectiveMalfunctionEndTime,
  UnitOfMeasure,
  NumberOfReportedBreakdowns,
  TimeBetweenRepairInHours,
  TotalRepairTimeInHours,
  cast(0 as sxmttr ) AS MeanRepairTimeInHours,
  cast(0 as sxmtbr ) AS MeanTimeBetweenRepairInHours,
  MalfunctionStartDate,
  MalfunctionStartTime,
  MalfunctionEndDate,
  MalfunctionEndTime,
  EffctvMalfunctionStartDateTime,
  EffctvMalfunctionEndDateTime,
  MalfunctionStartDateTime,
  MalfunctionEndDateTime
FROM I_MaintObjBreakdownCube
;

Learn More