topic Re: need select statement in Application Development and Automation Discussions

need select statement

Former Member — Thu, 04 Jan 2007 19:03:01 GMT

hi gurus

i need proper select statement for the following

When screen loads, populate dropdown with all peripheral groups

from a table

Re: need select statement

uwe_schieferstein — Thu, 04 Jan 2007 20:28:00 GMT

Hello Mani

Define an appropriate <b>search help</b> for your peripheral groups.

If you need the dropdown list on a selection screen you can use the option AS LISTBOX for your parameter.

If you need the dropdown list on a dynpro field simply set the listbox attribute in the attributes of the dynpro field.

Regards

Uwe

Re: need select statement

Former Member — Thu, 04 Jan 2007 21:06:09 GMT

hi uwe

thanks for ur reply

Re: need select statement

Former Member — Fri, 05 Jan 2007 04:38:37 GMT

You can declare ur parameter like:

PARAMETERS:p_month(3) TYPE C AS LISTBOX VISIBLE LENGTH 5 .

data: i_values TYPE vrm_values,

wa_values TYPE LINE OF vrm_values.

*Use the Function module 'VRM_SET_VALUES' to fill values.

wa_values-key = 'Jan'.

wa_values-text = 'Jan'.

APPEND wa_values TO i_values.

wa_values-key = 'Feb'.

wa_values-text = 'Feb'.

APPEND wa_values TO i_values.

wa_values-key = 'Mar'.

wa_values-text = 'Mar'.

APPEND wa_values TO i_values.

wa_values-key = 'Apr'.

wa_values-text = 'Apr'.

APPEND wa_values TO i_values.

wa_values-key = 'May'.

wa_values-text = 'May'.

APPEND wa_values TO i_values.

wa_values-key = 'Jun'.

wa_values-text = 'Jun'.

APPEND wa_values TO i_values.

wa_values-key = 'Jul'.

wa_values-text = 'Jul'.

APPEND wa_values TO i_values.

wa_values-key = 'Aug'.

wa_values-text = 'Aug'.

APPEND wa_values TO i_values.

wa_values-key = 'Sep'.

wa_values-text = 'Sep'.

APPEND wa_values TO i_values.

wa_values-key = 'Oct'.

wa_values-text = 'Oct'.

APPEND wa_values TO i_values.

wa_values-key = 'Nov'.

wa_values-text = 'Nov'.

APPEND wa_values TO i_values.

wa_values-key = 'Dec'.

wa_values-text = 'Dec'.

APPEND wa_values TO i_values.

param = 'p_month'.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

id = param

values = i_values

EXCEPTIONS

id_illegal_name = 1

OTHERS = 2.