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 a table cross system

Former Member

‎2009 Jul 06 10:34 AM

0 Likes
886

Hi all,

I want to compare some data from different systems. So I want to read table X from system A, B and C. After that I will present all data in a nice ALV list.

What would be the easiest way to read data *Cross system?* I have tried using FM RFC_READ_TABLE but that one has some limitations like the amount of data to be read... Anyone any suggestions?

thanks and regards,

Ron.

Hi all,

I want to compare some data from different systems. So I want to read table X from system A, B and C. After that I will present all data in a nice ALV list.

What would be the easiest way to read data *Cross system?* I have tried using FM RFC_READ_TABLE but that one has some limitations like the amount of data to be read... Anyone any suggestions?

thanks and regards,

Ron.

Reply
5 REPLIES 5
Read only

Former Member

‎2009 Jul 06 10:44 AM

0 Likes
816

Hi,

There is no limitation with number of records..do not pass the rowcount parameter to the FM..it will fetch all the records that meets the conition you pass in Options table.

Read only

Former Member
In response to Former Member

‎2009 Jul 06 10:47 AM

0 Likes
816

Hi Avinash,

I think, when remembering well, this FM also give you a popup for each system I want to read. Is there a way to get around that as well?

This is because I need to fetch data from several systems.

Edited by: Ron Dijkstra on Jul 6, 2009 2:11 PM

Read only

ThomasZloch
Active Contributor
In response to Former Member

‎2009 Jul 06 1:17 PM

0 Likes
816

The popup appears because you need to log on in each remote system with a valid user ID and password. You can avoid that by maintaining RFC destinations in SM59 and store the logon information there. You can then use these destinations in your calls to RFC_READ_TABLE.

Thomas

Read only

Former Member
In response to Former Member

‎2009 Jul 06 2:25 PM

0 Likes
816

Hi Thomas,

that's indeed a very nifty solution. I'm not sure if it's allowed to create a new RFC destination for each system though. I tried setting one of the RFC destinations to a trusted system. Then you appearantly wouldn't need the pasword anymore, but then the call of frc_table_read dumps with error 7. (unknown).

Read only

ThomasZloch
Active Contributor
In response to Former Member

‎2009 Jul 06 4:48 PM

0 Likes
816

Yes, there is a few more prerequisites for trusted RFC. The calling system must be registered as a trusted system in the called system, there should be a user ID in the called system with an identical name as the one logged on in the calling system, several authorization settings must be in place in both systems. You should consult SAP online help for more information on trusted RFC.

Maybe your return code is due to some of these prerequisites not being met.

Thomas