Getting Started with ABAP: How to Create Help View and Search Help Part 1
This is the next blog post in this series. Here is the previous blog post Getting Started with ABAP: How to Create Maintenance View
In the previous blog post, we learned how to create maintenance view.
In this blog post we will learn how to create help view and elementary search help.
What is Help View?
Help view is used as selection method in search help. Help view implements left outer join, which means that view will contain all data of primary table.
Two table must be joined using foreign key. The same restrictions apply when selecting secondary tables of a help view as to maintenance view.
How to Create Help View
Step 1: Go to SE11. Select View and enter view name that you want to create.
Step 2: Click on create. Select Help View.
Step 3: Enter short description.
Step 4: Here my creating help view on two tables.
Enter first table name in table column.
Step 5: Click on Relationships. You will get below window. Select second table.
Step 6: Join condition will get added.
Step 7: Click on View Fields. Click on Table Fields.
Step 8: Select fields from first table.
Step 9: Similarly select fields from second table.
Step 10: Save and Activate it.
What is Search Help?
Search help is the object which is used provide input help (F4 help) to screen fields.
How to use help view in search help?
There are two types of search help we can create.
- Elementary Search Help
- Collective Search Help
How to create Elementary Search Help?
Step 1: Go to SE11. Select Search help and enter search help name that you want to create.
Step 2: Select elementary search help.
Step 3: Enter short description.
Step 4: In selection method you can give table name or help view name.
Here I will give help view name which is created earlier.
Step 5: In Search help parameter click on icon.
Step 6: You will get all fields of the view.
Step 7: Select field from the list. In my search help I want 4 fields that is employee id, department id, designation, and employee name.
Step 8: Set LPos and SPos.
What is LPos and SPos?
LPos is the list position. Field position in the hit list of an elementary search help.
For example, if I give LPos as 1,2,3,4 for Employee id, employee name, department id, and designation respectively.
Save and activate it.
Execute it. You will get below output.
Press F4. You will get search help. You can see that employee id, employee name and other two fields are at 1st, 2nd position when list is display.
If I change LPos like 4,3,2 and 1.
Then you will get below output.
Then press Enter.
SPos is the screen position. Field position in dialog box of an elementary search help.
Put SPos position as 1,2,3 and 4.
Execute. Press on arrow just beside Restrictions.
This is SPos.
What is IMP and EXP parameter?
When we select it, we pass the value which is enter for that field will get imported to search help.
For Example, select IMP parameter for Employee id and employee name.
I enter employee id value and press enter. Only that particular row will be display in search help based on value provided for employee id. Because employee id is an import parameter.
When we select it, we get the value from search help.
For Example, select EXP parameter for all 4 fields.
Enter employee id and press enter.
When you click on entry, all fields value from search help will be exported to fields.
Here we have completed elementary search help.
Here you can check next blog post Getting Started with ABAP: How to Search Help Part 2
Follow my profile to be notified of the next blog post. Please feel free to ask any questions you have in the comments section below.