topic Re: FM RFC_READ_TABLE in Application Development and Automation Discussions

FM RFC_READ_TABLE

TJRP — Thu, 21 May 2009 10:59:23 GMT

Hi,

I have writtten a program in APO that is required to read data from a bespoke table in R/3, so I'm using FM RFC_READ_TABLE to do this, I can easily retrieve 1 material by adding it to the Option table. My problem is that I have a select option in APO that I want to use to restrict the values being returned and I'm not sure how to code it.

Any ideas would be appreciated,

Regards

J-J

Re: FM RFC_READ_TABLE

Former Member — Thu, 21 May 2009 11:10:35 GMT

In Option You can write simple where clause as you write in select statement.

may be you will have to build string everytime using "Concatenate" in your program to pass it to the "option" parameter

Regards,

Prajakta

Re: FM RFC_READ_TABLE

former_member222860 — Thu, 21 May 2009 11:23:14 GMT

Hi,

In the Options tab you can write your where clause

like this:

matnr BETWEEN 'M1000' AND 'M1500'

thanks\

Mahesh

Re: FM RFC_READ_TABLE

Former Member — Thu, 21 May 2009 11:34:06 GMT

HI,

try something like belwo..



LOOP AT s_matnr.
CONCATENATE   'MATNR-SIGN = '  s_matnr-sign
                          'MATNR-OPTION =  ' s_matnr-option
                         'MATNR-LOW = ' s_matnr-low
                         'MATNR-HIGH = ' s_matnr-HIGH
                         OPTIONTEXT into OPTIONTEXT seperated by sapce.  
ENDLOOP.

   OPTIONS-TEXT = OPTIONTEXT.
   APPEND OPTIONS.

Pas this 
 CALL FUNCTION 'RFC_READ_TABLE' DESTINATION RFCSYS
           EXPORTING
                QUERY_TABLE          = 'AGR_1016'
           TABLES
                OPTIONS              = OPTIONS        "Pass to this as a option 
                FIELDS               = FIELDS
                DATA                 = ITAB .
              IF SY-SUBRC <> 0.
              ENDIF.

Prabhudas

Re: FM RFC_READ_TABLE

TJRP — Mon, 01 Jun 2009 10:28:10 GMT

I built up the select statement by loop through the select option, I thought there would be a quick way but no such luck.