Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select is not working

Hi Experts,

I am trying to fetch the data with select options, data is not getting fetched because the table column space in the end so even in the standard ALV selection of the table I need to put the star in the end of the selection.

Same I tried here with CP and adding star in the end of the range but no luck can you try and suggest it.

code is like below.

TYPES: BEGIN OF ls_range,



           LOW(30) TYPE C,

           HIGH(30) TYPE C,

         END OF ls_range.

  DATA:  ls_r_group_value TYPE TABLE OF ls_range,

         ls_wa_group_value LIKE LINE OF ls_r_group_value.

LOOP AT p_it_conversion ASSIGNING <fs_conversion>.

      ls_wa_group_value-sign   = gc_rng_sign_include.

      ls_wa_group_value-option = gc_rng_opt_equal.  here I tried equal and CP both

      CONCATENATE <fs_conversion>-old_value '*' INTO <fs_conversion>-old_value.

      SHIFT <fs_conversion>-old_value RIGHT DELETING TRAILING ''.

      SHIFT <fs_conversion>-old_value LEFT DELETING LEADING ''.

      ls_wa_group_value-low = <fs_conversion>-old_value.

      ls_wa_group_value-high = ''.

      APPEND ls_wa_group_value TO ls_r_group_value.


    SELECT dashboard_id period kpi_id group1_value group2_value group3_value SUM( DATA_1 ) SUM( DATA_2 ) SUM( DATA_3 ) SUM( DATA_4 )

      FROM /kpi

      INTO TABLE lt_t_/kpi

      WHERE dashboard_id  = p_iv_dashboard_id AND hier_node IN ls_r_group_value

      GROUP BY dashboard_id period kpi_id group1_value group2_value group3_value.

Not what you were looking for? View more on this topic or Ask a question