topic Re: regarding views in Application Development and Automation Discussions

regarding views

Former Member — Thu, 02 Aug 2007 14:13:15 GMT

what are the different types of views in data dictionary and what is the purpose of each.

thanks and regards,

k.swaminath reddy.

Re: regarding views

Former Member — Thu, 02 Aug 2007 14:19:50 GMT

What is the Different Types and Usage of Views

This is often asked in an interview about the types of views:

The followings are different types of views:

- Database View (SE11)

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.

- Help View ( SE54)

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.

- Projection View

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.

- Maintenance View ( SE54 )

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.

Re: regarding views

Former Member — Thu, 02 Aug 2007 14:20:17 GMT

Hi,

Database Views:

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

Projection Views

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ecc5446011d189700000e8322d00/frameset.htm

Help Views

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ecd2446011d189700000e8322d00/frameset.htm

Maintenance Views

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

Regards

Sudheer

Re: regarding views

vikram_maduri2 — Thu, 02 Aug 2007 14:22:33 GMT

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.

In the simplest case, this derivation process can involve simply suppressing the display of one or more fields from a table (PROJECTION VIEW) or transferring only certain records from a table to the view (SELECTION VIEW). More complicated views can be assembled from several tables, with individual tables being linked using the relational join operation.

Use

Logical views for the application permitting direct access to the data can be generated with the definition of view. The structure of such a view is defined by specifying the tables and fields involved in the view.

Re: regarding views

Former Member — Thu, 02 Aug 2007 14:32:59 GMT

hi,

1) Database view.

2) Projection view.

3) Help view.

4) Maintenance view.

database view

A database view provides an application-specific view on such distributed data.

Database views are defined in the ABAP Dictionary. A database view is automatically created in the underlying database when it is activated.

Application programs can access the data of a database view using the database interface. You can access the data in ABAP programs with both OPEN SQL and NATIVE SQL. However, the data is actually selected in the database. Since the join operation is executed in the database in this case, you can minimize the number of database accesses in this way.

Projection views:

Projection views are used to hide fields of a table. This can minimize interfaces; for example when you access the database, you only read and write the field contents actually needed.

A projection view contains exactly one table. You cannot define selection conditions for projection views.

Help view

Help view You have to create a help view if a view with outer join is needed as selection method of a search help.

Maintenance views:

Maintenance views offer easy ways to maintain complex application objects.

Data distributed on several tables often forms a logical unit, for example an application object, for the user. You want to be able to display, modify and create the data of such an application object together. Normally the user is not interested in the technical implementation of the application object, that is in the distribution of the data on several tables.

more information on views follow this link..............

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

regards,

Ashok Reddy