topic find error in code in Application Development and Automation Discussions

find error in code

Former Member — Thu, 05 Feb 2015 12:51:56 GMT

Hi Gurus,

Can any one tell me , why function module is not selecting data based on options ?

DATA: l_be_log_system1
TYPE be_log_system,

lt_options1 TYPE TABLE OF rfc_db_opt,

ls_options1 LIKE LINE OF lt_options1,

i_fields1 TYPE TABLE OF rfc_db_fld,

wa_fields1 TYPE rfc_db_fld,

i_data1 TYPE TABLE OF tab512,

wa_data1 TYPE tab512.

data: line type line .

l_be_log_system1 = es_item-be_log_system.

*************** FOR OPTIONS

READ TABLE i_account into wa_account with KEY order_no = '001000007336'.

concatenate 'order_no = ''' wa_account-order_no '''' into line .

move: line to ls_options1 .

append ls_options1 to lt_options1 .

************** FOR FIELDS

wa_fields1-fieldname = 'AUFNR'.

APPEND wa_fields1 TO i_fields1.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION l_be_log_system1

EXPORTING

query_table = 'COAS'

TABLES

OPTIONS = lt_options1

fields = i_fields1

data = i_data1

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.

Thanks in Advance

Hari Gutti

Re: find error in code

rosenberg_eitan — Thu, 05 Feb 2015 13:30:15 GMT

Hi,

What do you have in sy-subrc after the call ?

Regards

Re: find error in code

RaymondGiuseppi — Thu, 05 Feb 2015 13:43:04 GMT

Did you forgot to add a OR between each selection criteria (or refresh the itab)?

If the target is a SAP system, does your table COAS actually contain a field "order_no"?

Did you always monitor sy-subrc?

Regards,

Raymond

Re: find error in code

Former Member — Thu, 05 Feb 2015 13:49:28 GMT

hi hari

problem seems to be here in this code

concatenate 'order_no = ''' wa_account-order_no '''' into line .

***move: line to ls_options1 .

ls_options1 = 'order_no = 1234'.

append ls_options1 to lt_options1 .

here lt_options1 is internal table

if this is selection options then you have to give high or low value