Hi, I provide training in SAP UI5. Also feel free to checkout my new web page https://saptechblog.com
ABAP

Help view

The selection method of a search help is either a table or a view. If you have to select data from several tables for the search help, you should generally use a database view as selection method. However, a database view always implements an inner join. If you need a view with outer join for the data selection, you have to use a help view as selection method.

 

 

clip_image002

 

Refer to SAP link

 

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecd2446011d189700000e8322d00/content.htm

 

Pre-requisites:

 

To create a help view, a view with a outer join is required as selection method for a search help.

 

 

Step 1: Go the SE11 tcode and enter the name for the view and click on create.

clip_image004

 

 

Choose the help view and press enter.

 

clip_image006

 

 

 

Step 2: Enter the short description, and choose the table name.

 

All the tables included in a help view must be linked with foreign keys. Only foreign keys that have certain attributes can be used. The first table to be inserted in the help view is called the primary table of the help view. The tables added to this primary table with foreign keys are called secondary tables.

 

For maintenance and help views, there are certain restrictions on the foreign keys with which the tables can be included in the view  The foreign keys violating these conditions are displayed at the end of the list under the header Relationships with unsuitable cardinality.

 

Note: In a help view, Table definition and join relationship is possible only via relationships.

 

clip_image008

 

 

Step 3: Click on the relationship button and choose the relationship between the table which you want to create.

 

clip_image010

 

System will propose the keyfield relationship.

 

clip_image012

 

Step 4: In the select conditions tab, formulate the condition for which your view wants to display the data.

 

clip_image014

 

Step 5: In the maint.status tab select the setting you want to keep for your view.

 

clip_image016

 

 

Save and activate the view. View has been activated and can be used as a selection method in a search help.

 

About Arun

0 Comments:

Post a Comment

Powered by Blogger.