creating a search help

[Former Member]

hi,

i am creating a search help based on a column's table.

This column contain 71000 rows with 3 values, when i check the search help i get 71000 rows with hthe 3 values. What can I do in order to create a search heko based on this column that will contain only these 3 values??

thanks

Ami

[Former Member]

hi

check this link hope it will be helpfull to u

Check the link below for creating collective search help

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ee86446011d189700000e8322d00/content.htm

Check the ink below for creating elementary search help

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21ee5f446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/3d/e53642e2a3ab04e10000000a1550b0/content.htm

Cheers

Snehi

[Former Member]

Hi,

As i understood the question, the search help is showing repeated values.

use a select query to get all the data into an internal table, delete duplicates in itab and call the FM for F4 help passing itab.

regards,

teja.

[Former Member]

Hi

Move those values to an internal table and select distinct values from that internal table. Pass the itab to the function module F4IF_INT_TABLE_VALUE_REQUEST

Try this one...

select distinct field from ztab into table itab.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'FIELD'

dynpprog = 'ztest'

dynpnr = '1000'

dynprofield = 'P_PAR'

value_org = 'S'

window_title = 'XYZ'

TABLES

field_tab = t_fldtab

value_tab = itab

return_tab = return

dynpfld_mapping = t_dynmap.

READ TABLE return INDEX 1.

p_par = return-fieldval.

Regards

[Former Member]

hi,

In order to create COLUMN based Search Help you have to write a SELCET statement and selecting the values for that particular column only. Put that data inot an internal table and then pass that data into the search help Function Module.

Hope this will Help.

Regards

Sumit Agarwal