topic Re: in modulepool list box in Application Development and Automation Discussions

in modulepool list box

Former Member — Wed, 10 Sep 2008 05:52:08 GMT

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.

Re: in modulepool list box

Former Member — Wed, 10 Sep 2008 06:50:19 GMT

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.

Re: in modulepool list box

Former Member — Wed, 10 Sep 2008 07:03:40 GMT

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