topic Re: Read table across systems function module in Application Development and Automation Discussions

Read table across systems function module

Former Member — Thu, 01 Oct 2009 22:40:22 GMT

Is there an SAP supplied function module that will let me read table contents on a remote system when I don't have SM59 permissions.

I.E.

[1] I have a user name / password on EQ3CLNT100

[2] I'm logged in to DE1CLNT100

[3] I want to execute a select statement on the MARC table for example into an internal table.

I'm only interested in passive/read only functions ... no update or modify operations.

Thanks

Former Member — Thu, 01 Oct 2009 22:44:11 GMT

you may read only from those systems which are remotely connection(RFC enabled). and this RFC is through SM59.

so what are you saying? you donot have SM59, but do you have RFC settings to other systems?

Former Member — Thu, 01 Oct 2009 22:59:24 GMT

Sorry for the confusion.

There is an RFC connection between systems.

I can be logged in to DE1=> Start SM59=> ABAP Connections=> Test Connection to EQ3CLNT100

That all works fine.

I also have a login and password to EQ3.

What I'd like to do is something like this

Select matnr werks from marc into ta_marc

sysid = 'EQ3'

mandt = '100'

password = 'mycomplexstring'

where blah blah blah.

former_member156446 — Thu, 01 Oct 2009 23:00:40 GMT

TABLE_ENTRIES_GET_VIA_RFC

RFC_GET_TABLE_ENTRIES

RFC_READ_TABLE [(example)|http://searchsap.techtarget.com/tip/0,289483,sid21_gci997032,00.html]

Former Member — Fri, 02 Oct 2009 05:34:41 GMT

no need of user name pass word... directly call the FMs RFC_GET_TABLE_ENTRIES or RFC_READ_TABLE and you only need logical path (rfc)

use this wiki