Entering content frame

Selection Views Locate the document in its SAP Library structure

Selection views are a collection of fields from different database tables. You can define extra selections for fields in a selection view at runtime using dynamic selections. The extra selections are sent to the database and help to minimize the number of database accesses. This works as long as the database tables in the selection include of the logical database are defined for dynamic selections, and that the database program is programmed accordingly.

You can define a selection view from the ABAP Workbench by choosing Extras Selection views to open the Logical Database Builder, or by choosing Further objects from the initial screen of the Repository Browser. They are identified using a three-character key describing the origin of the selection view. Predefined selection views have the key SAP, customer designed ones have the key CUS. This way, users can define the best logical database selection views for their requirements.

If you want to use a selection view in a logical database, it must be called STANDARD, and must be assigned to a logical database. Selection views that are not assigned to a particular logical database may have any name, and they can be used freely.

The following rules apply to the structure of dynamic selections on the selection screens of logical databases: You can only use selection views with the name STANDARD and which are assigned to the to logical database. If there is a customer-defined selection view (key CUS), it is used. Otherwise, the predefined selection view (key SAP) is used. If there is no selection view with the name STANDARD that is assigned to the logical database, you can construct dynamic selections using any field of any table in the logical database.

Editing Selection Views

When you create or change a selection view in the Logical Database Builder, you need to fill in the following input fields:

Functional Groups

Within a selection view, fields are grouped into functional groups. All of the fields assigned to a functional group are contained in the view. Functional groups allow you to search more efficiently when you use a selection view. You define a functional group by assigning an ID and a descriptive text to it. The functional group ID can consist of any two characters. It is only relevant when you edit the selection view.

Table/Node Name

This field contains the names of the database tables from which you can choose fields for the selection view. In the bottom part of the screen, the system displays the fields of one of the tables. To choose the table, use the Choose function or double-click the table or node name.

Fields in the Table or Node

In this field, enter the ID of the functional group in which you want to adopt the field. The fields is then assigned to this functional area and included in the selection view. For a field assigned to a functional group to be able to be used in a logical database, the corresponding node in the logical database must also have been defined for dynamic selections.

If a field of a table is assigned to a functional group, a checkbox appears to the right of the field description, in which you can mark the field for preselection. These fields then appear as selection criteria on the selection screen for dynamic selections. You can change the preselected fields by choosing New field selection on the selection screen. A selection list appears, containing all of the fields in the selection view for which dynamic selections are supported in the corresponding node of the logical database.




Leaving content frame