HI
database views and maintanace views
<b>Importance/Use of Views</b>
Data for an application object is often distributed on several database tables. Database systems therefore provide you with a way of defining application-specific views on the data contained in several tables. These are called views.
Data from several tables can be combined in a meaningful way using a view (join). You can also hide information that is of no interest to you (projection) or only display those data records that satisfy certain conditions (selection).
A view is a logical view on one or more tables, that is, a view is not actually physically stored, instead being derived from one or more other tables.
The data of a view can be displayed exactly like the data of a table in the extended table maintenance.
Bluesky
