help view

[Former Member]

Hi all.

How to use help view in program.

give me some code/syntax.

Regards

Prajwal.K

[Former Member]

Hi

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.

Go thru this link plzz

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm

Regards

Anji

[former_member188829]

Hi,

You can use the same SELECT query to View similar to a Table..

[Former Member]

Hi

Help views can be used as selection method in Search help.

Help view is created if a view with outer join is needed as selection method of a search help.

Help views are used exclusively for search helps.

A conventional database view selects data from the database using an inner join.

For a help view however, data is selected using a left outer join.

Eg-> Suppose table SCARR (Airline master table) has AA – American airlines

AB – Air Berlin

AC- Air Canada as three entries.

Table SPFLI (Flight schedule) has entries corresponding only to airlines AA (American airlines) and AB (Air Berlin).

Now if a database view were to be used as a selection method for a search help for airlines, we would only get AA and AB as possible entries because the database view implements an inner join…….If however, we were to use a help view as the selection method here, we would get AA,AB and AC as possible entries because a help view would implement a left outer join.

<b>

Restrictions for Help Views </b>

There are some restrictions for selecting the secondary tables of a maintenance view or help view. The secondary tables have to be in an N:1 dependency to the primary table or directly preceding secondary table. This ensures that there is at most one dependent record in each of the secondary tables for a data record in the primary table.

[Former Member]

guys please give code....

i have already created help view. i don't no how to use that in program.

i need syntax for this...

[Former Member]

Hi,

Hey...Just fetch records from view is just like fetch records from table.

select belnr buzei from MLHELP_PO_EKBE where..........

But, generally views will have huge no of records. Avoid select * and select with out where.

Regards,

Subbu

[Former Member]

hi subba....

am asking about help view, is database view and help view are same.