2023 Dec 19 1:09 PM
Hi Gurus,
I'm trying to fetch data from CDS I_GLACCTBALANCECUBE in ABAP program.
To achieve this, I am using FM "RRW3_GET_QUERY_VIEW_DATA". This function module is working fine and providing me the data from the cube as well.
However, when I try to pass the date value to filter out the results then it throws "invalid_input" exception. I'm passing the parameter values in below Import parameter.
It seems like I can't pass parameters using this approach, Company code and other values are getting accepted by FM. Only issue is with date.
ls_parameter-name = 'VAR_NAME_2'.
ls_parameter-value = '!CDS_P_P_FROMPOSTINGDATE'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_SIGN_2'.
ls_parameter-value = 'I'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_OPERATOR_2'.
ls_parameter-value = 'EQ'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_VALUE_LOW_EXT_2'.
ls_parameter-value = '01.01.2023'.
APPEND ls_parameter TO i_t_parameter.