‎2007 Feb 01 3:37 AM
Hi,
I have created a search help where the selection method is a custom table. The field i use as parameter from this table are not unique/distinct. say it has values like A
A
B
But i require my search help to display the distinct values only - say
A
B
How can i achieve it ? Any suggestions plz.
Thanks in advance,
Asha
‎2007 Feb 01 3:47 AM
Hi,
As far i know, cant able to create a standard serach help with distinct values with reference to the table...
Rather u use the F.M
<b>F4IF_INT_TABLE_VALUE_REQUEST</b>
in ur program and use the select statement to get te distinct values u want and pass it to a internal table.. and then pass that table to this F.M.
This will do...
Cheers,
SImha.
‎2007 Feb 01 3:47 AM
Hi,
One way is to use a HELP VIEW instead of your custom table which has duplicate values. ONe more thing you can do is use a search help exit to filter the values. I dont think there is any way that you can filter values in the search help.
Regards,
Sesh
‎2007 Feb 01 4:01 AM
Thank you for your replies .Actually since i require this search help in my ALV - created using CL_GUI_ALV_GRID , it will be more helpful if i can perform the check at the table level rather than at program level . Can anone suggest me how to use the search help exits , if i can accomplish this functionality ?
Thanks,
Asha
‎2007 Feb 01 4:05 AM
Hi,
See the following search help it has a search help exit.
PREM.
Also by creating a helpview based on your table and then using that to create your own search help will also solve your problem. This will not have any program code but everything will be done by your helpview.
Regards,
Sesh
Message was edited by:
Seshatalpasai Madala
‎2007 Feb 02 5:08 AM
Hi,
You can check FM 'F4IF_SHLP_EXIT_EXAMPLE.' for pointers.
This will help you.
Regards
Nishant
‎2008 Sep 24 5:25 PM
Hello Asha,
you can use Search Help Exit: C140_DELETE_DUPLICATES.
best regards,
Andri