topic Re: help view in Application Development and Automation Discussions

help view

Former Member — Tue, 11 Dec 2007 07:05:00 GMT

Hi all.

How to use help view in program.

give me some code/syntax.

Regards

Prajwal.K

Re: help view

Former Member — Tue, 11 Dec 2007 07:07:28 GMT

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

Re: help view

former_member188829 — Tue, 11 Dec 2007 07:08:01 GMT

Hi,

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

Re: help view

Former Member — Tue, 11 Dec 2007 07:10:29 GMT

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.

Re: help view

Former Member — Tue, 11 Dec 2007 07:14:25 GMT

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...

Re: help view

Former Member — Tue, 11 Dec 2007 07:57:21 GMT

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

Re: help view

Former Member — Tue, 11 Dec 2007 08:08:01 GMT

hi subba....

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