topic Re: View and join Table in Application Development and Automation Discussions

View and join Table

Former Member — Wed, 04 Jul 2007 06:16:02 GMT

Hi,

what is the differnce between view and join table

Re: View and join Table

Former Member — Wed, 04 Jul 2007 06:19:22 GMT

Hi Rams,

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.

note:

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

Thanks,

Reward If helpful.

Re: View and join Table

sridevi_p — Wed, 04 Jul 2007 06:20:44 GMT

Hi,

Join - To fetch data from more than one table

View - It is usually created with the intention to reduce the lead time for fetching thedta. The view can be a single table or based on join.

View as such does not hold any data. The SQL statement used to create view is compiled and avaialble in the DB. Hence data fetch will be fast.

Usually the SQL tables that are most frequently used will be created as view and stored.

REgards,

Sridevi

<i><b>Pls. assign points, if useful</b></i>

Re: View and join Table

Former Member — Wed, 04 Jul 2007 06:20:58 GMT

Hi,

There are 4 types of views in SAP.

Database View - To club more than one table

Projection View - To hide fields in one table

Maintenance 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 performance 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.

Note:

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

For More Info,go thru this Threads,

Regards,

Padmam.

Re: View and join Table

Former Member — Wed, 04 Jul 2007 06:24:19 GMT

Hi,

Both views and joins are used to select the data from two or more tables,

JOINS help us to retrieve the data from the database, i.e., in the select query after using joins we get combined data. This is done in SE38.

but through VIEWS we can select the data which is already combined at the dictionary level. This is done in SE11.

Regards,

Pavan P.