Direct Read 

If you want to allow the end-user to generate reports by performing a direct reading on the contents of a table without having to worry about data retrieval, proceed as you would for creating an InfoSet. On the Title and Database, specify the table name in the field Table and select Direct read.

The table must be entered in the ABAP Dictionary and must exist in the database.

Here, you can also choose any of the options available when maintaining InfoSets that use logical databases, for example linking additional tables, as well as defining additional fields, parameters and selection criteria. Please take note of the remarks made at the end of the Sequential Datasets section.

To read an additional table directly, use an ABAP Open SQL loop of the form

 

SELECT * FROM <table>.
...

ENDSELECT.

 

In the following cases, a WHERE condition is automatically appended to the SELECT statement:
  1. In InfoSets where selection criteria are defined to refer to the table.
  2. In queries where additional selections are defined for fields of the table.