08-04-2008 1:20 PM
Hi Friends,
I have created a search help and attached the same to a ztable for a particular field. When I use this field in the selection screen and click on the list of values button, the values are displayed in duplicates ie., the values of the entire table is getting displayed.
Kindly guide me as to how display unique values in the list of values.
TIA.
Regards,
Mark K
08-04-2008 1:23 PM
Hi,
if the field is not a key field to which you hav attached, i Think, The problem will be there.
we generaly attach search Help to Key fields. if you do not want the duplicate values, you better declair the field as key field.
Regards,
Anirban
08-04-2008 1:23 PM
Hi,
if the field is not a key field to which you hav attached, i Think, The problem will be there.
we generaly attach search Help to Key fields. if you do not want the duplicate values, you better declair the field as key field.
Regards,
Anirban
08-05-2008 7:38 AM
08-05-2008 7:41 AM
Hi Mark,
Create the search help with only Key Fields. They are uniqiue.
If you go with non-primary keys, you may get more than one possible values for a fields.
Regards,
Chandra Sekhar
08-05-2008 7:44 AM
Hi MARK K,
I think the database table in your search help is not a master table. just check it once if i am correct in the table also it contains duplicate values that is the reason you are getting like that.
Regards,
Mahi.
08-05-2008 7:45 AM
Mark,
If you are asking about a custom search help, then you can create a search help exit function module (which has the same interface as function module F4IF_SHLP_EXIT_EXAMPLE) and within it put the following code.
CASE callcontrol-step.
WHEN 'DISP'.
SORT record_tab.
DELETE ADJACENT DUPLICATES FROM record_tab.
ENDCASE.
Then attach the exit function module to the search help - Goto Definition Tab of the search help from SE11 and maintain FM in Search Help exit field.
Hope this helps.
Amit.
08-05-2008 8:00 AM
if u r working with ztable then u can create ur own z serch help in se11 for that field.
Jitendra