topic R/3 Dialog program - read data from BW table (2 different servers) in Application Development and Automation Discussions

R/3 Dialog program - read data from BW table (2 different servers)

Former Member — Fri, 15 Jun 2007 08:05:06 GMT

I have this R/3 dialog program that need to pull data from one of the BW table for data validation Apparently, R/3 and BW are setting on 2 different servers.

Is this something possible? or is that any other approach that can give me the same result?

Please give your exper advice. TQ.

Re: R/3 Dialog program - read data from BW table (2 different servers)

Former Member — Fri, 15 Jun 2007 08:08:14 GMT

U can use or create a RFC function module to get the data from BW.

This fm has to be created in BW and called by R3 program.

Max

Re: R/3 Dialog program - read data from BW table (2 different servers)

Former Member — Fri, 15 Jun 2007 08:10:10 GMT

Max,

Do you have any sample?

Re: R/3 Dialog program - read data from BW table (2 different servers)

Former Member — Fri, 15 Jun 2007 08:27:09 GMT

No but it's very easy.

The RFC fm is a normal function where the attribute Remote-enable module is setted.

When a program call a RFC function module, this has to exist in the called system (so it's not necessary there's in calling system too).

The data has to be transfered by inteface, so your fm has to have importing/exporting parameter in order to select the data you need to check.

A rfc has to be called in this way:

CALL FUNCTION <FUNCTION> DESTINATION <DEST>
  EXPORTING
    .......................
  IMPORTING
    ....................... 
  tables
    .......................
 EXCEPTIONS
    ......................

<DEST> is BW destination, you can find it by trx SM59

Try to see the standard fm RFC_READ_TABLE, it's a RFC function module to read a table.

Max