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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

Max,

Do you have any sample?

[Former Member]

Hi

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