FM Query

[Former Member]

Hello, I'm trying to use a  function module  "RRW3_GET_QUERY_VIEW_DATA".. The problem is that when it returns data in variable under IMPORTING tab for E_AXIS_DATA. it returns data in a table which is inside the variable. I want to know how to access that table?

This is what I have done:

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

   I_INFOPROVIDER                = i_info

   I_QUERY                               = i_query

   I_VIEW_ID                             = i_view_i

   I_T_PARAMETER                 = i_param

IMPORTING

   E_AXIS_INFO                      = a_axis_info

   E_CELL_DATA                   = a_cell_data

   E_AXIS_DATA                    = a_axis_data

*   E_TXT_SYMBOLS             =

EXCEPTIONS

*   NO_APPLICABLE_DATA            = 1

*   INVALID_VARIABLE_VALUES       = 2

*   NO_AUTHORITY                  = 3

*   ABORT                         = 4

*   INVALID_INPUT                 = 5

*   INVALID_VIEW                  = 6

*   OTHERS                        = 7

          .

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

The problem is when I look at A_CELL_DATA, I see my data in. but when I a_axis_data, i see 2 rows with like this:

AXIS     SET

000       (0X8)

001       (210*8)

When I double click on (210*8) in SET, then a table opens up with the name: A_AXIS_DATA(2) - SET and shows all the data. This is the data that i want to bring in my internal table but i am not sure how to do this.

Please let me know.

Thanks.

[Former Member]

Hello, I'm trying to use a  function module  "RRW3_GET_QUERY_VIEW_DATA".. The problem is that when it returns data in variable under IMPORTING tab for E_AXIS_DATA. it returns data in a table which is inside the variable. I want to know how to access that table?

This is what I have done:

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

   I_INFOPROVIDER                = i_info

   I_QUERY                               = i_query

   I_VIEW_ID                             = i_view_i

   I_T_PARAMETER                 = i_param

IMPORTING

   E_AXIS_INFO                      = a_axis_info

   E_CELL_DATA                   = a_cell_data

   E_AXIS_DATA                    = a_axis_data

*   E_TXT_SYMBOLS             =

EXCEPTIONS

*   NO_APPLICABLE_DATA            = 1

*   INVALID_VARIABLE_VALUES       = 2

*   NO_AUTHORITY                  = 3

*   ABORT                         = 4

*   INVALID_INPUT                 = 5

*   INVALID_VIEW                  = 6

*   OTHERS                        = 7

          .

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

The problem is when I look at A_CELL_DATA, I see my data in. but when I a_axis_data, i see 2 rows with like this:

AXIS     SET

000       (0X8)

001       (210*8)

When I double click on (210*8) in SET, then a table opens up with the name: A_AXIS_DATA(2) - SET and shows all the data. This is the data that i want to bring in my internal table but i am not sure how to do this.

Please let me know.

Thanks.

[Mohamed_Mukhtar]

Hi Venkat,

Please follow below approach.

Loop at A_AXIS_DATA into wa_A_AXIS_DATA.
append lines of wa_A_AXIS_DATA- SET to lt_itab. "lt_itab is another internal table
endloop.

Thanks

[Former Member]

Thank you sir. but how do i declare it_tab?

Can you please put declare that as well? Which table should it be like?

Thanks.

[Mohamed_Mukhtar]

hi venkat,

Declare it_tab as

Data  : it_tab type standard table of RRWS_TX_SET.

Thanks

[Former Member]

Sir, that worked. thank you very much.