Writing efficient select statement

[Former Member]

Hi,

We have a function module with 11 import optional parameters. Our requirement is that even if 1 parameter is filled we have to select data based on that. If more that 1 parameter is filled we have to consider all filled parameters.

Is there any good way to do that without putting so many combinations of filled and unfilled parameters?

[Former Member]

Hi,

We have a function module with 11 import optional parameters. Our requirement is that even if 1 parameter is filled we have to select data based on that. If more that 1 parameter is filled we have to consider all filled parameters.

Is there any good way to do that without putting so many combinations of filled and unfilled parameters?

[Former Member]

You could use a dynamic where statement - use the F1 help on the Select statement for more information.

Or wait for someone to cut and paste it here for you...

Gareth.

[Former Member]

Hi,

I think U can use FOR ALL ENTRIES......in the SELECT stmt for this purpose...

It may help U out.

Reward if helpful.

Thanks.

[Former Member]

Using dynamic select statement solved this problem.