Skip to Content
Technical Articles
Author's profile photo Venu Krishna Murthy

Extract and Integrate Data from SAP S/4HANA Cloud using CDI


For all SAP solutions / applications – especially in the context of the Intelligent Enterprise Suite – it is important to support the data integration provided by SAP Data Intelligence. CDI (Cloud Data Integration) provides data extraction capabilities based on OData services. In addition to the OData specification it adds services to find and manage data extraction services as well as handle full load in packages and delta load. SAP S/4HANA Cloud Edition Communication Scenario is SAP_COM_0531 – enables the access to the CDS view extraction via CDI (available with SAP S/4HANA CE 2002). The application data is made available for further data processing in SAP Data Intelligence pipelines. SAP Data Intelligence contains by default a Pipeline operator, which allows to consume data exposed via CDI directly in Pipelines.

Example Scenario

  • Analyse the different activities/steps of a business process
    • Example process: Order2Cash

Source System: SAP S/4HANA Cloud

Target: Example scenario is to download the data in csv format from SAP Data Intelligence -> System Management tile. SAP Data Intelligence provides various options to extract and integrate data to other target systems e.g., Other SAP systems and 3rd Party Systems.

Example CDS View Data Extractors:

Data Extraction for Sales document Item

Billing Document Item Basic Extraction Data


Process Flow Diagram

Data Flow Diagram


Integration with SAP Data Intelligence via CDI(Cloud Data Integration)

SAP Data Intelligence example for extracting the data from SAP S/4HANA Cloud using Cloud Data Integration option and saving the extracted data in a LOCAL storage.

Step 1: Create a Communication Arrangement using Communication Scenario “SAP_COM_0531” in SAP S/4HANA Cloud.


Step 2: Create a connection of type “CLOUD_DATA_INTEGRATION”.


Step 3: SAP Data Intelligence Pipeline using Cloud Data Integration Operator.

Step 4: Configure the Cloud Data Integration Operator with example CDS view data extractor: C_SALESDOCUMENTSCHEDLINEDEX.

Step 5: Save and execute pipeline.


  • Data is extracted from SAP S/4HANA Cloud using Cloud Data Integration option
  • File will be created in local storage
  • Navigate to System Management from SAP Data Intelligence Launchpad->Files
    • Expand folder Files under My workspace to find the created file with extracted data from SAP S/4HANA Cloud.
    • Click on the icon “Show Actions” to down the load file into the local storage by using the option “Export File”.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mike Jolton
      Mike Jolton


      Thank you for this blog.  Would this approach also work for getting data from S/4HANA Cloud into Enterprise HANA?

      Author's profile photo Venu Krishna Murthy
      Venu Krishna Murthy
      Blog Post Author

      Hi Mike,

      Yes, there are controls to connect with Enterprise HANA in SAP Data Hub and by using those controls the above approach will work for getting data from S/4HANA Cloud into Enterprise HANA.

      Thanks & Best Regards,


      Author's profile photo Rajiv Pandey
      Rajiv Pandey

      HI Venu

      CDI Presentation how data is getting extracted  at this level it looks good , could you pl add how data could flow to legacy system & S/4 HANA to & fro ( eg LIMS-laboratory information system , DCS - distributed control system  etc.) .