12-04-2007 4:07 PM
12-04-2007 4:30 PM
<b>View</b> - A view is a virtual table containing fields from one or more tables. A virtual table that does not contain any data, but instead provides an application-oriented view of one or more ABAP Dictionary tables.
The followings are different types of views:
<b>- Database View (SE11)</b>
Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.
In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.
<b>- Help View ( SE54)</b>
Help views are used to output additional information when the online help system is called.
When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.
- <b>Projection View</b>
Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.
A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.
- <b>Maintenance View ( SE54 )</b>
Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.
Also check the below link for more details.
http://help.sap.com/saphelp_40b/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm
Regards,
Maha
12-04-2007 4:54 PM
view is logical collection of flieds from different tables,which logically in database
diff b/w views
database view:- more than one transparent table can be used.
-
>inner joins only be used.
-
>used for read only,no modifications
projection view:- only pool& cluster table
-
> only single table should be used
-
>no join conditions
-
> hide the fields
-
> read only
maintence view:
-
> more than one transparent table
-
> outer join should be used
-
> read,change,delete data
-
> maintain fields
-
> should have foreign key relation ship.
help view:
-
> more than one transparent table
-
> outer join should be used
-
> used as f4 help for fields
-
> read only
-
> should have foreign key relation ship.
12-05-2007 4:48 AM
Hi
Importance/Use of views
Join/Projection/Selection w.r.t views
Inner and Outer joins
Types of views
Database view
Projection view
Maintenance view
Help view
Importance/Use of Views
Join, Projection and Selection
View Types
Database Views
Projection Views
Maintenance Views
Help Views
Restrictions for Maintenance and Help Views
Append Views
Rewar dif usefull
12-05-2007 7:33 AM
Hi,
A view is nothing but a virtual table. You cannot store values into a view directly.
A view can be a resultant of combination of two or more table based on their join queries. Views are created to view only the required fields,the original table might contain many felds which might not be useful to you.
Please go through this link.Hope its useful
http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm
-Bhavin P Shah