views

[Former Member]

Hi friends ,

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

Thanx ,

Senthil .

[Former Member]

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

[Former Member]

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

[jayanthi_jayaraman]

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.

[Former Member]

Hi

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.

[Former Member]

Hi

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.