Skip to Content

Introduction: This document deals with a very basic topic of Help View and step by step procedure to create it and use it in the search help. This document is useful for beginners who want to learn how to create help view.

What is Help View: Help view can be used in the search help as in the ‘Selection Method’. We can also provide database table or database view name there, but suppose if we want to get data as outer join then Help View can be provided. It uses left outer join to select the data while database view uses inner join. What it means: suppose I have two tables A and B. In help view all the contents of primary table will be displayed.

/wp-content/uploads/2012/10/1_148144.png

And also if we want to show only particular data then in the ‘Selection Conditions’ tab of the help view, we can also provide condition to select data.

       Steps: 1) How to create Help View-

i)              Go to transaction SE11

ii)             Give View Name that you want to create

iii)            Click on create button

/wp-content/uploads/2012/10/2_148151.png

                               

iv)            Now next screen appears with multiple options choose ‘Help View’ and click ‘Copy’

                        /wp-content/uploads/2012/10/3_148152.png

v)             Provide short description and enter the base table name in the tables field as in below screen shot then click on ‘Relationship’ button

On clicking of relationship button, it lists all the tables that are directly linked with the base table that we have provided.

    

/wp-content/uploads/2012/10/4_148153.png

vi)            Now select the table from the list and click copy. Join condition is populated automatically.

                                      /wp-content/uploads/2012/10/5_148157.png                          

                                  

                                                 /wp-content/uploads/2012/10/6_148158.png

vii)           In the view field we put the fields that we want to show in our view. Click on Table fields and select the table and fields.

/wp-content/uploads/2012/10/7_148159.png

/wp-content/uploads/2012/10/8_148160.png

Choose the fields that we want to include

/wp-content/uploads/2012/10/9_148161.png

viii)          Now in the ‘Selection Conditions’ tab give the selection criteria if we want  to filter on the basis of some conditions as in below screen shot

For example if we want to include only those values for which “Company code is 1000’ and ‘Item number is ‘010’ “

/wp-content/uploads/2012/10/10_148162.png

If we can give multiple conditions with the help of ‘Logical Operators’

AND=> True only in case of all the conditions are true

OR=>   True in the case if any of the condition is true

ix)            In the next tab maintenance status can be provided. In case of Help view only two options are available:

Read Only: Data can only be read

Read and change: Existing entries can be changed but deletion or insertion is not possible

/wp-content/uploads/2012/10/11_148163.png

x)             Now save /wp-content/uploads/2012/10/12_148164.png and activate /wp-content/uploads/2012/10/13_148165.png  the View.

2) Use of help view in search help:

i)              To create a search help go to SE11 and provide search help name and click ‘Create’. For  example we want to create ‘Elementary search help’

                                             /wp-content/uploads/2012/10/14_148166.png

ii)             In next pop-up choose Elementary search help. In the next screen provide short description and in the selection method input provide the name of help view. In the parameter, provide the search help parameters and provide the other properties whether it is import or export parameter their positions etc. Now Save /wp-content/uploads/2012/10/12_148164.png and activate /wp-content/uploads/2012/10/13_148165.png the search help.

                   

                        /wp-content/uploads/2012/10/15_148170.png

3. Use of search help: we can use this search help with the help of keyword ‘Matchcode object’

       /wp-content/uploads/2012/10/16_148171.png

       

Now at the selection screen when we press ‘F4’ in the select-option parameter ‘so_werks’ a list appears for which item is ‘10’ as we had given in our help view selection condition

                         /wp-content/uploads/2012/10/17_148172.png

Summary: In the above example, steps for creating help view and how to use that in search help has been explained.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply