Views

To define a view, proceed as follows:

1. Select the database tables of the view.

   These tables must be linked by defining the join conditions. It is also possible to use the join condition from a foreign key defined between the tables.

2. Select the fields of the base tables that the view uses.
3. Formulate the selection conditions that restrict the records in the view.

   Following different view types are supported:

   • Database views are implemented with an equivalent view of the database.
   • Projection views are used to hide fields of a table (only projection).
   • Help views can be used as a selection method in search helps.
   • Maintenance views allow you to maintain the data distributed to several tables for one application object at a time.
     Note

     Database views implement an inner join. The other view types implement an outer join.

The join conditions for database views can be formulated using equality relationships between any base fields. The join conditions for the other view types must be obtained from existing foreign keys. Tables can be combined in a maintenance view or help view only if they are linked to one another with foreign keys.

The maintenance status defines whether you can only read data with the view, or whether you can also insert and change data with it.

For more information, see the Views in the ABAP Keyword Documentation