CPI-DS integration with SAP BW4HANA

[rajucbit_2000]

Hi There,

Can we write data into BW4HANA from SAP IBP using CPI-DS?

I'm able to load into SAP IBP from BW4H.

Cheers,

Raj

[lingaiahvanam]

Hi,

SAP B/4HANA provides a multitude of innovations in various areas. One of the focus areas is extended and simplified ways to integrate non-ABAP typically non-SAP data structures as well as ABAP SAP systems data structures into SAP BW.

Loading and persisting data from on-premise sources as well as Cloud Applications and one of the key functionalities of an Enterprise Datawarehouse (EDW).

Loading and persisting data from Cloud Applications in an SAP B/4HANA data warehouse are possible in many ways.

To enable such scenarios SAP B/4HANA 2.0 provides new capabilities in the datastore objects to push data in the inbound table of datastore object using a tool such as Data Services or via SAP Cloud Platform Integration (CPI) by PUSH.

These API for pushing data to Datastore objects is not released for third-party tools.

This property can be used for all types of standard datastore object and staging datastore object, but not together with inventory enabled and planning enabled datastore objects.

It is possible to use RFC ot http data to load into the datastore object. There are two possibilities.

• Sending data without a request. For every call, a new internal request is opened.
• Sending data with the request. The following sequence is used to do this. Open Request, n times Send Data (with request and package), Close Request.

SAP Cloud Platform Integration and SAP NetWeaver Process Integration equal or higher SAP NetWeaver 7.50 Process Integration SP15 (SAP Note 2757524) can use this http (REST) interface for data integration to SAP BW/4HANA 2.0.

TechEd Session DAT118 - http://sapteched.com/online

Best Regards,

Lingaiah

[rajucbit_2000]

Agree with Pavan. CPI-DS can only be connected with BW7.4 and 7.5 but not with BW4. See below link for CPI-DS -PAM pdf

https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/SAP_Cloud_Platform_Integr...

[former_member183908]

Hi Everyone,

Let me conclude this thread.

As Nazeer explained in his very first reply,below option is possible only if BW is not on Hana.

but in our case, BW is not on HANA. we send data to an inbound DSO. 
There are few configurations needed in the BW system. but this should 
work.

As i said,I cant see external system option under Source system in RSA1,this option is not available in BW/4

Step 3 : I logged into RSA1 in BW4 Hana however under source system I 
don't find External system option.I tired using eclipse however lo luck.

Please refer SAP Note 2441836 for more details

Cheers

Pavan Nukala

[former_member306083]

Hi everyone, I following the instructions, but I have a dump creating the external system, I found a note related to the dump (

https://launchpad.support.sap.com/#/notes/2400725

), that certain source system are not allowed (my version is 7.5 and I can't deinstall BW4HANA

This happen with the WS system too.

Do you know a fix for this?

Regards

[rajucbit_2000]

Thank You all.

Sorry for later reply guys as I was away.

I've created an infosource in BW4 and when i try importing this object in CPI-DS hitting below error(Second Image) though the infosource is active in BW4(Third screenshot).

[former_member183908]

Hi Rajender,

Please refer my latest comment.We both are facing the same issue.

Cheers

Pavan Nukala

[former_member183908]

Hi Nazeer,

Thanks for the response.

Step 1 : Successfully Created SAPDS Type T destination with SAPDS as the programID,gatewayhost as the hostname of the BW/4 Hana system and sapgw00 is the gateway service

Step 2: Successfully registered ProgramID using OS command and SAPDS type T destination connection test was successful

Step 3 : I logged into RSA1 in BW4 Hana however under source system I don't find External system option.I tired using eclipse however lo luck.

Please can you let me know what was missing from my side?

Cheers

Pavan Nukala

[former_member423067]

Hi Pavan,

i'm not a BW expert, but i checked online. external system is available default in RSA1. please check with a BW functional.

with regards,

Nazeer

[former_member183908]

Hi Nazeer,

Please let me know the list configurations to be done in BW/4 Hana to load data into BW/4 from CPI -Data Services.

I am extracting master data from SFSF and loading into on-Premise BW/4.Data Store for BW/4 created successfully, however while trying to import Infosource I am getting an error. Please can you help me here.

There are few configurations needed in the BW system. but this should work.


Cheers

Pavan Nukala

[former_member423067]

Hello Pavan,

i have listed few steps, which i remember while working with my team. hope this helps and solves your issue.

As a pre-requisite, SAP BW need to have specific Basis version, I think SAP BW 7.40 SP05 is minimum. We have SAP BW 7.40 SP11.

• 1.@Basis Team Creation of RFC (TC\IP) destination in BW – Destination Name SAPDS and PROG ID – SAPDS

• 2.@Basis Team register the program id in rfc

To register the program login into the OS level in BW as sudo su - <sid>adm and execute the following command.

rfcexec u2013g<program id> -a<gateway host name> -x<gateway service>

Test connection should work after step1 and step2.

• 3.@BW Functional Team : Creation of Source System as “EXTERNAL System” in BW –

• System name – SAPDS and RFC as SAPDS from step 1. (other fields BLANK)

• 

• 4.@BW Functional Team : Creation of DSO and select system as SAPDS

• 5.@HCI Team: Import the DSO in HCI – System Name – SAPDS and Type Transaction

• 6.@Security Team: Add right Authorization to User connecting to BW from HCI: Refer attached note for Roles required. ( This is will be biggest challenge in the whole process)
• Refer SAP Note : 1891274 - How to set SAP user authorizations for DataServices 4.1 and 4.2 and Hana Cloud Integration

• 

with regards,

Nazeer

[former_member457882]

Hi,

Can you please explain how to create a DSO with selecting the system SAPDS?

Do we need to create a datasource on SAPDS?

When creating the datasource we receive message:

DataSource ZIBP_DS_001(SAPDS): Object type RSDS not supported in BAPI source system

Message no. RSDS180

Diagnosis

You are trying to create a DataSource (R3TR RSDS) in a source system of type External System .

Please advise.

[lingaiahvanam]

Hi Rajender,

SAP IBP write data into BW using CPI-DS via web service call.

I could not find any information or SAP help to write data from IBP to BW/4HANA. I would suggest following the standard integration approach to BW from IBP via web service call.

https://help.sap.com/viewer/addc41d6745c44448826b86b24283b70/1811/en-US/204a99543f2ee331e10000000a44...

If you are not able to find the solution and raise support incident to SAP.

Best Regards,

Lingaiah

[former_member423067]

Hi Lingaiah,

Have you tried using "BW as Target" Datasource? For BW as receiver system, we are using BW as Target DS. but in our case, BW is not on HANA. we send data to an inbound DSO. There are few configurations needed in the BW system. but this should work.

Try and post your results here.

with regards,

Nazeer