topic Re: Selections Screen Processing in Application Development and Automation Discussions

Selections Screen Processing

Former Member — Fri, 25 May 2007 20:39:46 GMT

I have a selection screen with several select-options, most of which

allow multiple selections and/or ranges.

These selection crietera have to be used to retrieve data for

a report. I can generate a first SQL statement to retrieve all

the records meeting the top-level selection criteria. And then I would

have to filter the data using several loops to apply the other

selection criteria. I could also create one or more views in the dictionary

to reduce the need for this loop processing.

What is the best way to proceed?

Former Member — Fri, 25 May 2007 20:42:10 GMT

Or you could use JOINs.

Rob

Former Member — Fri, 25 May 2007 20:56:14 GMT

Depend on ur database then you can decide ,You could write Normal select query with having join select query .

Please take up in internal table only 3 tables for each join query and if you take more than 3 tables and it would be performance issue.

and also try to use for all entries and it gives better option.