Selections Screen Processing

[Former Member]

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]

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.

[Former Member]

Or you could use JOINs.

Rob

[Former Member]

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.