topic Re: Regarding parameterise search help in Application Development and Automation Discussions

Regarding parameterise search help

Sidh_M — Wed, 09 Jul 2008 10:03:21 GMT

Hi Experts,

i have two fields on screen dept and employee. Now i wanted to provide search help for employee field. but depending upon value entered in dept field. means if dept has value FMD then all employees under this department should be displayed in search help. i have done this at run time in flow logic as follows known as input help

FIELD dept SELECT * FROM zempmast

WHERE name = emp_name

AND dept = emp_dept.

it works fine but the only limitation is both fields should be key fields.

how can we achieve this using search help created under se11?

Thanks & Regards,

SUDHIR MANJAREKAR

Re: Regarding parameterise search help

Former Member — Wed, 09 Jul 2008 10:54:20 GMT

use f4 function module 'F4IF_INT_TABLE_VALUE_REQUEST'

here in this function module :

pass the field for which u want f4 help to retfield: example: 'PCODE'

didc_structure = 'ur z table ..'

to value_tab u write a select quiry into a table satisfying ur condition and pass here .......

FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

ddic_structure = 'ZPCODE'

retfield = 'PCODE'

TABLES

value_tab = it_pcode

return_tab = t_return

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ELSEIF sy-subrc = 0.

READ TABLE t_return INDEX 1.

o_s_pcode_low = t_return-fieldval.

ENDIF.

like wise for which ever field u want do this.....

under at selection screen on field event.

reward points if useful..

Re: Regarding parameterise search help

Sidh_M — Wed, 09 Jul 2008 11:04:09 GMT

Hi Sravanthi ,

is it possible to use normal search help with parameter?

or their is no way to pass parameter to search help?

Re: Regarding parameterise search help

Sidh_M — Thu, 22 Jul 2010 07:25:00 GMT

answered