SAP VIEWS

What is SAP View?

Ans: Data about an application object is often distributed on several tables. By defining a: view, you can define an application-dependent view that combines this data. The structure of such a view is defined by specifying the tables and fields used in the view. Fields that are not required can be hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.

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

In First Step of a view definition the base tables of the view must be selected.

In Second Step these base 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.

In Third Step you must select the fields of the base tables to be used in the view. Selection conditions that restrict the records in the view can be formulated in the fourth step.