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:
************************************************************************
Execute BW query using ABAP
************************************************************************
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.