Read table across systems function module

[Former Member]

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]

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]

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]

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]

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)

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=85000499#Validation%26Substitutioncomparis....

use this wiki