topic Re: Reading data from a BW Table in Application Development and Automation Discussions

Reading data from a BW Table

Former Member — Tue, 07 Nov 2006 11:32:56 GMT

Hi All,

I have a DB Table in BW. I have to read that tables data from R/3 in a program. Both the R/3 and Bw are connected through RFC. Is there any way to do this?

Thanks,

RPK.

Re: Reading data from a BW Table

Former Member — Tue, 07 Nov 2006 11:38:18 GMT

Hello,

-> create one FM in BW which RFC enabled (input as table and output table is should contain all table data)

-> In R/3 system use call destination logic to call , therefore you can have all the data belongs to that table in R/3 table.

*******Poorna********

Re: Reading data from a BW Table

Former Member — Tue, 07 Nov 2006 11:45:53 GMT

Hi Poorna,

I have developed a program in R/3 which will have all the table data in an internal table. Is this enough from BW side or do I need to do something else? What do you mean by RFC enable FM?

Could you please explain me a bit more on R/3 side.

Thanks,

RPK.

Re: Reading data from a BW Table

Former Member — Tue, 07 Nov 2006 14:40:03 GMT

Hi Poorna/All,

I have created a function group in BW and also created a function module in it which picks the data from the table and stores in an internal table(output table). I have made this FM as RFC Enable(Just selected the 'Remote-Enabled Module' instead of 'Normal Function module', please let me know if I have to do something else to make it RFC enabled). I have tested it and it is picking up all the required data.

Now, I need help in the process to be followed at R/3 side. Could you please help me in this.

Thanks,

RPk.

Re: Reading data from a BW Table

Former Member — Thu, 09 Nov 2006 10:32:26 GMT

Hello,

1) goto atrributes of FM and say as RFC enable - sothat other system get through this FM.

2) In source code wirte a select query to fetch table data and put into internal table.

3)try to call FM in R/3 sytem.

******Poorna********