data dictionary

[Former Member]

hi experts,

why we need the projection view?if we have the

database view in data dictionary.

regards,

prerna.

[Former Member]

as i know the database view can have more than one table and wr as projection view can hae only one table and which ever fields u donot need we can suppress them

mahesh.g

[Former Member]

<b>View type

Definition

The view type defines how a view is implemented and how one can access the view.

Six different view types are supported at the moment:

Database view (type D): implemented with an equivalent view on the database.

Projection view (type P): used to mask out fields from a table.

Help views (type H): used in the online help system.

Structure view (type S): used to generate a structure from the view fields. The creation of structure views is no longer supported as of Release 3.0.

Maintenance view (type C): permits a business view on data and enables maintenance of this data.

Entity view (type E): used to map entity types of the EDM to tables of the ABAP Dictionary. This view type is no longer supported as of Release 3.0.</b>

regards

Prabhu

[Former Member]

To restrict the fields and data you want to show of a table.

I don't really use since I do this directly in the program code.

Aubin

[Former Member]

<b>Database View (SE11)</b>

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.

<b>Projection View</b>

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

regards,

Bhanu.

Message was edited by:

Bhanu Priya Mylavarapu

[Former Member]

Hi,

Projection view ensure the suppression of fields during selection.Suppose we have 10 fields in a database table1 and 5 in databse table 2, but we want to select only 4 fields from table 1 and 2 fields from table 2.So we can have a projection view combining the fields to be selected from table1 and table2.

Thanks,

Rajesh Sahal

[Former Member]

Hi,

Projection view contains fields from a single table. You can write the values to them through P.View.(Option write must be ticked). Imagine you have a big table and you don't want enter data in all of the fields while creating a record. Then you can choose the set fields along with primary, you want to enter and thus easily you can maintain data entry. Also this helps in viewing the data with limited desired fields for view.

Reward, if useful.

Kiran