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
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:
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.