Search help - Not to display Duplicate Values

[Former Member]

Hi experts,

I have one query related to Search help.

I created one elementary search help.

But the problem is in my ztable 3 fields are primary keys. but for search help i

have two display only two fields..

example

field1 field2 field3 contains the following data

1 1 1

1 1 2

2 2 2

2 2 3

but my output for f4 help is based on field1 and field2 so the output getting like

field1 field2

1 1

1 1

2 2

2 2

now the problem is that i don't want to display the duplicate entries comparing to search help

How??????????

Thanx in advance.

Laxmi

[Former Member]

Hi

Create a Z table with the first 2 fields of your table

and write a small program to populate this Ztable with the data that is fetched from your table and deleting the duplicate values from the internal table and update this ztable with the correct data of the 2 fields

then create an elementary search help with this table and use the 2 fields

then use that search help

Because when there are 3 primary key fields in your table if you create with 2 fields then it looks wrong values.

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Hi ,

Thanks for replay.

every day so many values may be enter in the main table then how do i update the data base table every day.

is there any other solution for that

[Former Member]

you can use a exit help.

In se11 in you search help, you can put you own function module (copied from F4IF_SHLP_EXIT).

there you can detele (by coding) duplicates.

bye

enzo