Data transfer from APO Cube to ECC system

[Former Member]

Hi,

We have a requirement where we want to bring some APO infocube data from APO to ECC. We will be using open hub destination this purpose.

Query is how to bring data from Open hub destination to ECC?

Any pointer to this will be highly appreciated.

regards,

Mohit

[Former Member]

Hi Mohit

I am not sure why you are going for Open hub concept.

If you asked, I would go for RFC connection which is much faster and easy to implement the process. You can create data source in APO based on Infocube data, this data can be pulled/extracted in ECC system using RFC connection.

Please also find below the link explain Open hub concept in more detail.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5092a542-350f-2d10-50bd-fc8cb3902...

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. (This is my preferred option 🙂

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.

Please let us know if the information helps you.

Amol