Exploring Analytics

Objective

After completing this lesson, you will be able to describe analytics for SAP S/4HANA Asset Management

Steps and Maintenance History

Table with the heading Analytics – technical and controlling. There are four columns: Step, Content, Role, and Integration. There are four steps: 1 Master data, 2 Document data, 3 Embedded Analytics, and 4 Strategic Analytics. The steps are outlined in the following text.
  1. The technical object structure is used as the basis for evaluations.
  2. Create document data during the processes. These data are part of the Maintenance History.
  3. Within SAP S/4HANA use Embedded Analytics - Core Data Services (CDS) and Fiori-based analyses.
  4. Use Business Warehouse (BW) and Business Objects (BO) to consolidate multiple systems.

Maintenance History

Image with four screenshots and the headings: Usage List, Notifications, Orders, and Material.

Usage List

The usage list provides both object-related and location-based information about equipment usage. It displays the phases during which the equipment was installed at a functional location, when it was assigned directly to a usage site (for example, a cost center), where it was stored in a warehouse, and so on.

The usage list displays all of the equipment usage periods (validity periods for a definite assignment), such as functional location, cost center, and so on. The usage periods are displayed in a chronological order.

Notification and Order History

Completed notifications, orders as well as historical orders serve as a basis for analyses in maintenance processing.

Completed notifications and orders: For medium-term reporting, completed notifications, and orders can be used. A notification is moved into the notification history when it is completed. In contrast, an order is moved into the area for completed orders when it is completed. The data for completed notifications and orders can be fully analyzed. Evaluations can be performed in the corresponding list editing function, where the Completed status must be set each time.

Historical Orders

For long-term analyses, historical orders are used. Historical orders are generated and transferred to the order history when order completion is archived. Historical orders contain the most important order data in a compressed form. Evaluations can be performed in the corresponding list editing function, where the Historical status must be set each time.

You can use the material where-used list function to verify the use of materials in maintenance orders during a specific period of time.

Orders can be chosen according to different selection criteria, such as order number, order type, and equipment.

Material Where-Used List

The material where-used list function also indicates which materials were planned withdrawals (with reference to a reservation) and which were unplanned (without reference to a reservation).

A selection of single and multi level lists is provided for analyzing the data of the maintenance history.

Analytics with SAP S/4HANA

There are many analytic tools relevant to SAP S/4HANA. These tools are part of embedded analytics or strategic analytics, as follows:

Embedded Analytics

A collection of tools that are included with core SAP S/4HANA. No additional license is required, and the focus is operational analytics.

From the Asset Management perspective - along with the embedded analytics tools - you can still use the EAM-centric lists and reports based on the maintenance history (the same that were available in SAP ERP) as well as the Plant Maintenance Information System (PMIS).

Strategic Analytics

A collection of tools that are not included with core SAP S/4HANA. Additional licenses are usually required, and the focus is on deeper, more advanced BI scenarios.

All analytics, embedded or strategic, always run on a single copy of live, common SAP S/4HANA data.

Fiori Apps for Embedded Analytics

Image shows two screenshots: One of the Technical Object Breakdowns, and, below it, one of the Technical Object Damages screen.

CDS Views

A more modern way of analyzing business data which is typical for the S/4HANA embedded analytics is the use of CDS views.

One of the major characteristics of SAP S/4HANA is that transactional and analytical processing are combined and based on the same database tables. SAP S/4HANA supports this concept via SAP Core-Data-Services-(CDS-)Views for the operational reporting in realtime.

CDS views give you immediate access to live data on the SAP HANA database without using separate tables with aggregated data. CDS views are developed, maintained and enhanced in the ABAP layer of SAP S/4HANA system. The system generates SQL runtime views in SAP HANA, in order to read and transform the data within the SAP HANA database layer.

Analytical Apps Technical Object Breakdowns and Technical Object Damages

Technical Object Breakdowns and Technical Object Damages are Fiori-based analytical apps which use CDS views. They visualize breakdowns and damages of technical objects.

The screen is divided into three sections:

  • Filters
  • Diagram
  • Table

Each section provides a settings dialog to adapt the display to the desired perspective. The table section contains a drilldown functionality which allows to display the notification which is at the origin of a certain key figure.

Further CDS Views

