Analyzing Maintenance Data

A maintenance planner, can analyze the cost details of maintenance orders using the Change/Display Maintenance Order Web-Dynpro app.

Cost element hierarchies are used to determine a Spend Category for the cost elements. Therefore, you must enter the relevant cost element hierarchy, the company code and the ledger in the Default Values of your Settings on the Fiori Launchpad.

With SAP S/4HANA Finance, all actual costs are persisted in a single database table ACDOCA so that the concept of Universal Journal Entry Line Items have been introduced. A similar concept was introduced for planned costs that are persisted in another database table ACDOCP.

• If you edit or display maintenance orders on the SAP Web UI for Plant Maintenance, a Detailed Cost Analysis view has been introduced to display all cost related line items individually. The displayed information can be used for reporting purposes because each line item is shown separately.
• The same costing data is consumed by another application, i.e. Maintenance Order Costs, but the shown data is aggregated so that the maintenance planner is enabled to analyze the costing related data more efferently.

The following maintenance costs can be compared:

• Estimated Cost: Is determined by the planner based on his/her experience.
• Baseline Cost: Once the order has been approved, the baseline cost is determined and remains static.
• Planned Cost: Is derived from the planned consumption of components or services.
• Actual Cost: Is derived from the actual consumption of components or services.

The following application logic is applied:

• Estimated Cost: you have to enter the estimated cost before the maintenance order is released, i.e. no changes afterwards.
• Baseline Cost: represents a snapshot and remains static.
• Planned Costs: changes to a maintenance order impacting the planned cost results in new data entries persisted into the ACDOCP database table. The previous persisted records will be deleted.
• Actual Costs: In general, entries in the ACDOCA table are persisted once and will not be updated at all. In the case that multiple time confirmation would be posted for the same operation, the same number of records would be persisted in this table.

This app supports you in monitoring and evaluating actual costs resulting from current maintenance orders. It enables you, for example, to analyze the actual costs for materials and labor in maintenance or to compare the total corrective and preventive actual maintenance costs during a selected time period. In addition, you can easily identify the maintenance activities leading to the highest costs or the parts of the asset that were particularly costly on inspections. Altogether, this analytical list page offers you multiple possibilities to evaluate actual maintenance costs stored in the Universal Journal Entry.

Filters allow you to analyze critical costs in a specific fiscal year from different perspectives, such as the order type, the construction type, the location, the planner group or the manufacturer. A condensed view enables you to identify and compare relevant areas within data sets using data visualization and business intelligence. On the other hand, you can also navigate directly to significant single instances. All this can be done seamlessly within one page that combines transactional and analytical data using chart and table visualization.

This app is available for the maintenance planner user role.

• In the header area that can be collapsed or expanded, filter the result set, which feeds the main content area.

• Select the filters to be displayed and combine multiple filters in different ways.

• Add filter values by using the value help.

• Gain a condensed overview of the actual costs in colored charts in the visual filter bar and thereby spot relevant data more quickly.

• Decide whether non-time-related data is to be displayed in an interactive doughnut chart or in a bar chart.

• Display time series data in a line chart with up to six data points.

• In the content area, switch between the chart-only view, the table-only view and the hybrid view that combines both, chart and table view.

• In the chart view, analyze aggregated actual cost data from different perspectives and use the drilldown functionality.

• In the chart view, easily change chart types, customize the chart settings and use the drilldown option to change the chart grouping dimension.

• In the table view, access the transactional content and act on maintenance orders by navigating directly to the individual business objects.

• In the table view, decide which dimensions are to be displayed in the table and choose dimensions to group actual cost data accordingly.

• In the hybrid view, interact with both the chart and the table. Selecting a dimension within a chart area automatically filters all relevant information in the table area.

In addition, the app supports the following technical features and options: If the long material number has been activated in your back-end system, it is automatically displayed in the Material field in this SAP Fiori app. This app also runs in standalone mode.

