cancel
Showing results for 
Search instead for 
Did you mean: 

Passing Parameters to FM RRW3_GET_QUERY_VIEW_DATA

rashmi_11
Explorer
0 Kudos
1,516

Hello Experts,

I have read a lot of threads regarding passing parameters to FM RRW3_GET_QUERY_VIEW_DATA to fetch query data but I am unsuccessful in every attempt. I am using the same procedure:

data : lt_para type RRXW3TQUERY.

data : ls_para type W3QUERY.

clear ls_para.

ls_para-name = 'VAR_NAME_1'.

ls_para-value = '0I_FPER'.

APPEND ls_para TO lt_para.

ls_para-name = 'VAR_OPERATOR_1'.

ls_para-value = 'BT'.

APPEND ls_para TO lt_para.

ls_para-name = 'VAR_VALUE_LOW_EXT_1'.

ls_para-value = '001.2002'.

APPEND ls_para TO lt_para.

ls_para-name = 'VAR_VALUE_HIGH_EXT_1'.

ls_para-value = '001.2009'.

APPEND ls_para TO lt_para.

ls_para-name = 'var_sign_1'.

ls_para-value = 'I'.

APPEND ls_para TO lt_para.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

*i_infoprovider = ''

i_query = 'RP_FI008_01'

i_t_parameter = lt_para.

I am using the variable name which is mentioned in the Query Designer.

Every time I get the exception "Invalid Input = 5".

It would be great if anybody could help me with this.

Thanks in advance.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member231709
Active Contributor
0 Kudos

'var_sign_1' must be in upper case:

ls_para-name = 'VAR_SIGN_1'.
FCI
Active Contributor
0 Kudos

What I would test:

1. Try the internal format for the parameter valuer ls_para-value = '2009001'.

2. See if it works without any parameter (try to identify which input parameter is invalid : infoPro, query or parameters)

FCI
Active Contributor
0 Kudos

Did you fill the parameter I_INFOPROVIDER ? It is mandatory to identify a query. It seems commented in your code.

Regards,

Frederic

rashmi_11
Explorer
0 Kudos

Hi Frederic,

Tried it as well, doesn't work for me..

Regards,

Rashmi

0 Kudos
rashmi_11
Explorer
0 Kudos

Hello Ender,

Thanks for the reference. I have tried the procedure given in this link but it also generated an exception "Invalid Input = 5".

Regards,

Rashmi