topic Re: parameter to select-option conversion in Application Development and Automation Discussions

parameter to select-option conversion

Former Member — Fri, 23 Apr 2010 06:39:09 GMT

Hello Friends,

I have a parameter field on selection screen and it is optional.

If user enters any data on parameter, then I have to retrieve only corresponding value to the parameter from table.

If user does not enter any data in parameter, then I have to fetch all the records.

I want to convert this to selection-option.

please let me know....

Re: parameter to select-option conversion

Former Member — Fri, 23 Apr 2010 06:45:03 GMT

You can use a range for that......



PARAMETERS: p_test TYPE c.

IF p_test IS NOT INITIAL.
r_test-sign    = 'I'.
r_test-option = 'EQ'.
r_test-low     = p_test.
APPEND r_test.
ENDIF.

If no value is entered in parameter then don't populate the range and it will get all the possible values.

Re: parameter to select-option conversion

Former Member — Fri, 23 Apr 2010 06:45:49 GMT

Hi,

Instead of converting why cant you do like this ,


if P_field is initial.
select * from <table>
into table itab.
else.
select * from <table >
into table itab 
where field  = p_field.
endif.

You can use select-option as parameter in this way,


Select-options : s_field for wa-field no intervals no-extension.

Regads,

Raghava Channooru

Re: parameter to select-option conversion

Former Member — Fri, 23 Apr 2010 06:47:58 GMT

Hi,

Please see the SCN Rules before Posting

With Regards,

Sumodh.P

Re: parameter to select-option conversion

ThomasZloch — Fri, 23 Apr 2010 11:45:03 GMT

Welcome to SDN.

This is a very basic question that you can solve yourself. Please try and search for answers before posting questions, as we are trying to cut down on the redundancy in these forums.

Thread locked.

Thomas