send query result data to r3

[Former Member]

Hi,

There is a query defined in BW with some variables. The current process is user is executing the query with necessary variables and the query result output is saving as csv file and this file is used in r3 to update the data in r3.

Now we have to make this process automate. We have to get the query result and this result data has to send to r3.

We have a constraint of not using the Open hub method.

How to automate this process?

Any help is highly appreicated.

[Former Member]

Hi,

create a fm or abap in r/3. From there call fm RSDRI_INFOPROV_READ_RFC and provide all selections as well as the keyfigures and characteristics to be read to that fm. In case you need some help, check out the demo abap in bw called RSDRI_INFOPROV_READ_DEMO. It is about fm RSDRI_INFOPROV_READ, but that is basically the same fm. There are only little differences. The main difference is that one fm can be called remote via rfc and the other not.

regards

Siggi

[Former Member]

Hi Experts,

Any solution for this?

Thanks.