Basic Difference b/w Projection adn database view

[Former Member]

Sir.. one thing..we can also make Database view using One table and have also flexibility to update.. means we can do everything using database view which we do in projection view addition to that in database view we can also use more than one table...

Is there anything specific in Projection view that is not in Database view ?

Otherwise why I use projection view instead of database view?

[nishanthbhandar]

Hi Saurabh,

Dont know whom u r referring to as SIR..anyways here is the basic difference b/w database view and projection view for your info.

Database views are implemented by 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.

Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

Hope this helps.

Cheers

Nishanth

[Former Member]

Hi,

Both projection & database views can be created from one database table, but the basic difference is, in the case of Projection views you cant define any selection conditions ( Restrictions to table type, when you create the projection view from se11 tcode, you find the select conditions tab is not available ), whereas in the case of database view restrictions can be defined. Now you will have to decide based on your requirement whether to go for Projection view or database view.

Rgds,