topic Re: RFC_READ_TABLE - options in Application Development and Automation Discussions

RFC_READ_TABLE - options

former_member185537 — Wed, 27 Jun 2018 13:19:30 GMT

Hello Experts,

Is there a possibility to give IN operator in the selection option of the query for the table in the RFC_READ_TABLE function module ?? Or is only the selection possible one by one using the options text. I have to select a range of document values for a particular field.

Re: RFC_READ_TABLE - options

ArthurParisius — Wed, 27 Jun 2018 13:39:45 GMT

I take it you're trying to read a table from a different server and that's why you're not using a SELECT?

IN can be used in the form of Field in (value1, value2,....)

Re: RFC_READ_TABLE - options

DoanManhQuynh — Thu, 28 Jun 2018 05:11:25 GMT

that function module call a dynamic SQL so you can define your WHERE clause as you want.

SELECT * FROM (QUERY_TABLE) INTO <WA> WHERE (OPTIONS).

You can use IN (value1, value2...) or if it required you can enhancement that rfc to add range variable.

Re: RFC_READ_TABLE - options

harald_lesche-holzbecher — Thu, 28 Jun 2018 18:29:05 GMT

This FM is not released for customer and has further restrictions, see note

382318 - FAQ|Function module RFC_READ_TABLE

So you should avoid using it.

Re: RFC_READ_TABLE - options

former_member185537 — Fri, 29 Jun 2018 06:25:35 GMT

Hello Harald,

Is there any alternative for the reading of the table from another table ?

Re: RFC_READ_TABLE - options

former_member185537 — Fri, 29 Jun 2018 06:26:48 GMT

Hello Arthur,

It does not go with the FM

Re: RFC_READ_TABLE - options

former_member185537 — Fri, 29 Jun 2018 06:27:10 GMT

Hello Quynh,

Same case as Arthur

Re: RFC_READ_TABLE - options

ArthurParisius — Fri, 29 Jun 2018 07:11:05 GMT

It does work.

Try testing it for example for table T000 and place MANDT IN ('000', '001') in the options table

Re: RFC_READ_TABLE - options

DoanManhQuynh — Fri, 29 Jun 2018 07:47:58 GMT

The SQL i got abow is copied from that fm, so since its dynamic SQL and SQL accept the statement IN( ... ) then it should work. could you share your coding call fm?

Re: RFC_READ_TABLE - options

pokrakam — Fri, 29 Jun 2018 12:56:23 GMT

Expose the data you need as a service or callable RFC function in the remote system.

Re: RFC_READ_TABLE - options

former_member185537 — Sun, 01 Jul 2018 07:27:05 GMT

Hello Arthur,

I had made a mistake in the query . I had used a period at the end. The ( ) technique works. Thanks for the suggestion.