Sending BI Infocube Data to ECC Database Table

[Former Member]

Hi Experts,

We have a requirement where we need to send the data available in the Infocube or DSO Object into a Z database table defined in SAP ECC System.

Can we use the Open Hub Destination (RSA18) to push this data into ECC system OR do we have any other alternative solution such as retraction where we can push this data more effeciently into the database table in ECC.

Kindly provide your suggestions and inputs, if possible with a stepwise solution. Please let me know the SAP best practice in this regard, for maximun performance.

Thanks in Advance,

Uday

[Former Member]

This message was moderated.

[Former Member]

Thanks for the replies. Executing the Open Hub DTP through process chain resolved the issue.

[Former Member]

Could you please share , how did you achive this?

[Former Member]

So it mean you are not exporting data to ECC database or External database.

You are just transferring internally. right?

[Former Member]

Hi

Could you please let us know how you have solved this problem...

In loading the data from cube to back to again ECC Ztable...As I have an requirment on the sme....

Thanks

[Former Member]

Hi Friends !

I know this a very old post....Can you tell how to retract the data from BI to ECC Z table? Any sample code?

As per my knowledge, Open Hub store the file in BW itself & in FF not in ECC. Please advise.

With Regards

Rekha

[Former Member]

HI Rekha,

Using open hub we can send data to falt file. using the same flat file we can load the data in to ECC ztables using Bdc and lsmw. these process are purely abap related...

[Former Member]

Hi

Open Hub Destination functionality is used to distribute data from SAP BI to other non-SAP data systems.

Steps in Extraction of data from SAP BI Info Cube to a .csv file on a desktop.

Step1

Execute transaction RSA1, Press 'Open Hub Destination'

Step2

Select Info Area and right click to 'Create Open Hub Destination Enter Name and Description

Step3

Go to 'Destination' tab, enter Destination Type as 'File type'. In this example, we will be exporting data in a .csv file, select Directory to 'Desktop'

Step4

Go to 'Fields Def.' tab, select the InfoObjects you would like to have in your exported file

Step5

Activate the Open Hub Destination by pressing 'Activate' button ,Select the Open Hub Destination

Step6

Enter source of transformation as InfoCube , Accept the proposed mapping and activate

Step7

Create Data Transfer Process for transfering data from InfoCube to Desktop as .csv file or choose theTable name in your ECC, make sure the connectivity is establishd between ECC and BI

Step8

Enter source of DTP as InfoCube ,Activate DTP and Execute, Data will be exported to .csv file which will be stored at desktop

Step9

Press 'Yes' to check the status of request monitor,Data is exported as the monitor status is green

Step10

Check the exported file at on your Desktop and in your ECC system.

This is how you can export the file to your local destop, while exporting and loading choose the Destination table.

Santosh

[dennis_scoville4]

There are a couple of ways you can do this:

1) Create an Open Hub Destination to retract the data into a flat file and FTP the file to the ECC server and load with an ABAP program.

2) Create an Open Hub Destination to retract the data into a databae table, create a remote Function Module on BW to read the data from the table and pass to the calling program and create an ABAP program on ECC to call the remote Function Module.

3) Create a remote Function Module in BW to read the data and pass back to calling ABAP program and create the calling ABAP program on ECC to use the remote Function Module to retrieve the data and load into ECC.