07-09-2008 11:03 AM
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
07-09-2008 11:54 AM
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..
07-09-2008 12:04 PM
Hi Sravanthi ,
is it possible to use normal search help with parameter?
or their is no way to pass parameter to search help?
07-22-2010 8:25 AM