09-10-2008 6:52 AM
hai,
on a module pool screen i want to have a text field with drop down list box and in that i want to select set of values from the table field ie., for example empid field . whenever i update the database with new empid , i should see that one in the next screens drop down box.can anyone help me out?
Thanks & Regards,
Syam.
09-10-2008 7:50 AM
Hi,
try like this.
in screen flow logic
process on value-request.
field itab-empid module mod.
in program
define itab1 with one field.
module mod1 input.
SELECT EMPID
FROM <dbtab> INTO CORRESPONDING FIELDS OF TABLE itab1.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = 'EMPID'
dynpprog = sy-repid
dynpnr = sy-dynnr
dynprofield = 'ITAB-EMPID'
value_org = 'S'
TABLES
value_tab = itab1.
endmodule. " mod1 INPUT
Regards,
Sathish reddy.
09-10-2008 8:03 AM
Hi Syam,
No need to write code for this, just create a Search help for that Table field, attach that F4 help to the screen field and select "Display as Dropdown" in the screen painter properties window of that field.
Regards
Karthik D