As of SAP S/4HANA 2023 the following additional CDS views are available:

  • Maintenance Order Data (I_MaintenanceOrderDEX)
  • Maintenance Order Change Document (I_MaintOrdChangeDocumentDEX)
  • Purchase Requisition Or Reservation Generation (I_PurReqnOrResvnGeneration) and the related text view I_PurReqnOrResvnGenerationText
  • Operation Basic Start Date Constraint Type (I_OpBscStartDateConstraintType) and the related text view I_OpBscStrtDateConstraintTypeT
  • Operation Basic End Date Constraint Type (I_OpBscEndDateConstraintType) and the related text view I_OpBscEndDateConstraintTypeT
  • Maintenance Order Processing Context (I_MaintOrderProcessingContext) and the related text view I_MaintOrdProcessingContextT
  • Maintenance Order Component Special Stock Type (I_MaintOrdOpCompSpclStockType) and the related text view I_MaintOrdOpCompSpclStkTypeTxt
  • Maintenance Order Component Costing Relevancy (I_MaintOrdOpCompCostRelevancy) and the related text view I_MaintOrdOpCompCostRelevancyT
  • Maintenance Component Item Category (I_MaintComponentItemCategory) and the related text view I_MaintCompItemCategoryTxt
  • Master Warranty Object Assignment (I_MasterWrntyObjectAssgmt)

How to use App Technical Object Breakdowns

How to use App Maintenance Order Costs

Strategic Analyses

Diagram depicting strategic analytics.

Whenever the focus is on deeper, more advanced BI scenarios which consolidate data over several systems we are talking about strategic analytics. Typical for strategic analytics is the modelling of data within SAP Business Warehouse (SAP BW)and the subsequent visualization or processing in a SAP BusinessObjects Business Intelligence Tool.

SAP BusinessObjects

SAP BusinessObjects (SAP BO) is a SAP solution containing the following areas:

  • Business Intelligence

  • Analytic Applications

  • Enterprise Performance Management

  • Enterprise Information Management

  • Governance, Risk, and Compliance (GRC)

The area Business Intelligence offers in particular possibilities for formatted Reporting (f.ex. Crystal Reports), interactive visualization of business data (Dashboards) and intuitive, web-based reports.

he current portfolio of SAP BO Business Intelligence contains the following BI Clients:

  • Crystal Reports
  • Web Intelligence
  • Lumira
  • Analysis Office
  • Live Office
  • Design Studio
Reporting

Business data from different data sources can be used and transformed into professionally formatted reports.

The transparency increases by using the following BI-Clients:

  • SAP Crystal Reports
  • SAP BusinessObjects Web Intelligence
  • Desktop Intelligence (IMS)
Discovery and Analysis

The main objective of the area Discovery, which means data exploration, is the search for immediate answers to business relevant questions.

The area Analysis offers tools, to deduct trends from complex historical data and to improve forecasts.

The following BI-Clients belong to this area:

  • SAP Predictive Analysis
  • SAP Lumira
  • Explorer
  • SAP BO Analysis, Edition for Microsoft Office
  • SAP BO Analysis, Edition for OLAP

PMIS

Plant Maintenance Information System (PMIS)

The Logistic Information System (LIS) has a modular structure. It offers a number of different analysis techniques. The Plant Maintenance Information System (PMIS) is part of the LIS.

The PMIS has been structured according to the following design criteria:

  • Data is updated online to the PMIS in real time.
  • Aggregate data into informative, meaningful, characteristics and key figures.
  • The aggregation of application data takes place in the information structures (info structures).
  • Various analyses can be based on the info structures.
  • Create your own info structures and your own analyses (flexible analyses).

PMIS Standard Information Structures

The PMIS contains the following standard information structures: S061 - Location and Planning, S062 - Object Class and Manufacturer, S063 - Damage Analysis, S065 - Object Statistics, S070 - Breakdown statistics, S114 - Vehicle Consumption Analysis, S115 - Cost Evaluation

You can use each standard analysis to analyze the data. There is no further configuration required. Information structures are special statistical tables that contain basic data from different applications. This data is constantly collected and updated by the system.

Information structures are special statistical tables that contain basic data from different applications. This data is constantly collected and updated by the system.

Information structures contain the following three basic elements:

  • Characteristics:
  • Period Unit
  • Key Figures

PMIS Analyses

Standard analyses provide many functions that enable you to find specific information for detailed evaluations. The information structures provide the database for standard analyses. You can specify the range of data to be evaluated. In addition, you can also define the key figures or choose them online during the analysis itself.

SAP GUI Transactions

As an alternative to working in SAP Fiori Launchpad you can use the following transactions.

For the On Premise edition they are available via SAP GUI for Windows.

In addition, every transaction also has a SAP GUI for HTML version.

Transactions for Analytics (PMIS):

  • MCI8 - Cost Analysis 
  • MCI5 - Damage Analysis 
  • MCI7 - Breakdown Analysis  

Log in to track your progress & complete quizzes