table control

[Vijay]

hi

i have a requirement to create table control with a column of drop down list i.e for that particular column user can select value from the drop down list for each record.

how can i assign values to that drop down list and how the data entered by the user will be picked and filled into the internal table to be updated in the database table.

regards

vijay

[Former Member]

Hi Vijay,

You can do this in two ways.

1.create a search help

2.Attach the search help to this table control field

3.in screen painter change the attributes of the field to "ListBox".you will get one list box instead of search help

second method

Using functionmodule 'VRM_SET_VALUES

type-pools : vrm.

parameters : p(10).

initialisation.

data: int_vrm_cnclcod TYPE vrm_values,

fs_vrm_cnclcod TYPE vrm_value.

IF int_vrm_cnclcod[] IS INITIAL.

fs_vrm_cnclcod-key = '01'.

FS_VRM_cnclcod-text = 'ssdsd".

APPEND fs_vrm_cnclcod TO int_vrm_cnclcod.

fs_vrm_cnclcod-key = '02'.

FS_VRM_cnclcod-text = 'sdsdsd '.

APPEND fs_vrm_cnclcod TO int_vrm_cnclcod.

ENDIF.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

id = 'P'

values = int_vrm_cnclcod

EXCEPTIONS

ID_ILLEGAL_NAME = 1

OTHERS = 2

.

IF SY-SUBRC 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

About your second query :

after selecting the values from dropdown list you can modify your internal table with the new value and do the updation of database with this internal table

regards

shibu

Edited by: shibuettickal on Mar 5, 2008 5:15 PM

[Former Member]

hi vijay,

u just create a search help for the required field in se11 .

and attach that search help for that field in se51 layout .