topic Pass variable value to RRW3_GET_QUERY_VIEW_DATA in Application Development and Automation Discussions

Pass variable value to RRW3_GET_QUERY_VIEW_DATA

Former Member — Fri, 06 Jun 2008 12:09:54 GMT

Hi experts,

I am facing a problem using FM RRW3_GET_QUERY_VIEW_DATA. I can execute the query saved in variable query_name, but all parameters I append to i_parameters are ignored. When I debug the program I can see in the FM that the parameters are passed to the FM, but unfortunately are completely ignored.

Am I missing something?

Any help is highly appreciated and points will be rewarded for usefull answers.

Below is my code, I'm working on a BW3.5 SP19.

Thanks!

Stephan

DATA: query_name TYPE RSZCOMPID,

s_cubename TYPE RSINFOPROV,

wa_i_parameters TYPE W3QUERY,

i_parameters TYPE RRXW3TQUERY,

T_AXIS_INFO TYPE RRWS_THX_AXIS_INFO,

T_CELL_DATA TYPE RRWS_T_CELL,

T_AXIS_DATA TYPE RRWS_THX_AXIS_DATA,

L_S_T_AXIS_DATA LIKE LINE OF T_AXIS_DATA.

s_cubename = '0QM_C10'.

query_name = 'SKTST_MTBF2'.

wa_i_parameters-name = 'VAR_NAME_1'.

wa_i_parameters-value = '0I_CALMO'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAL_VALUE_EXT_1'.

wa_i_parameters-value = '200708'.

APPEND wa_i_parameters TO i_parameters.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

i_infoprovider = s_cubename

i_query = query_name

i_t_parameter = i_parameters

IMPORTING

E_CELL_DATA = t_cell_data

E_AXIS_INFO = t_axis_info

E_AXIS_DATA = t_axis_data.

Re: Pass variable value to RRW3_GET_QUERY_VIEW_DATA

Former Member — Fri, 06 Jun 2008 12:27:27 GMT

instead of using "VAR_VALUE_EXT_I" I had to use "VAR_VALUE_LOW_EXT_I" and "VAR_VALUE_HIGH_EXT_I". That's all

Re: Pass variable value to RRW3_GET_QUERY_VIEW_DATA

Former Member — Fri, 03 Jul 2009 05:09:56 GMT

Hi Stephan,

I have been successful so far in using your program to run queries.

I have found that you cannot pass parameters to the FM if the variable that have in the option "Can be changed during query navigation"

Maybe i am overlooking something here?

Also i am trying to pass parameters for a hierarchy node variable.

Have you done something like this?

Thank you.

Simon