On this article I'm going to talk a bit about how we can enhance the search help functionality on various drop down searches on SAP. For illustration purposes we will see how a vendor can be ignored on all the drop down searches if it's marked for deletion. Same solution can be applied to other objects such as Customer, GL or Profit center etc.

Step 1

First step is to define a table view on SAP with the condition to ignore the vendor masters which are marked for deletion. this can be done using SE11.
Step 2

Once the table view is defined, create a search help using SE11 as stated below.

Assigned the table view created on step 1 to the "Selection method" on the screen and select the view fields under parameter. set the field order using "SPos (Selection position)" and "LPOS (List position)".

Save and activate the search help.

Step 3

As the last step we would need to assign the search help to the relevant object. In this case, vendor search help. Use the following menu option under SPRO for this purpose.


Assign the search help on the following screen and click on the "Param. assignment" button.
System would propose the export parameters on the screen. Accept the system proposed values and press "Copy button"

Save and activate the search help.

Now if you go to any transaction where a vendor needs to be selected, this new search help can be used. for example on FB60 click on drop down for vendor,

Hope this post would be useful to you guys. Thank you for all your support.