topic Re: RFC_READ_TABLE function module going for dump when variable given in options in Application Development and Automation Discussions

RFC_READ_TABLE function module going for dump when variable given in options

Former Member — Wed, 23 May 2012 12:50:07 GMT

Hi Experts,

I am using fm RFC_READ_TABLE .
in options table parameter I am passing a variable of type date, and it is going for dump.
When I directly input the value to the options then no problem , for example vbeln = 12345345.
if we give variable ie Vbeln = lv_vbeln, probelm is comming.

Error analysis
Short text of error message:
Runtime error SAPSQL_WHERE_ILLEGAL_VALUE has occurred

    Long text of error message:
     Diagnosis
         Error texts from the batch input are not output
         Only a placeholder
     Procedure

    Technical information about the message:
    Message class....... 00
    Number.............. 341
    Variable 1.......... "SAPSQL_WHERE_ILLEGAL_VALUE"
    Variable 2.......... " "
    Variable 3.......... " "
    Variable 4.......... " "

lv_date = sy-datum.
wa_options-text = 'DATE = LV_DATE'.
APPEND wa_options TO tb_options.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION p_dest
EXPORTING
    query_table          = 'ZNDCEPTDEX'
TABLES
    OPTIONS              = tb_options
    fields               = tb_fields
    data                 = tb_data
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.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
          WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

So how to handle this issue.

Re: RFC_READ_TABLE function module going for dump when variable given in options

former_member213851 — Wed, 23 May 2012 12:57:58 GMT

Hi Shiva,

Please remove Quotes and Try :

wa_options-text = DATE = LV_DATE.

Regards Sachin.

Re: RFC_READ_TABLE function module going for dump when variable given in options

Former Member — Wed, 23 May 2012 13:02:31 GMT

Can you try to concatenate?

Concatenate 'DATE =' lv_Date into wa_options-text seperated by space.

APPEND wa_options TO tb_options.

Re: RFC_READ_TABLE function module going for dump when variable given in options

Former Member — Wed, 23 May 2012 13:08:34 GMT

This we cannot give sachin , because if we remove quotes , then that statement does not make sense.

Re: RFC_READ_TABLE function module going for dump when variable given in options

former_member282968 — Wed, 23 May 2012 13:08:35 GMT

Dear Shiva,

Instead of assigning directly use concatenate statement and assign the final variable.Like below:

CONCATENATE var1 var2 INTO var3 SEPARATED BY space.

With regards,