topic Re: Fetching table data from another SAP system or client. in Application Development and Automation Discussions

Fetching table data from another SAP system or client.

Former Member — Thu, 20 Aug 2020 05:38:44 GMT

Hi,

I am working on client 100 and want to fetch a complete table from client 200 at once using a report program. I tried using RFC_READ_TABLE but that is not working for me as it only fetches one single column also my where clause is a long statement which is getting truncated due to the limit of C(72).

Thanks

Re: Fetching table data from another SAP system or client.

GK817 — Thu, 20 Aug 2020 05:52:19 GMT

Hi,

You should create a RFC-enabled FM and call it with destination to remote system. This way you can include all you complex where logic and tables in FM code.

Gaurav

Re: Fetching table data from another SAP system or client.

Sandra_Rossi — Thu, 20 Aug 2020 05:52:53 GMT

1. Use SELECT ... USING CLIENT '200' ... (or CLIENT SPECIFIED ... WHERE <clientcolumn> = '200')

2. Or create a custom RFC-enabled function module to do the job, instead of using RFC_READ_TABLE (not a good idea to use it, as already discussed in the forum).

Re: Fetching table data from another SAP system or client.

Former Member — Thu, 20 Aug 2020 12:48:20 GMT

Thanks for the help.

Re: Fetching table data from another SAP system or client.

Former Member — Thu, 20 Aug 2020 12:49:01 GMT

Very helpful.
Thanks.

Re: Fetching table data from another SAP system or client.

Sandra_Rossi — Thu, 20 Aug 2020 12:56:24 GMT

For information, concerning RFC_READ_TABLE:

I don't understand why you couldn't select more than one column (parameter FIELDS is an internal table, each line is used to indicate one column).
There's no limit of the WHERE because it's an internal table (lines of 72 characters each, which are concatenated to form one logical expression).

Anyway, don't use RFC_READ_TABLE, as already discussed in the forum.