Explain different types of views in SAP ABAP.

1.	Explain different types of views in SAP ABAP.
Answer» A view is a virtual table that consists of fields from one or more TABLES. There are 4 types of VIEWS in SAP ABAP. They are: Projection View: It is used to hide specific fields in a given table and can also be used to gain access to the cluster, pooled, and transparent tables. Selection conditions are not available in a projection view. The projection view access will be through an Open SQL, not Native SQL. Help View: It is used in the search helps. The search help is able to select database views, database tables, and special help views. For database views, the search help is RESTRICTED to the inner joins and for database tables, it is restricted to a single table. It is not possible to define a help view in the database. Database View: It is a general view used for single or multiple basis tables. Once the database view is activated, multiple basis tables can be joined with an inner join by creating a matching SQL view. It is possible to access database views using both Open SQL and Native SQL. Maintenance View: It performs writes on different tables using EXTENDED table maintenance. One maintenance view is capable of CHANGING the contents of many related database tables unfailingly. The maintenance view cannot be accessed using Open SQL.

Answer»

A view is a virtual table that consists of fields from one or more TABLES. There are 4 types of VIEWS in SAP ABAP. They are:

Projection View: It is used to hide specific fields in a given table and can also be used to gain access to the cluster, pooled, and transparent tables. Selection conditions are not available in a projection view. The projection view access will be through an Open SQL, not Native SQL.
Help View: It is used in the search helps. The search help is able to select database views, database tables, and special help views. For database views, the search help is RESTRICTED to the inner joins and for database tables, it is restricted to a single table. It is not possible to define a help view in the database.
Database View: It is a general view used for single or multiple basis tables. Once the database view is activated, multiple basis tables can be joined with an inner join by creating a matching SQL view. It is possible to access database views using both Open SQL and Native SQL.
Maintenance View: It performs writes on different tables using EXTENDED table maintenance. One maintenance view is capable of CHANGING the contents of many related database tables unfailingly. The maintenance view cannot be accessed using Open SQL.

Discussion