topic Re: Reading table from other systems in Application Development and Automation Discussions

Reading table from other systems

yes_sapteam — Mon, 03 Mar 2008 11:25:31 GMT

Hi all.

I need to read a table from other R/3 systems.

More sepcifically, In our Production system I want to be able to read the description of a Change-request that is still in DEV/TST systems.

From my researches I understood that I need to create an RFC Function-module that I can call, but the question is how exactly is this done.

If make sense that I need to call this FM between an open & close of RFC connections, but I don't think I found the right SAP FM's for that.

I found the following FM's "RFC_TCPIP_CONNECTION_OPEN" & "RFC_CONNECTION_CLOSE", but since they don't have documentations I'm not sure these are the right ones, or that I'm on the right track at all.

Any help is appreciated.

ayal.

Re: Reading table from other systems

former_member404244 — Mon, 03 Mar 2008 11:41:21 GMT

Hi,

lets take there are two systems A and B.. iwant to get the data from B ...First create a RFC function module in system B,write the logic in system B with the data retrieval..Now in system A ,create a zprogram and call the FM that yu created in system B,but u have to hardcode this...

i mean u have to call like this..

CALL FUNCTION <FUNCTIONMODULE> Destination <destination name> OF (System B)

EXport

....

Import

....

Tables

...

Exceptions.

....

now pass the values and u will get the results from system B.

Regards,

Nagaraj

Re: Reading table from other systems

Former Member — Mon, 03 Mar 2008 13:16:37 GMT

Hi Ayal,

There is a RFC function module to read the table entries from other servers RFC_READ_TABLE .

You can use this function module to read the table entries like a select statement executed on that particular system/server.

But the prerequisite for this is there should be an RFC destination to be defined in between these two servers.

Regards..

Ravi

Re: Reading table from other systems

Former Member — Mon, 03 Mar 2008 13:21:47 GMT

HI,

check the following select statememnt,


SELECT * FROM hupast_t CLIENT SPECIFIED INTO TABLE lt_profile
        WHERE terminal = sf_terminal AND client = sy-mandt.

I hope you might bet get some idea.

CLIENT SPECIFIED is to retrieve the data from one client to another client.

<REMOVED BY MODERATOR>

Sekhar

Edited by: Alvaro Tejada Galindo on Mar 3, 2008 11:06 AM

Re: Reading table from other systems

yes_sapteam — Mon, 03 Mar 2008 14:45:45 GMT

Dear Nagaraj.

You answer helped me solved my problem.

I used is with the "Destination" addition:

call function 'Z_ZICR_GET_CR_DESC' destination lv_destination,

Where lv_destination is an RFC connection name as defined in SM59.

Enjoy.

ayal.