!--a11y-->
Enhancing the Selection Screen - Dynamic Selections 
Use
Dynamic selections
are used to enhance reports with selection criteria that are not included in the standard selection screen of logical database PNP. They are also used to improve the performance of reports and queries. For more information on the distinction between the two, see the notes under Integration.By enhancing reports using dynamic selections, you supplement standard reports or reports you programmed yourself with selection fields that are not included in the standard selection screen of the logical database. Enhancing an SAP report this way is not the same as modifying it because the report is enhanced by assigning the report category. The actual program object is not changed.
Performance is improved when queries are executed because dynamic selections often ensure that the database is accessed more effectively than when selection fields are added to standard selection fields when the query is defined.
For example, you use your system to manage data on 10,000 employees, but frequently use queries to output data on just a few of them. For example, you only want to output employees whose nationality is French, and only 120 of your employees satisfy this condition. (Let us assume in this example that you use this condition as your only selection criterion.)
Without dynamic selections, data (persons) is retrieved in two steps. First, all 10,000 employees are read from the database and transferred to your program. Second, the 120 employees in question are selected from these 10,000 employees.
With dynamic selections, your condition is transferred straight to the database. Just 120 employees are read from the database, and transferred to your program. This more effective method of accessing data improves performance considerably. It often enables you to execute reports and queries directly which, without dynamic selections, could only be executed in batch operations.
If you require more information on how to use dynamic selections in a query, see Dynamic Selections.
Integration
Dynamic selections
are defined by creating an appropriate selection view. They are assigned to reports (ABAP reports) or queries (SAP Query) via a report category that uses this selection view.These two options can be distinguished one from the other as follows:
Prerequisites
If you want to use dynamic selections in a report or query, the following prerequisites must be met:

This fast method of accessing data has already been implemented in the standard system for the standard selection fields of logical database PNP. This means that defining dynamic selections to improve performance is only relevant to fields that are not standard selection fields.
If you require information on the standard selection fields of logical databases PNP and PAP, see the Logical Database Builder (Tools ® ABAP Workbench ® Development ® Programming Environment ® Logical Databases).
Displaying Standard Selection Fields for Logical Database PNP
The system displays all of the fields that are included in the standard selection screen of logical database PNP in the standard system.
See also:
Create Dynamic Selections