Assigning Data Sources 

On the Title and Database screen, you enter a description of the InfoSet. The end user sees this name when creating a query. It should, therefore, allow for an InfoSet to be identified.

The field Authorization group allows you to enter an authorization group up to eight characters long. If you specify an authorization group, it is inherited as an attribute by every report generated for a query via this InfoSet. This means that only users authorized in their user master records to execute programs from this authorization group can execute these queries. Authorization groups thus provide a way of protecting reports generated by the query from unauthorized execution.

Please do not confuse authorization groups with user groups.

Authorization groups can be assigned for any reports and determine a user’s right to execute a program. Authorization groups can be entered in user master records using the authorization object S_PROGRAM. (You can find more detailed information on this authorization object in transaction AUTH_DISPLAY_OBJECTS. Choose here the authorization class Basis Development Environment and then the documentation for the authorization object S_PROGRAM).

User groups help you to control access and change authorizations for queries in the SAP Query environment.

The following five options are open to you when selecting the data source:

Table join using Basis table

A table join always takes in several tables that are read with the aid of special forms of the SELECT instructions. Enter in the entry field the first table in the join. The additional tables can be entered after choosing the Continue pushbutton.

You can find more information in Table Join Definition Procedures.

Read table directly

The data is read directly from an SAP table. The table must be entered in the ABAP Dictionary and must exist in the database.

Further information can be found under Reading Directly.

Logical database

Enter the name of the logical database. The input help allows you to get a list of all logical databases. From this list, you can request detailed information about individual logical databases. The logical database structure, that is the hierarchical relationship of logical database tables to each other, is particularly important for creating InfoSets.

Pay attention to the remarks contained in the appendix: Logical Databases with Different Node Types.

If you have already entered a logical database, you can request detailed information about it by using the function.

In the Selection screen version field, you can enter an ID for the version of the selection screen you want to use for queries in this InfoSet. If you leave the field blank, the system calls the standard selection screen when the query is executed. The version consists of a three-character ID. The chosen selection screen version must be supported by the logical database. You can use the Possible values help to find which selection screen versions are available.

Retrieving data with programs

Using an ABAP Report you can make evaluations on datasets, for which the automatic data retrieval of the query is not sufficient. You can find more information under Data Retrieval by a Program

Sequential Datasets

Select this field if you wish to allow evaluations on a sequential dataset, without having to take care of the data retrieval in query reports yourself. Then, enter the sequential dataset file name you want to read. Its record structure should correspond to the structure specified. Further information can be found under Sequential Dataset.

The option Sequential Dataset is shown under Data Retrieval by Program if you choose the pushbutton Additional Options in the dialog box displayed above.

If a text field exists for a particular field then this is displayed in the InfoSet maintenance with a corresponding icon. When creating queries using the InfoSet, you can choose between displaying the value and displaying the relevant text in the report. Choose the option No automatic text recognition if this is not required.

You can use the field Fixed point arithmetic to specify whether queries defined via this InfoSet should work with fixed point arithmetic switched on or off. The contents of this field are thus an attribute of the generated reports. In the standard system , fixed point arithmetic is always switched on.

You can change the fixed point arithmetic status for an existing InfoSet. When doing this, however, you must check all the code relating to the InfoSet. If this code contains calculations with values of type P, you must adapt these calculations to the modified fixed point arithmetic status.

If you choose the pushbutton Additional Options then the entry fields Class for Text Identification and InfoSet Generator appear. Compare here the actions in the section Application-specific Enhancements.

The example in this section refer to InfoSets using the logical database F1S (flight bookings).

InfoSets using a logical database and InfoSets without any underlying database are, to a large extent, made in the same way so that the actions in the following units both refer to logical databases as well as to other options for retrieving data. For this, read the section entitled Special Features under InfoSets without a Logical Database, or the actions in the sections that are referred to in the table above.