Examples for Views

[Former Member]

Hai All,

Can any body please send me examples for all Types of Views(Database,mainteneace,help,projection)

thanks in advance

Ranjith

[Former Member]

<b>Projection</b>

Sometimes some of the fields of the tables involved in a view are not of interest. The set of fields used in the view can be defined explicitly (projection).

<b>Selection Conditions</b>

Selection conditions that are used as a filter can be defined for a view.

Restrictions can be defined for the contents of the view fields in selection conditions. In this case, only the data records that satisfy these restrictions can be selected with the view. In a selection condition, the contents of a view field are compared with a constant using a comparison operator. Several selection conditions can be linked with the logical operators AND and OR

For more Help on this

[Former Member]

Hi Ranjith,

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.

- Help View ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- Projection View

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.

- Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

Thanks

eswar

[Former Member]

Hi

thanks for information I want examples can you please give me examples for views (Help, maintenence, database)

I here there is even strucute view Am i right

Ranjith

[Former Member]

Ranjith,

Goto SE11, press F4 on Views, u wll get lot of standards view.

Example:

IFLO

V_DEVGART

V_EWU_AFVC

V_EWU_ANIA

V_EWU_ANIB

V_EWU_ANLV

V_FORM4

V_FORM5

V_FORM6

V_FORM_2

V_GART2

V_GART4

V_GART5

V_GART6

V_GARTB4

V_GARTB5

V_GARTB6

V_GART_OV_6

V_GTYP

Regards,

Prakash.

[Former Member]

Database view -

---

> /BEV1/EMBWDP_A

Maintenance view --> V_AAACC_EXCL_01

[Former Member]

Hi Ranjith,

goto the view DD25VVT and check the field VIEWCLASS which is the type of the view

[Former Member]

Hi Ranjith,

goto the view DD25VVT and check the field VIEWCLASS which is the type of the view

Help view

Database view

projection view

structure view

maintenance view

Entity view

view variant

append view

[Former Member]

descriptions of those...........

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.

- Help View ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- Projection View

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.

- Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

[Former Member]

Hi,

example in se11

mainteneace view - v_159r

Database view - AFVCP

Projection view - AFFWRM

Help view - H_APADEF

Regards

amole