Show TOC

 Reading tables directly

Use

You want users of a query to be able to report directly on the contents of a table. For this purpose you create an InfoSet for the table in question.

Prerequisites

The table must be available in the data dictionary and on the database.

Procedure

  1. You are in the InfoSet: Title and Database dialog box . Specify the required data. For more information see Assigning Data Sources .

  2. Choose Direct Read of Table as the data source.

  3. Give the name of the table.

  4. Choose Continue .

Note Note

You use a SELECT ABAP statement to read a table directly.

SELECT * FROM <table>. ...

ENDSELECT.

In the following cases, a WHERE condition is added automatically to this SELECT statement:

End of the note.

  • In InfoSets where selection criteria that refer to the table are defined.

  • In queries where additional selections for fields of the table are defined.

Result

In the maintenance screens for an InfoSet that retrieves its data from a single table, you have the same options available to you as you do when you are working with InfoSets that get their data from table joins or logical databases.

You can also add additional tables to make a table join. You click on the Join function and get to the InfoSet: Join Definition screen or the InfoSet: Tables in Join screen. This effectively removes any differences there were between InfoSets that read data from a single table and InfoSets that read data from a table join.

For more information see Special Features .