hi, difference between database view and elementary search help

[Former Member]

hi

pl. can any one tell me the difference between

database view and elementary search help,

and help view and elementary search help,

and database view and help view.

in the output i do not see any difference.

thanx.

rocky robo

[anversha_s]

hi,

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.

Rgds

Anver

[Former Member]

Database view is formed on two tables to get the data for processing.

Search help view is used to get additional data when F4 is pressed.

Regards,

Vaibhav B Gawali

[Former Member]

HI ,

A <b><i><u>database view</u></i></b> is defined in the ABAP Dictionary as a logical view on one or more tables. A database view is automatically created in the underlying database when it is activated.

An <i><b><u>elementary search help</u></b></i> defines the standard flow of an input help. You can define the following components of this flow in the search help:

where does the data displayed in the hit list come from (selection method)

what information should be displayed in the dialog box for value selection and in the hit list (search help parameters)

what field contents can be taken into account for hit list selections and which values in the hit list can be returned to the screen fields (search help parameters)

what dialog steps should be executed in the input help (dialog behavior)

The <u><i><b>Help view</b></i></u> provides user assistance inside the Workbench. The view consists of four pages providing user assistance. Each page presents help topics in a slightly different fashion.

[Former Member]

HI

An entire table can be included in a database view. In this case all the fields of the included table will become fields of the view (whereby you can explicitly exclude certain fields). If new fields are included in the table or existing fields are deleted, the view is automatically adjusted to this change.

Database view:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm</a>

Elementary search help:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ee38446011d189700000e8322d00/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ee38446011d189700000e8322d00/frameset.htm</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/8b/415d363640933fe10000009b38f839/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/8b/415d363640933fe10000009b38f839/frameset.htm</a>

Help view:

Help views are used if a view with an outer join is needed as selection method in a search help.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/42/81c1351181b73fe10000009b38f839/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/42/81c1351181b73fe10000009b38f839/frameset.htm</a>

Regards,

Gunasree

[former_member842213]

DATA BASE VIEW:is used to fetch contents from more than one table using a inner join

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.

An elementary search help defines the standard flow of an input help. You can define the following components of this flow in the search help:

where does the data displayed in the hit list come from (selection method)

what information should be displayed in the dialog box for value selection and in the hit list (search help parameters)

what field contents can be taken into account for hit list selections and which values in the hit list can be returned to the screen fields (search help parameters)

what dialog steps should be executed in the input help (dialog behavior)

[Former Member]

Database views should be created if want to select logically connected data from different tables simultaneously. Selection with a database view is generally faster than access to individual tables.The view avoid innerjoin in our coding and When selecting with views, you should also ensure that there are suitable indexes on the tables contained in the view.U can add create a record to a data base view.

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

Searc help.

An elementary search help defines the standard flow of an input help. You can define the following components of this flow in the search help:

where does the data displayed in the hit list come from (selection method)

what information should be displayed in the dialog box for value selection and in the hit list (search help parameters)

what field contents can be taken into account for hit list selections and which values in the hit list can be returned to the screen fields (search help parameters)

what dialog steps should be executed in the input help (dialog behavior)

with regards

prince elvis

[Former Member]

Hi,

Database view is basically meant for Reporting purpose

Search Help is meant for Value help (F4) functionlaity.