topic Re: Selection screen with character in Application Development and Automation Discussions

Selection screen with character

Former Member — Thu, 23 Aug 2007 02:59:54 GMT

Hi Friends,

I have a requirement like user wants to select the data based on the character field that is.,

In select option he wants to keep the character field and wants to pick data from the database table on this selection critenia.

Please tell me how to do this.

Regards,

Line

Re: Selection screen with character

kishorepallapothula — Thu, 23 Aug 2007 03:07:55 GMT

Hi Turbin,

try this.

select-options : a type c.

in start-of-selection event use a.

example.

start-of-selection.

maildt1 = a.

use this maidt1 in your select statement. Hope this will work out.

reward if useful.

all the best.

kishore.

Re: Selection screen with character

Former Member — Thu, 23 Aug 2007 07:31:34 GMT

Hiii, to get data from a database table for slection screen field which is decalred as character field for that you need to declare the selection screen field wiht the similar length if the database table field name.

for example the database table field length is 15 chars then you have to declare the selection screen text also 15 char length.

I am forwarding sample code for that.

SELECT-OPTIONS: chr(15) type c.

AT SELECTION-SCREEN ON VALUE-REQUEST for chr.

PERFORM CHR_HELP

FORM CHR_HELP

CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST'

EXPORTING

tabname = '<database table name>'

fieldname = '<Field name>'

SEARCHHELP = ' '
SHLPPARAM = ' '
DYNPPROG = ' '
DYNPNR = ' '
DYNPROFIELD = ' '
STEPL = 0
VALUE = ' '
MULTIPLE_CHOICE = ' '
DISPLAY = ' '

SUPPRESS_RECORDLIST = ' '
CALLBACK_PROGRAM = ' '
CALLBACK_FORM = ' '
TABLES
RETURN_TAB =
EXCEPTIONS
FIELD_NOT_FOUND = 1
NO_HELP_FOR_FIELD = 2
INCONSISTENT_HELP = 3
NO_VALUES_FOUND = 4
OTHERS = 5

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDFORM.

Hope it will works.

Reward points if helpful.