Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Reading table from other systems

yes_sapteam
Participant

‎2008 Mar 03 11:25 AM

0 Likes
2,859

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.

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.

Reply
4 REPLIES 4
Read only

former_member404244
Active Contributor

‎2008 Mar 03 11:41 AM

0 Likes
2,055

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

Read only

yes_sapteam
Participant
In response to former_member404244

‎2008 Mar 03 2:45 PM

0 Likes
2,055

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.

Read only

Former Member

‎2008 Mar 03 1:16 PM

0 Likes
2,055

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

Read only

Former Member

‎2008 Mar 03 1:21 PM

0 Likes
2,055

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