topic Re: Writing efficient select statement in Application Development and Automation Discussions

Writing efficient select statement

Former Member — Thu, 22 May 2008 08:14:23 GMT

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?

Re: Writing efficient select statement

Former Member — Thu, 22 May 2008 08:16:37 GMT

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.

Re: Writing efficient select statement

Former Member — Thu, 22 May 2008 08:17:07 GMT

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.

Re: Writing efficient select statement

Former Member — Mon, 11 Aug 2008 04:55:13 GMT

Using dynamic select statement solved this problem.