Show TOC

 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:

  • If dynamic selections are used for reports (ABAP reports), new selection fields become available without programming and the database is accessed in a way that is conducive to good performance.

  • If used for queries (SAP Query), your main benefit is improved performance because SAP Query enables you to enhance queries with additional selection fields in the standard system.

Prerequisites

If you want to use dynamic selections in a report or query, the following prerequisites must be met:

  • You must define a selection view that contains the required field (by doing so, you determine that the field in question can generally be used as a dynamic selection ).

  • You must use Customizing for the Human Resources Information System to define a report category to which you assign the selection view.

  • You must assign the report to a report category. Queries are always assigned to report category ___X2001. This means you must adjust the report category accordingly if you want to use dynamic selections in queries. They are then valid for all of the queries in the system.

Note Note

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 Start of the navigation path Logical Database Builder Next navigation step ( Next navigation step Tools Next navigation step ABAP Workbench Next navigation step Development Next navigation step Programming Environment Next navigation step Logical Databases End of the navigation path ).

End of the note.

Displaying Standard Selection Fields for Logical Database PNP

  1. In the Logical database field, enter PNP .

  2. In the Subobjects group box, select Structure .

  3. Choose Display .

  4. Place the cursor on the PERNR node, and choose .

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