ABAP Keyword Documentation → ABAP - Dictionary → Classic Objects in ABAP Dictionary → Views
A classic view (or view for short) is a repository object in ABAP Dictionary defined for existing database tables and their fields in the form-based ABAP Dictionary tool in ABAP Workbench. As well as the classic views, the ABAP Dictionary also manages the CDS views of the ABAP Core Data Services, which are defined by the CDS DDL in DDL source code.
The definition of a classic view consists of the following:
- Basis tables
- View fields
- Join conditions
- Selection conditions
- The possible relational operators are =, <>, >=, >, <=, <, LIKE, and NOT LIKE.
- Depending on the data type of the view field, constant texts and numbers are allowed as comparison values. System fields can be specified for maintenance views and help views using SYST-... or SY-....
- Multiple comparisons can be joined using AND and multiple comparisons for the same field can be joined using OR. Here, OR is stronger than AND.
The following types of classic views exist, of which only the database views are defined as SQL views on the database:
Like database tables, views have a short text description and (optional) documentation. A status known as a maintenance status determines whether a view is read-only or whether data can be inserted or modified in the view.
7.31 | 7.40 | 7.54
- Projections can be implemented using both database views and with special projection views.
- Only database tables can be specified as the basis tables of classic views, and no other views.
- In ABAP SQL, only views whose key fields are located together at the beginning of the view can be accessed.
- Views whose fields are all key fields should not be written to using
UPDATE FROM or
MODIFY FROM. For database views, this produces a syntax check warning and for projection views a syntax error or runtime error.
- As in database tables, the client dependency of a classic view that can be accessed using ABAP SQL (a database view or projection view) is determined by a first column with the built-in dictionary type CLNT. The client dependency of the basis tables is ignored here.
- CDS views defined using the CDS DDL of the ABAP Core Data Services in DDL source code offer all the functions of classic views and more. CDS views are, however, read-only, while some classic views can be modified.