Assigning Data Sources


You want to create a new InfoSet (see Creating InfoSets) and are in the InfoSet: Title and Database dialog box.

You can also get to the InfoSet: Title and Database dialog box from the Change InfoSet screen, by choosing the Goto -> Global Properties function. The only information you are able to change is information that does not relate to the data source of the InfoSet.


Proceed as follows to assign a data source to an InfoSet:

  1. In the Name field, give a description (short text) of the InfoSet.

This is the name the end user sees when he or she creates a query. It must therefore be a name that enables users to identify this particular InfoSet.

  1. In the Authorization Group field, specify the name of an authorization group. This name can have a maximum of eight characters.

This authorization group is inherited as an attribute by every report that is generated for a query by this InfoSet. This means that only users authorized in their user master records to execute programs from this authorization group are able to execute these queries and their corresponding reports.

Do not confuse the terms authorization group and user group.

An authorization group can be assigned for one or more reports. It determines the authorizations for executing queries and reports. You use the authorization object S_PROGRAM to add authorization groups to individual user master records.

For more information about this authorization object, see transaction AUTH_DISPLAY_OBJECTS Display Active Authorization Objects. Choose the authorization class Basis – Development Environment, and then for S_PROGRAM.

User groups allow you to control the authorizations that allow users to access and change queries.

  1. Choose a data source.

    Select the corresponding radio button to activate one of the following options.

    Table join using a table

    A table join includes several tables that are read by special forms of the SELECT statements.

    Specify the name of the table that you want to use to start the join definition. You can choose more tables later.

    Choose Continue.

    For more information, see

    Defining Table Joins with the Help of Graphics

    Defining Table Joins without the Help of Graphics

    Reading tables directly

    The data is read directly from an SAP table. The table must be included in the data dictionary.

    Give the name of the table.

    For more information see Reading Tables Directly.

    Logical databases

    Selection screen version

    Specify the name of the logical database.

    Use input help to get a list of all the logical databases.

    Note the remarks contained in the appendix: Logical Databases with Different Node Types.

    Once you have specified the name of a logical database, you click on the Display Logical Database icon to display more detailed information about the logical database.

    You can assign a three-character ID to the version of a selection screen and use it with the queries in this InfoSet. The selection screen version must be supported by the logical database. You can use the input help to find out the selection screen versions that are available.

    If you leave the Selection Screen Version field blank, the system calls the standard selection screen when it executes the query.

    Using programs to retrieve data

    You can use an ABAP report to evaluate any datasets, for which the automatic data retrieval process in the query is inadequate.

    For more information see Using Programs to Retrieve Data

    Sequential datasets

    Choose Display Additional Options .

    If you want to be able to evaluate sequential datasets without monitoring the data retrieval process in the query report yourself, select the radio button Sequential Datasets.

    Specify the name of the file that you want to read from. The record structure for this file must correspond to the default structure.

    For more information see Sequential Datasets.

  2. Select the following options:
    • No automatic text recognition

Whenever a table field has a text field, this is shown in the InfoSet maintenance by a corresponding symbol. When creating queries using the InfoSet, you choose whether to display the value or the relevant text in the report.

If you do not want to use this function, put a checkmark in the checkbox.

    • Fixed-point arithmetic

You can specify whether or not the queries that are defined using this InfoSet operate with the fixed point arithmetic function switched on or off. The contents of this field becomes an attribute of the generated reports.

In the standard system, the fixed point arithmetic function is always switched on. We recommend that you do not change this setting.

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

  1. Choose Additional Options and set the following:
    • Class for identifying text
    • InfoSet generator

For more information see Application-Specific Enhancements.

  1. Finish by clicking on .

The dialog box is closed.