topic Re: dropdown list from db table in Application Development and Automation Discussions

dropdown list from db table

Former Member — Thu, 14 Mar 2013 06:58:37 GMT

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 — Thu, 14 Mar 2013 12:43:31 GMT

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 — Thu, 14 Mar 2013 12:57:18 GMT

Hi,

Check this program,

demo_dropdown_list_box

Regards,

Suman

Former Member — Thu, 14 Mar 2013 15:07:04 GMT

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 — Mon, 18 Mar 2013 04:22:18 GMT

on the modulepool screen sir