Skip to Content
0
Former Member
Jul 02, 2009 at 05:35 AM

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

387 Views

Hi SDN Community,

When using the CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

we are able to execute a query via ABAP with on variable.

But when we introduce a second variable, it fails.

Do you have any insights on what could be the problem.

Thank you.

Simon

************************************************************************

  • SAP Consulting BW Tools:

************************************************************************

************************************************************************

REPORT Z_EXECUTE_QUERY.

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 = 'CPPM_M51'.

query_name = 'DZR_CPPM_M51_BMA_MSREVIEW_0001'.

  • Fiscal Year Period

wa_i_parameters-name = 'VAR_NAME_1'.

wa_i_parameters-value = 'ZP_FPER'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_SIGN_1'.

wa_i_parameters-value = 'I'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_OPERATOR_1'.

wa_i_parameters-value = 'BT'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_VALUE_LOW_EXT_1'.

wa_i_parameters-value = '2009001'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_VALUE_HIGH_EXT_1'.

wa_i_parameters-value = '2009001'.

APPEND wa_i_parameters TO i_parameters.

  • Currency

wa_i_parameters-name = 'VAR_NAME_2'.

wa_i_parameters-value = 'ZPM_CURR'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_SIGN_2'.

wa_i_parameters-value = 'I'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_OPERATOR_2'.

wa_i_parameters-value = 'BT'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_VALUE_LOW_EXT_2'.

wa_i_parameters-value = 'AUD'.

APPEND wa_i_parameters TO i_parameters.

wa_i_parameters-name = 'VAR_VALUE_HIGH_EXT_2'.

wa_i_parameters-value = 'AUD'.

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.