views

[Former Member]

Hi all

Can anybody explain this please..

the data read with database view is created in database when it is activated.and also can b buffered...

and then again it says

the data of a view is derived from one r more tables but not stored differently...

my question is is the data of a view is different from database views????

Thanks and regards

vij

[Former Member]

Hi Vijaya,

Check out the description of Database View below.

You may get your answer:

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

[Former Member]

the data read with database view is created in database when it is activated.and also can b buffered...

and then again it says

the data of a view is derived from one r more tables but not stored physically...

my question is is the data of a view is different from database views????

Thanks and regards

vij

[Former Member]

Hi Vijay,

Views will have the buffers. co we can store the data in teh buffer, if see in the Application area and the Database area, the filed sequence will differ. coming to the Database view, thie will store centraly so you can retirve the data from any client and access to all the users, this will use the Innerjoin concept when you write a Select statment in Database View

Regards

Sudheer

[Former Member]

Hi

my question is the data of a view and the database view r different?and it says data of a view cannot b stored physcially and database view is created in the database when it is activated....

Thanks and regards

vijji

[Former Member]

Hi,

We have 4 types of Views:

1) Database views

2) Projection views

3) Help views

4) Maintenance views

<b>Database views:-</b>Data about an application object is often distributed on several database tables. 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.

a database view is implemented in the database, a database view may only contain transparent tables.

<b>Projection View:-</b>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

<b>Help views:-</b>You have to create a help view if a view with outer join is needed as selection method of a search help.

<b>Maintenance views:-</b> Maintenance views offer easy ways to maintain complex application objects.

A maintenance view permits you to maintain the data of an application object together. The data is automatically distributed in the underlying database tables. The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

database view alco not contain the data physicaly, you can look at the VIEWS in se11 byselecting the View. there you can not see the data for that view, but if you write a select statment the data retrived by the corresponding tables and will be displayed, but In the DATABASE view, when you write a select statment, it wil have the buffer facility, so the data will be stored in the buffers. so no view can contain the data physicaly

Regards

Sudheer

[Former Member]

Hi sudheer

Thanks for ur excellent answer...this is what i need to understand...iam trying to reward u the points and for somereason it says that there is error..sorry for that..if u know any other way to reward points please let me know...thanks once again.

Regards

vijaya