Extracting Data from a Source System


After completing this lesson, you will be able to:

  • Describe how an ABAP CDS View extracts data from a source system


Scenario Overview

Let's start with the first step of the data flow.

In SAP S/4HANA, an ABAP CDS View has already been defined.

ABAP CDS View: terminology and use cases

An ABAP CDS View is an ABAP object that is a part of SAP S/4HANA. An ABAP CDS View exposes business data that is stored in database tables. SAP provides a very large number of ABAP CDS Views covering all business functions. It is possible to customize these SAP- supplied ABAP CDS Views or even create your own from scratch. An ABAP CDS View is created and maintained in a development tool called Eclipse. We use code to define the ABAP CDS View. The code looks a lot like SQL. The code can appear a little complicated at first, but with practice you will soon learn how to understand the processing logic of an ABAP CDS View and to identify the most important parameters used by the SAP BW/4HANA extraction process.

An ABAP CDS View can serve multiple purposes. It can be used by many different SAP systems including SAP Analytics Cloud and SAP DataSphere. If you want an ABAP CDS View to support data extraction and loading to SAP BW/4HANA, you must enable the setting: @Analytics.dataExtraction.enabled: true in the definition.

ABAP CDS View: system settings

In our scenario the ABAP CDS View ZPEPMCDSVSO1 combines several sales tables such as SNWD_SO (Sales Order Header data), SNWD_SO_I (Sales Order Item Details) and SNWD_SO_SL (Sales Orders Schedule Lines). This ABAP CDS View consists of source fields and their corresponding meta data (data type, length, decimals, currency, etc) from the selected tables.

Our ABAP CDS View has the setting @Analytics.dataExtraction.enabled: true so it is ready to extract data from SAP S/4HANA to SAP BW/4HANA.

Watch the demonstration below to explore the output of an ABAP CDS View in SAP S/4HANA.

Explore an ABAP CDS View

Log in to track your progress & complete quizzes