DAT262 - Integrating SAP S/4HANA into SAP Data Intelligence: Deep Dive and Hands On

Description

This repository contains the material for the SAP TechEd 2020 session called
DAT262 - Integrating SAP S/4HANA into SAP Data Intelligence: Deep Dive and Hands On.

Overview

SAP Data Intelligence is SAP's leading product for data integration, data management, intelligent processing and orchestration across different (hybrid) data environments. One important integration aspect is the replication, consumption, and exchange of data and functionality with SAP's core Intelligent Enterprise and Business Suite systems. The ABAP integration capabilities in SAP Data Intelligence open seamless, "any-premise" interoperability with almost all the features available in these environments.

This hands-on session will focus on connectivity and system interoperability to SAP S/4HANA systems and provides an insight on how to use the corresponding out-of-the-box operators in SAP Data Intelligence to smoothly integrate with the above SAP Business applications and beyond.

Requirements

The requirements to follow the exercises in this repository are:

• Basic knowhow about the usage and scope of S/4HANA
• General understanding of Enterprise Data Management and ETL (Extraction, Transformation, Load)
• Basic programming skills in ABAP are of advantage

Deep Dive Demos and Hands-On Exercises

The main use cases behind this workshop are

• The extraction the Business Partner master data in S/4HANA's demo application Enterprise Procurement Model (EPM) and making the records available for the corporate Data Analysts in an S3 object store.
• Also persist the transactional data in S3, i.e for EPM Sales Order objects which are built from joins over multiple EPM tables.
• In both cases, any single change of these data sources in the S/4HANA system has to be instantly and automatically replicated to the related files in S3.
• Additionally, the Sales Order data have to be enriched with Customer master data, for the initial load and then on every change committed to the EPM Sales Order data in S/4HANA.
• In order to create test changes on the EPM Sales Order data without having access to the SAP GUI in the S/4HANA system, (a variant of) the EPM Data Generator reports needs to be executed as an ABAP Function Modul call from a Data Intelligence Pipeline.
  

The Deep Dive live demos and the hands-on Exercise contents reflect the above scenarios and provide a consecutive approach for their realization. But other than during the on-site TechEd events in the past years, it was not feasible to provide the Eclipse based ABAP Development Tools (ADT) and the SAP GUI to our participants in the this year's virtual version of the TechEd.

Since it is a goal of this workshop to show and get the hands on the complete end-to-end implementation processes of ABAP integration with SAP Data Intelligence, all parts of this session that require these (local) applications will be presented as live Deep Dive demos, conducted in ADT and in SAP S/4HANA by the trainer, the Exercises - in opposite - are then performed by the participants in SAP Data Intelligence and will leverage those artifacts in S/4HANA that got created during the Deep Dive demos.

• Overview and Getting Started

  • Deep Dive demos vs. Exercises
  • Short introduction to the Enterprise Procurement Model (EPM) in ABAP systems
  • Access to the exercises' Data Intelligence environment

• Deep Dive 1 - ABAP CDS View based data extraction in SAP Data Intelligence

  • Deep Dive 1.1 - Create a simple ABAP CDS View in ABAP Develoment Tools (ADT)
  • Deep Dive 1.2 - Delta-enablement for simple ABAP CDS Views
  • Deep Dive 1.3 - Create a more complex ABAP CDS View in ADT (joining multiple tables)
  • Deep Dive 1.4 - Delta-enablement for complex ABAP CDS Views (joining multiple tables)
  • Deep Dive 1.5 - Integrate ABAP CDS Views in SAP Data Intelligence Pipelines

• Deep Dive 2 - Calling an ABAP function module in SAP S/4HANA from SAP Data Intelligence

  • Deep Dive 2.1 - Create a custom ABAP Operator in SAP S/4HANA
  • Deep Dive 2.2 - Integrate the custom ABAP Operator in a SAP Data Intelligence Pipeline

• Exercise 1 - Replicating data from S/4HANA ABAP CDS Views in SAP Data Intelligence

  • Exercise 1.1 - Consume the EPM Business Partner ABAP CDS Views in SAP Data Intelligence
  • Exercise 1.2 - Extend the Pipeline to transfer Customer data to an S3 Object Store (Initial Load and Delta Load)
  • Exercise 1.3 - Implement a Pipeline for replication of enhanced EPM Sales Order data to an S3 Object Store
  • Exercise 1.4 - Extend the Pipeline for joining Sales Order with Customer data for each change in Sales Orders and persist results in S3

• Exercise 2 - Triggering the execution of a function module in a remote S/4HANA system

  • Exercise 2.1 - Making custom ABAP Operators available in SAP Data Intelligence
  • Exercise 2.2 - Using a custom ABAP Operator to verify your Delta Replication of EPM Sales Orders

Here is a graphical overview about the topics and processes that we will focus on during this hands-on workshop and how they relate to each other.

How to obtain support

Support for the content in this repository is available during the actual time of the online session for which this content has been designed. Otherwise, you may request support via the Issues tab.

In case you have problems with the implementation of the Pipelines, you can download the example Pipelines here (right-click --> save link as...). The JSON files can be imported as Pipelines in the Data Intelligence Modeler.

• Customer Master Data Replication Pipeline
• Sales Order Replication Pipeline
• Sales Order Replication and Enrichment Pipeline
• ABAP Function Module Call Pipeline

License

Copyright (c) 2020 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.