This app uses the C_MaintOrderActualCostQ CDS view.

With this app, you can monitor and evaluate estimated costs, baseline costs, planned costs and actual costs resulting from current maintenance orders. It enables you, for example, to compare planned costs or baseline costs with actual costs caused by maintenance orders of a specific order type during a selected time period.

The Maintenance Order Costs app is provided via Business Catalog SAP_EAM_BC_MP_ORD_DSP_PC. This business catalog belongs to the Maintenance Planner role and is available for the new scope items (4HH, 4HI. 4VT and 4WM).

Filters allow you to analyze estimated costs, baseline costs, planned costs and actual costs in a specific time frame from different perspectives such as the order type, the responsible cost center, the main work center or the maintenance activity type. A condensed view enables you to identify and compare relevant areas within data sets using data visualization and business intelligence. On the other hand, you can also navigate directly to significant single maintenance orders. All this can be done seamlessly within one page that combines transactional and analytical data using chart and table visualization.

In this app, cost element hierarchies are used to determine a Spend Category for the cost elements. Costs associated to cost elements that are not inserted in the respective cost element hierarchy are not considered in the Analyze Maintenance Order Costs app. Therefore, you must enter the relevant cost element hierarchy, the company code and the ledger in the Default Values of your Settings on the Fiori Launchpad.

A relative date function is defined as a mandatory filter in this application. SAP provides pre-defined date functions that are displayed in the input help of the Relative Date Function filter field.

As an analytical list page, this application enables maintenance planners to monitor and evaluate maintenance related costs.

The following maintenance costs can be compared:

• Estimated Cost: Is determined by the planner based on his/her experience.
• Baseline Cost: Once the order has been approved, the baseline cost is determined and remains static.
• Planned Cost: Is derived from the planned consumption of components or services.
• Actual Cost: Is derived from the actual consumption of components or services.

In contrast to the detailed cost view embedded in the Web-Dynpro Application Change/Display Maintenance Order, this application aggregates the individual line items to present an overview of the transactional data. This application provides you information to the following questions:

• Was the maintenance order well planned so that additional resources have not been entered after the order was approved?
• Does the actual cost match the planned cost?
• This application also offers a seamless navigation to a detailed view of the selected maintenance order.

Maintenance Orders assigned to a project can be displayed via the Project Cost Report including the corresponding costs.

It is important to track and identify technical objects that needs unplanned maintenance quite often. Such analysis identifies bad actors that creates disruption in production / operation causing high maintenance cost as well as huge loss of revenue.

Value Proposition

Increased reliability due to:

• Identify equipment that fails often or take huge time to repair.

• Identify location where equipment fails quite often.

• Compare reliability of the equipment from different manufacturer.

• Identify repair frequencies for a type or make of an equipment.

Capabilities

• Analyze Breakdown and its impact on Reliability.

• Evaluate effective time to repair and time between repair.

• Evaluate Mean and Total time between repair as well time to repair.

• Real time evaluation of statistical KPIs without storing aggregates.

• App also identify where the equipment was installed if the breakdown is identified after the equipment was dismantled.

• 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.

• View effective time between repair and effective time to repair, as well as mean time between repair and mean time to repair for every breakdown or repair activity.

• Filter breakdowns based on various criteria, such as object type or planning plant.

• View leading notifications and perform any drilldown as needed.

• Identify the possible functional location where an equipment has failed.

• Drill down to various dimensions, such as maintenance notification, maintenance order, or technical object to get detailed information about the repair work performed.

• Filter notifications and technical objects that are reviewed to evaluate their reliability. With these filters, you can restrict a technical object using special variants with mandatory filter Maintenance Plant and other optional attributes such as main work center, planning group, equipment type, catalog profile, and so on.

This app uses the c_maintobjbreakdownquery CDS view.

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.

This app uses the c_maintobjbreakdownquery CDS view.