dropdown list from db table

[Former Member]

Hi gurus,

i want to display a drop down list which is a table containing single field. is it possible. pls guide me to complete my task.

Thanks in advance.

[Former Member]

yes its possible.

PARAMETERS: name1 AS LISTBOX visible  length  45  .

   data :
         ITAB TYPE VRM_VALUES,
         WTAB TYPE VRM_VALUE.

AT SELECTION-SCREEN OUTPUT.

loop at int_urtab into wa_urtab. int_urtab = which contains data of single field.

   WTAB-TEXT = wa_urtab-fieldname.
    APPEND WTAB TO ITAB.

endloop.

call function 'VRM_SET_VALUES'
exporting
ID = 'NAME1'
VALUES = ITAB.

It will work.

[Former Member]

Hi,

Check this program,

  demo_dropdown_list_box

Regards,

Suman

[Former Member]

Hello, Enoch,

  where you want your drop down list?? tarak has given a solution on selection screen parameter....

but where you want???

Thanks

Sabyasachi

[Former Member]

on the modulepool screen sir