Online Tutorials & Training Materials | STechies.com
Register Login

View and Types of View

|| || 0

View and Types of View
Stechies

View in ABAP

A view is a 'virtual table' containing fields from one or more tables.

A view is a logical view on one or more tables. A view on one or more tables i.e, the data from a view is not actually physically stored instead being derived from one or more tables. A view can be used to summarize data which is distributed among several tables

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

A view is based on a table or another view and acts as a window through which data on tables can be viewed or changed. A view does not contain data. The definition of the view is stored in the data dictionary. You can see definition of view in user_view data dictionary table.
more view options are... these..

  • Can be simple view, based on one table
  • Can be a complex view based on more than one table or can contain groups of functi.ons
  • Can replace other view with same name
  • Can contain a check constraint
  • Can be read-only

Different Type of View in ABAP

Selection Views are a collection of fields from different database tables. You can create them in the Repository Browser or the Logical Database Builder in the ABAP Workbench. A virtual table that does not contain any data, but instead provides an application-oriented view of one or more ABAP Dictionary tables.

You can define joins between database tables statically and system wide as views in the ABAP Dictionary. ABAP Dictionary views can be used by all ABAP programs. One of their advantages is that fields that are common to both tables (join fields) are only transferred once from the database to the application server.

Views in the ABAP Dictionary are implemented as inner joins. If the inner table contains no lines that correspond to lines in the outer table, no data is transferred. This is not always the desired result. For example, when you read data from a text table, you want to include lines in the selection even if the corresponding text does not exist in the required language. If you want to include all of the data from the outer table, you can program a left outer join in ABAP.

  • Projection View - Just retrieves some fields from a single table.
  • Help View - This is used for search help.
  • Database View - This is inner join view of one or more tables.
  • Maintenance View - Helps in creating maintaining data of the application object. The data can be distributed among several tables.


Related Articles

0.0126 seconds.