topic Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE in Application Development and Automation Discussions

Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Mon, 08 Sep 2014 15:15:38 GMT

hi EXPERTS

how can use options in RFC_READ_TABLE like SQL where clause.

date
ex: includes creation date and changed date from Mara table

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

former_member206257 — Mon, 08 Sep 2014 15:38:28 GMT

REFRESH: OPTIONS, FIELDS, ITAB.

CONCATENATE '''' IUST10S-OBJCT '''' INTO OPTIONTEXT.

CONCATENATE '''' IUST10S-AUTH '''' INTO OPTIONTEXT1.

CONCATENATE 'OBJCT =' OPTIONTEXT 'AND' 'AUTH = ' OPTIONTEXT1 INTO

OPTIONTEXT SEPARATED BY SPACE.

OPTIONS-TEXT = OPTIONTEXT.

APPEND OPTIONS.

FIELDS-FIELDNAME = 'OBJCT'. APPEND FIELDS.

FIELDS-FIELDNAME = 'AUTH'. APPEND FIELDS.

FIELDS-FIELDNAME = 'FIELD'. APPEND FIELDS.

FIELDS-FIELDNAME = 'VON'. APPEND FIELDS.

FIELDS-FIELDNAME = 'BIS'. APPEND FIELDS.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION RFCSYS

EXPORTING

QUERY_TABLE = 'UST12'

TABLES

OPTIONS = OPTIONS

FIELDS = FIELDS

DATA = ITAB

EXCEPTIONS

TABLE_NOT_AVAILABLE = 1

TABLE_WITHOUT_DATA = 2

OPTION_NOT_VALID = 3

FIELD_NOT_VALID = 4

NOT_AUTHORIZED = 5

DATA_BUFFER_EXCEEDED = 6

OTHERS = 7.

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

paul_bakker2 — Tue, 09 Sep 2014 03:53:10 GMT

Here's a simple example.

cheers

Paul

* specify the fields to be selected in table 'i_fields'
i_fields-fieldname = 'AUART'.
append i_fields.
i_fields-fieldname = 'AUTYP'.
append i_fields.

* specify the selection conditions in table 'i_options'
i_options = 'AUART = ''OA01'''.
append i_options.
i_options = 'AND AUTYP = 01'.
append i_options.

call function 'RFC_READ_TABLE'
     destination 'NONE'
     exporting
          query_table          = 'AUFK'
          delimiter            = '|'
     tables
          options              = i_options
          fields               = i_fields
          data                 = i_data.

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Thu, 11 Sep 2014 09:48:43 GMT

Hi ,

Thanks for the update,

but i need to extract Created materials from MARA Between two dates.

how can i pass two dates to to I_OTIONS ..

please help me it s very urjent

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

former_member206257 — Thu, 11 Sep 2014 09:57:28 GMT

Hi ,

budat BETWEEN '21040101' AND '20140102' .

append i_options .

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Thu, 11 Sep 2014 10:04:06 GMT

Its not working

ERSDA = BEWEEN '20140820'AND'20140911'

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

former_member206257 — Thu, 11 Sep 2014 10:18:54 GMT

WHY '= BETWEEN'??? REMOVE =

IT SHOULD BE ERSDA BEWEEN '20140820' AND '20140911'

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Thu, 11 Sep 2014 10:36:32 GMT

Yes its working Thanks a Lot

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

paul_bakker2 — Thu, 11 Sep 2014 10:58:57 GMT

That's great news. Please close the thread by marking the answers.

cheers

Paul

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Tue, 30 Sep 2014 07:45:13 GMT

Hi,,

i passed the same ERSDA BETWEEN '20140918' AND '20140930'

in FM 'RFC_READ_TABLE' but i am getting the exception 7. i am gettig the values after run this FM.

Can u plse help me

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

Former Member — Tue, 30 Sep 2014 07:46:15 GMT

i am not getting any values

Re: Reg:RFC LOGIC for the function module RFC_READ_TABLE

pearlin123 — Thu, 09 May 2024 10:10:40 GMT

You can use

call function 'f4_conv_selopt_to_whereclause'