Integrating with SAP S/4HANA

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Access data from S/4HANA

SAP S/4HANA Integration

SAP S/4HANA is a complete enterprise resource planning (ERP) system with built-in intelligent technologies, including AI, machine learning, and advanced analytics. It helps companies adopt new business models, manage business change at speed, orchestrate internal and external resources, and use the predictive power of AI. With SAP Analytics Cloud's ability to connect to SAP S/4HANA, S/4HANA customers can leverage their on-premise system with SAP Analytics Cloud's cloud-based modeling and analytics capabilities.

The Integration with an S/4HANA system can be done in two ways:

  • As a live data connection: no data will be stored on the cloud.

  • As an import data connection: data will be stored in the cloud and updated periodically. NOTE: When using SAC as the interface for planning activities, data must be imported from S/4HANA.

SAP S/4HANA Live Data Connection

You can create live data connections to SAP S/4HANA systems using the Direct, Tunnel, and Cloud connection types. You can build stories based on released CDS views or leverage queries created by you.

In the figure SAP S/4HANA Live Data Flow we illustrate the data flow from S/4HANA to SAC. The View Browser Fiori app is used to access CDS views of all kinds.

Note

Use the Access Live SAP S/4HANA Data with a Model procedure to access the View Browser app.

Data Analyzer

Data analyzer is a predefined ready-to-run service for SAP Business Warehouse (SAP BW) queries, SAP HANA Live views, and SAP Analytics Cloud models for ad-hoc analysis. It uses SAP BW live connections, SAP HANA views and models created in SAP Analytics Cloud. All SAP BW queries, SAP HANA Live views and models can be accessed directly in the Select Data Source dialog and no additional model is created.

The steps to access the data analyzer are given below.

Data Analyzer - User Interface

Data analyzer contains a table, a filter area, and a builder panel with navigation capabilities to add and remove dimensions and measures from the table. In addition, you find a menu bar with a Refresh option and an Edit Prompts dialog (in case your datasource is designed for setting prompts).

Table formulas are available but calculated measures are not.

After you have drilled down to the data details according to your needs and analyzed your data, you might want to save this insight. For this, choose Save in the upper left corner of data analyzer. In the Save Insight dialog, select the file location (public or private) for your insight and enter a name and description for it.

Note
You can also test a CDS view from S/4HANA. In the data analyzer, connect to BW → S/4 → Log in with wss4 / Welcome1 → search for journal → If prompted, use company code 1010. In Fiori, this is the Journal Entry Analyzer. Launch Fiori from the SACP30 folder in the N drive with user s4h00-00 / Welcome1. It can be accessed with the Query Browser. The technical name of the view is C_GLLineItemsQ0001.

Save progress to your learning plan by logging in or creating an account