topic Re: Select is not working in Application Development and Automation Discussions

Select is not working

Former Member — Fri, 15 May 2015 10:55:23 GMT

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,

SIGN(1),

OPTION(2),

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.

ENDLOOP.

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.

Re: Select is not working

Former Member — Fri, 15 May 2015 11:04:22 GMT

Hello Mangilal,

When using wildcard character you must use option = CP anyway.

Could you please send a screenshot of ls_r_group_value variable content (in debug mode) at select statement and a screenshot of the lines (in SE16) you expect to get in table /kpi ?

Are you sure there is not conversion exit to execute (what you see in table is not what you get, matter of internal and external value). In SE16 you can't activate and deactivate conversion exits to check.

Regards

Re: Select is not working

Former Member — Wed, 27 May 2015 07:44:18 GMT

Hi Brice,

Please find the attached screenshots.

There is no conversion routine, its a direct FM to update the table data.

Re: Select is not working

ipravir — Wed, 27 May 2015 07:53:06 GMT

Hi Mangilal,

Can you declare the range table using RANGES data type.

Like:

Ranges: ls_r_group_value FOR /kpi-hier_node.

And then try.

Regards,

Praveer.

Re: Select is not working

Former Member — Wed, 27 May 2015 09:04:09 GMT

Hi Praveer,

Unfortunately this is not working

Re: Select is not working

Former Member — Wed, 27 May 2015 09:15:47 GMT

Hello Mangilal,

You have an issue with lower case characters.

Your range must be based on data element that allows lower case.

You must also check the field from which you copy the value.

"Development" <> "DEVELOPMENT"

Regards

Re: Select is not working

Former Member — Wed, 27 May 2015 09:19:31 GMT

Option "CP" is fine for wildcard characters. "EQ" will not work

Did you check what value you are passing in p_iv_dashboard_id WHERE dashboard_id = p_iv_dashboard_id?

Re: Select is not working

Former Member — Wed, 27 May 2015 11:09:19 GMT

This message was moderated.

Re: Select is not working

Former Member — Wed, 27 May 2015 12:45:36 GMT

Hi Mangilal,

Try to declare your range like this:

DATA: ls_r_group_value TYPE RANGE OF /kpi-hier_node WITH HEADER LINE.

Best Regards.

Benjamin

Re: Select is not working

Former Member — Thu, 28 May 2015 07:30:48 GMT

Hi Brice,

Values are same as in table because I copied and pasted and also this same range is working for 3 other columns.

In debugging only its showing in capitals, but same working fine for other select only column in where is different rest all is same.

I think there is some issue with column value, because while i even display the value by SE16 i need to keep * in the end of the hierarchy data column filter, else no values are displayed.

Re: Select is not working

Former Member — Thu, 28 May 2015 07:32:45 GMT

guys,

Let me explain one more thing, This is something with data of that column I mean how system is interpreting...because if I select from normal SE16 even need to keep * in the end of the filter value.

Please share if someone faced such strange issue.

Re: Select is not working

matt — Thu, 28 May 2015 07:41:27 GMT

Header lines are obsolete and bad practice programming. Define separate work areas instead.

Re: Select is not working

matt — Thu, 28 May 2015 07:41:54 GMT

Even so, you should use this form rather than defining the structure yourself.

Re: Select is not working

matt — Thu, 28 May 2015 07:42:26 GMT

When you run in debug, what does the range table contain?

Re: Select is not working

Former Member — Thu, 28 May 2015 08:25:09 GMT

HI Mathew,

see my attached screenshot, I attached the range table values.

Re: Select is not working

Former Member — Thu, 28 May 2015 09:09:02 GMT

Hi All,

Please see the attached screenshots for normal SE16 selection screen where I need to put *, then suggest it accordingly. I think this is the reason why data is not getting selected.

selection screen with column value.

No Data

Put * in the end of selection value

Values are displayed.

Re: Select is not working

Former Member — Thu, 28 May 2015 09:37:23 GMT

This message was moderated.

Re: Select is not working

Former Member — Thu, 28 May 2015 09:51:58 GMT

Spaces in front of values ?

Re: Select is not working

RaymondGiuseppi — Thu, 28 May 2015 10:53:00 GMT

RANGES is obsolete now, use


DATA:  ls_r_group_value TYPE RANGE OF char30. " or text30 if lowercase

Did you check for conversion-exit associated with field domain?

Regards,

Raymond

Re: Select is not working

matt — Thu, 28 May 2015 11:19:05 GMT

What is the domain of the field in the table?