topic Re: Type-ahead in search help in ABAP code in Application Development and Automation Discussions

Type-ahead in search help in ABAP code

former_member246634 — Wed, 26 Sep 2018 09:32:01 GMT

Hi,

I've got two parameters on the selection screen in my report:

P_VBELN matchcode object Z_SH_VBELN.
P_KUNWE

There is a custom search help with custom database view assigned to P_VBELN field. Now I want to display possible values for P_KUNWE for select statement just like below:

SELECT p~kunn2, a~name1, a~name2, a~sortl
FROM KNVP AS p   
INNER JOIN vbak AS k
ON p~kunnr = k~kunnr
INNER JOIN kna1 AS a
ON a~kunnr = p~kunn2
WHERE k~vbeln = p_vbeln
AND p~vtweg = '00'
AND p~parvw = 'WE'

And I want this search help for P_KUNWE to display values based on P_VBELN and it should allow type-ahead, dynamic filtering, filtering over all fields, whatever you want to call it, just like you can set it in search help definition:

I know I can use FM F4IF_INT_TABLE_VALUE_REQUEST to display search help based on internal table, but I need that multi-column text search effect.

Thank you for your help.

Re: Type-ahead in search help in ABAP code

Muthu_raja — Wed, 26 Sep 2018 10:16:01 GMT

Hi, Did you try with Search help exit?? I think it will help you in this case.

Re: Type-ahead in search help in ABAP code

former_member246634 — Wed, 26 Sep 2018 11:31:50 GMT

So I should create custom s-help in SE11 and new function module for s-help exit? How should VBELN be passed to this module?

Re: Type-ahead in search help in ABAP code

franois_henrotte — Wed, 26 Sep 2018 12:49:57 GMT

You have several steps to do :

1) create a SH view with all the fields you need for selecting and displaying

2) be sure that the SH uses the view and that the field VBELN is a parameter of the SH

3) be sure to define the parameter on selection-screen with the same data element as VBELN in the view

No need for a SH exit, the mapping will be done automagically if the data element is the same.

Re: Type-ahead in search help in ABAP code

former_member246634 — Mon, 15 Oct 2018 13:01:53 GMT

Issue solved.

I've assigned memory parameter BLN on selection screen and used it in my custom search help: