topic Re: select-options data in Application Development and Automation Discussions

select-options data

Former Member — Thu, 26 Jul 2007 08:29:06 GMT

Hello

I have select options for material and plant (s_matnr and s_plant), and this select statement:

select *

from marc

where matnr IN s_matnr AND

werks IN s_plant.

To improve performance, I would like to obtain before all combinations material-plant, and to reduce the where clause into '=' comparisons.

Any help?

Thanks.

Re: select-options data

Former Member — Thu, 26 Jul 2007 08:32:58 GMT

hi,

You can use parameter inplace of select-options and then use it like this

parameter : s_matnr like mara-matnr,

s_plant like mara-werks.

select *

from marc

where matnr = s_matnr AND

werks = s_plant.

Regards,

Himanshu

Re: select-options data

seshatalpasai_madala — Thu, 26 Jul 2007 08:36:13 GMT

Hi,

When you use IN it will be converted to simple = and OR statements only.

Why do you want to do the job of the Database optimizer.

Regards,

Sesh

Re: select-options data

Former Member — Thu, 26 Jul 2007 08:36:27 GMT

Hi Alberto,

By this way there will be no performance improvement.

If you don't want the use to enter the multipel entries then use PARAMETERS.

or you can try with SELECT OPTIONS with NO- INTERVAL option.

Regards,

Atish

Re: select-options data

Former Member — Thu, 26 Jul 2007 08:47:22 GMT

hi,

selection-screen : begin of block blk1 with frame title text-001.

parameters : p_matnr like marc-matnr,

p_werks like marc-werks.

selection-screen : end of block blk1.

select * from marc where matnr = p_matnr

and werks = p_werks.

Reward with points if helpful.

Re: select-options data

Former Member — Thu, 26 Jul 2007 08:48:24 GMT

Hi,

Is these values mandatory in selection screen? if not make it mandatory.

Otherwise if you pass an empty select option in your where clause, it is going to fetch all the data.

If you want to use single values use parameter otherwise ensure that S_matnr and s_werks are not empty.

Re: select-options data

Former Member — Thu, 26 Jul 2007 08:56:58 GMT

you can use select-options: p_matnr for itab-matnr no-interval.

at selction-screen output.

loop at screen.

screen-name = 'p_matnr-high' .

screen-input = 0.

modify screen.

endloop.