topic Re: creating a search help in Application Development and Automation Discussions

creating a search help

Former Member — Tue, 08 Jul 2008 09:20:47 GMT

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

Re: creating a search help

Former Member — Tue, 08 Jul 2008 09:28:34 GMT

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

Re: creating a search help

Former Member — Tue, 08 Jul 2008 09:46:50 GMT

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.

Re: creating a search help

Former Member — Tue, 08 Jul 2008 10:31:46 GMT

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

Re: creating a search help

Former Member — Tue, 08 Jul 2008 10:35:05 GMT

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