topic Re: Differences in Application Development and Automation Discussions

Differences

former_member778253 — Sun, 08 Jul 2007 15:19:09 GMT

Hi,

What is the difference between VIEW (&) TABLE?

Re: Differences

former_member189059 — Mon, 09 Jul 2007 06:22:12 GMT

The central data structure of the ABAP/4 Dictionary is the<b> table</b>. A table consists of a list of fields.

A<b> view</b> can be tailored to the needs of a specific application, making it possible to directly access specific data. The structure of such a view is defined by specifying the tables and fields to be contained in the virtual table.

A view can be used to summarize data which is distributed among several tables. In addition, superfluous fields can be suppressed, keeping interfaces to a minimum.

A view relates logically to one or more tables. That is, the data of a view is not actually physically stored. The data of a view is instead derived from one or more other tables.

Re: Differences

Former Member — Mon, 09 Jul 2007 06:27:53 GMT

Hi,

database view is a logical defination of table it does not exists physically in the database. it gets its value from the database depending on its defination. and joins used.

database table pysically exists in the database and contains data.

****do reward if usefull

vijay

Re: Differences

Former Member — Mon, 09 Jul 2007 06:28:13 GMT

hi ,

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

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.

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

regards

reena

Re: Differences

Former Member — Mon, 09 Jul 2007 06:29:37 GMT

Tables : These are the data holders we can store the data inside.

views : these are virtual tables we are going to show data with respect to tables in views .