topic Re: views in Application Development and Automation Discussions

views

Former Member — Thu, 30 Nov 2006 06:57:58 GMT

Hi friends ,

i want to know the details about views . It will increase the performance ? . Is it better than for all entries ?

Thanx ,

Senthil .

Re: views

Former Member — Thu, 30 Nov 2006 07:00:59 GMT

Views are the join of some tables. Definitely it is better than for all entries

Re: views

Former Member — Thu, 30 Nov 2006 07:03:37 GMT

Hi,

There are 4 types views are avilable in SAP.

Database View - To club more than one table

Projection View - To hide fields in one table

Maintanance View - To maintain database records in table

Help View - To provide help for a fields (Same functionality as Search help. This is outdated)

View are improves perfromance in the following aspects

1. If you want to use more than two table in 'JOIN' condition better to use Views . It will improves performance of a program

2. If you want to use mutiple FOR ALL ENTRIES clause, better to club all SELECT statement in a view.

Regards

Bhupal Reddy

Re: views

jayanthi_jayaraman — Thu, 30 Nov 2006 07:04:28 GMT

Hi,

If you are using database view for 2 tables(only transparent table is allowed),then it will react as inner join.It will fetch the data faster.

Re: views

Former Member — Thu, 30 Nov 2006 07:09:25 GMT

senthil

1.Views does not contain data in it. It fetches data from the database only depending on the condition ...

2.Views are part of data dictionary. They are a window to view the data in database

3.views can be used to give security to data. users can be allowed to view only basic data only

check this

https://forums.sdn.sap.com/click.jspa?searchID=234671&messageID=2590691

-charitha.

Re: views

Former Member — Thu, 30 Nov 2006 07:29:46 GMT

Based on the requirement you need to decide wether to create a VIEW or program FOR ALL ENTRIES. You can create a view for two database tables but you can use for all enteris in a SELECT query with an internal table.

Click the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea0b446011d189700000e8322d00/frameset.htm

Regards

Surya.