how to make drop down list

[Former Member]

Hi All,

I have a database table of employee names. I have to make a drop down list of all those names in web page. Can anyone tell me how to do this?

regards,

Vinita

[Former Member]

Hi All,

I have a database table of employee names. I have to make a drop down list of all those names in web page. Can anyone tell me how to do this?

regards,

Vinita

[Former Member]

hi

hope this will help your problem.

reward if help.

REPORT zwa_test2.

TYPE-POOLS : vrm.

tables: bkpf.

DATA : values TYPE vrm_values.

DATA : wa LIKE LINE OF values.

PARAMETERS : list_box(10) TYPE c AS LISTBOX VISIBLE LENGTH 10.

PARAMETERS: dd type bkpf-BSTAT user-command abc.

select-options: a for bkpf-bukrs MODIF ID buk.

select-options: b for bkpf-belnr MODIF ID SEL.

at selection-screen output.

If list_box = 2.

loop at screen.

if screen-group1 = 'SEL'.

screen-input = 0.

modify screen.

endif.

endloop.

endif.

INITIALIZATION.

wa-key = '1'.

wa-text = 'Orange'.

APPEND wa TO values.

wa-key = '2'.

wa-text = 'Red'.

APPEND wa TO values.

wa-key = '3'.

wa-text = 'Blue'.

APPEND wa TO values.

wa-key = '4'.

wa-text = 'Gray'.

APPEND wa TO values.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

id = 'LIST_BOX'

values = values

EXCEPTIONS

id_illegal_name = 1

OTHERS = 2.

Ref Program: DEMO_DROPDOWN_LIST_BOX

Link:

[Former Member]

hi

hope this will help your problem.

reward if help.

REPORT zwa_test2.

TYPE-POOLS : vrm.

tables: bkpf.

DATA : values TYPE vrm_values.

DATA : wa LIKE LINE OF values.

PARAMETERS : list_box(10) TYPE c AS LISTBOX VISIBLE LENGTH 10.

PARAMETERS: dd type bkpf-BSTAT user-command abc.

select-options: a for bkpf-bukrs MODIF ID buk.

select-options: b for bkpf-belnr MODIF ID SEL.

at selection-screen output.

If list_box = 2.

loop at screen.

if screen-group1 = 'SEL'.

screen-input = 0.

modify screen.

endif.

endloop.

endif.

INITIALIZATION.

wa-key = '1'.

wa-text = 'Orange'.

APPEND wa TO values.

wa-key = '2'.

wa-text = 'Red'.

APPEND wa TO values.

wa-key = '3'.

wa-text = 'Blue'.

APPEND wa TO values.

wa-key = '4'.

wa-text = 'Gray'.

APPEND wa TO values.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

id = 'LIST_BOX'

values = values

EXCEPTIONS

id_illegal_name = 1

OTHERS = 2.

Ref Program: DEMO_DROPDOWN_LIST_BOX

Link:

thanks

swaroop

[Former Member]

This may help u.

In screen painter for a input/output field parameetrs give

NAME like SPFLI-CARRID (tablename-dataelement) and for dropdown choose listbox.

tick check box in attributes-dict-from dictionary.

u will get all employee names in this list box.

I

[Former Member]

Thanks,

But i need to code in BSP applications.

Regards,

Vinita

[Former Member]

HI

If you are using MVC, then you need to have me->dispatch_input( ). statement in DO_REQUEST method to trigger the event. Make sure that you have this.

Checkif you use Submit button, is it triggering the DO_HANDLE_EVENT?

Your DO_HANDLE_EVENT code should look like:

check htmlb_event_ex is bound.

case htmlb_event_ex->event_server_name.

when 'YOUREVENTNAME'.

...

endcase.

Regards

Pavan