Views in SAP ABAP

Views in SAP ABAP 

Views in SAP ABAP data dictionary are important topic on which ABAP developer must have knwoledge to create views and for maintaining views.

Most of the times ,data of an application object is often distributed on many tables. Using a view, we can define an application-dependent view that combines this data. The structure of such a view is defined by creating the tables and fields used in the view. Fields which are not required can be hidden, thereby minimizing interfaces.

Views can be used in ABAP programs for data selection.

The data of a view is collected from one or more tables, but not stored physically. The simplest form of deriving data is to choose one or more fields from a base table (projection) or to include only certain entries of a base table in the view (selection). Many complicated views can comprise several base tables, the individual tables are linked with a relational join operation.

Join, Projection and Selection.


Base tables of the view  must be selected in the first step of a view . In the second step, these tables are  linked by defining the join conditions.  foreign key relationship  tables can used



In the third step, we should  select the fields of the base tables to be used in the view. in  fourth step.we can define selection conditions which  restrict the records in the view .


We can define Four different view  types .


Database views are implemented with an equal view on the database.

Projection views are used to hide fields of a table .

Help views can be used as selection method in search helps.

Maintenance views permit us to maintain the data distributed on several tables for one application object at one time.

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


we can create ,delete views.