Skip to Content
Technical Articles

SAP Cloud Platform Integration (CPI) to push data into SAP BW/4HANA

One option to connect cloud applications with other SAP and non-SAP cloud and on-premises applications is the usage of SAP Cloud Platform Integration (CPI).

SAP Cloud Platform Integration is using the new http (REST) based interface for data integration to SAP BW/4HANA 2.0.

This blog describes how to push data from a Cloud application into a SAP BW/4HANA advanced DataStore Object.

In the first step a BW persistency object must be created.

1.Create DataStore Object in SAP BW/4HANA 2.0

Open the BW Modeling Tools in Eclipse and create a new DataStore Object.

 

Maintain the technical name and the description.

Please use DataStore Object 0EPM_ADSO3 as an template otherwise the CPI integration flow will not work.

 

Maintain the Special Properties in the DataStore Object and set Write-Interface-Enabled. Activate the DataStore Object.

 

2. Install the SAP Cloud Connector

Please ensure that the SAP Cloud Connector is already installed and runs properly. Details are available here.

3. Maintain the Integration Flow 

Open SAP Cloud Platform Integration Web Interface (System dependent).

Open Operations View.

 

Open Security Material Tile.

Add new User Credentials to connect from CPI -> SAP BW/4HANA.

Add User Credentials and deploy.

 

Open Discover Page and search for Package SAP BW/4HANA Integration With Rest Based Data Load.

Open Artifact View of package SAP BW/4HANA Integration With Rest Based Data Load.

Configure Integration Flow Integration for Open Purchase Orders with Rest Based Data Load.

Maintain the Connection for the SAP BW/4HANA System to push data into the defined advanced DataStore Object (created in step 1 in that blog).

It is mandatory to maintain both reciever connections (BW4System and TokenService).

Start with Token Service and maintain the Adress -> BW Serverhostname and DataStore Object Name.

 

 

Open Receiver Connection BW4System and maintain Adress here as well -> BW Serverhostname and DataStore Object Name.

 

Save and deploy.

Open the Integration flow and check if the details are well maintained.

 

E.g. check the field mapping.

 

In 3 fields (EPM_CHAT, EPM_PDELD and EPM_POAS) SAP included a simple type conversion for date and boolean. Here is one example:

 

Once all settings and mappings checked and maintained – deploy the Integration Flow.

 

4. Consume the data in SAP BW/4HANA

Go back to the SAP BW/4HANA System and open the BW Modeling Tools in Eclipse.

Search for the Write-Interafce-Enabled  advanced DataStore Object in which the already created Integration Flow is pushing the data.

Open the Manage view in the context menu of the advanced DataStore Object.

 

You will now see all the already pushed data from the source to the advanced DataStore Object in SAP BW/4HANA.

 

It is now possible to create a virtual model (Composite Provider) or transfer the data to the next layer of your Enterprise data model depending on your data model and the Business requirements.

 

20 Comments
You must be Logged on to comment or reply to a post.
  • Hi Gordon,

    thank you very much for this interesting blog about new features. Am I right that what you show here is a specific demo scenario provided by SAP for this new interface?

    Could you also provide information about Cloud Integration before BW/4HANA 2.0 and maybe for other approaches or integrating from non-SAP Cloud systems for BW? I can't find much for this area...

    • Hi,

      In my last project I built an ABAP program running on BW (BW/4 actually), calling the a REST API from SCP Workflows. You don't have access to the tables directly.

      The steps are actually pretty much the same as in the CPI flow:

      • Create an REST Request using ABAP OO.
      • Get a Security Token.
      • Call the API to access the data, including the token in the request.
      • Write the data to a BW aDSO using the corresponding API (ABAP Function Module).
      • The rest should be easy as pie.

      The same approach would work with any DataSource exposed via a REST API.

      Using SCP CPI would be cleaner, but of course you have to change the first part of the flow, as you pointed out.

      You can search for blogs explaining how to extract data from SCP Workflows, actually.

      Iñigo

       

  • Hi Gordon,

    if I try to find the package "SAP BW/4HANA 2.0 Integration with Rest based Data Replication" on our CPI system I can't find it. Any idea?

     

    Regards
    Thorsten

  • Thorsten,

    I can see the the:

    Integration for Open Purchase Orders with Rest Based Data Load

    Thnaks

    Lakshmi Nese

  • Hi,

    We used the same approach to update records into ADSO. When we tried to send an array of records from CPI, it fails. But works when we send only one record. Any insight on that will be helpful.  Thanks.

  • Hi Gordon,

    thanks for the great blog. As I see the add-on that you have configured in CPI-Side is only for BW4HANA. What about BW-on-HANA-System? Can the same logic be followed for a BW-on-HANA 7.5 System to integrate with CPI or something else should be done for that?

    Thank you,

    Regys

    • Hi Sindhuja,

       

      unfortunately not - the write interface enabled aDSO is exclusively available for SAP BW/4HANA.

      But in BW on Hana the WebService interface is available. You can use CPI and push data via the BW Webservice into SAP BW on Hana.

      BR
      Gordon.

      • Hi Gordon,

        Thanks for the response. So, can we use Soap adapter in CPI end to send data to BW on HANA system once webservice configuration done in BW on HANA end? Kindly provide an advice.

        Regards,

        Sindhuja.

  • Hello,

     

    how would it be possible to send data to multiple different DataSources as "one transaction" as it was possible via SAP PI/PO with ABAP Proxy interfaces ?

     

    Thank you

  • I understand that you need the cloud connector to make this work. But what configuration is needed for CPI to connect to the BW server?

    • Hi,

      you can download the integration package here:

      https://api.sap.com/package/SAPBW4HANAIntegrationWithRestBasedDataLoad?section=Overview

      The feature is available since version SAP BW/4HANA 2.0.

      BR
      Gordon.

  • Thanks, Gordon

    I am aware of the package. I am trying to do a proof of concept using CPI to extract data from Ariba into BW/4Hana. I think I know how to configure the cloud connector now. Are you aware of any screenshots on configuring the CPI connection to the Ariba API? It seems to be very confusing since you have to download an access token.

  • Hi Gordon Witzel,

    Thank you for this useful blog. I have just one question about "Add new User Credentials to connect from CPI -> SAP BW/4HANA". Is there any documentation available about the type of BW user to provide (Dialog, System etc) and details about the BW Roles which this user should be given? We are attempting to implement this solution for productive use.

    Thanks in advance