topic selection screen in Application Development and Automation Discussions

selection screen

Former Member — Wed, 01 Oct 2008 05:03:32 GMT

In my selection screen there is a field REQUISNER.Wich is case sensitive .

for example:

if we put Dipak then it will take value .

If we put DIPAK or dipak he not takes any value.

I want it case insensitive .HOW.

field name: AFNAM-EKPO

description: Requisner

Re: selection screen

Former Member — Wed, 01 Oct 2008 05:05:44 GMT

Hi,

I think you will not face any problem at the selection-screen.

If you are facing any problem while processing, then you may probably think of translating the string to either uppercase or lowercase in entirety.

Regards,

Kiran

Re: selection screen

former_member156446 — Wed, 01 Oct 2008 05:10:56 GMT

this can be acheived using


PARAMETERS : pa_uex1(200) LOWER CASE.

Re: selection screen

Former Member — Wed, 01 Oct 2008 05:20:37 GMT

If you have checked the domain for AFNAM, the Lowercase checkbox is ticked.

Try looking at the following note taken from F1 help,

Lowercase letters allowed/not allowed

If this flag is set, upper case and lower case are distinguished when you enter values with screen masks.

Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

This mechansim is in effect for all the fields referring to this domain.

Re: selection screen

Former Member — Wed, 01 Oct 2008 05:26:05 GMT

Hi,

tables : ekpo.

data : itab type table of ekpo,
       wa type ekpo.
select-options : s_afnam for ekpo-afnam.


translate s_afnam-low to upper case.
select ebeln ebelp from ekpo into corresponding fields
of table itab where afnam = s_afnam-low.

Re: selection screen

Former Member — Wed, 01 Oct 2008 05:55:21 GMT

Dear

I had the same problem, and i used TRAANSLATE and solved it.

Re: selection screen

Former Member — Wed, 01 Oct 2008 05:56:50 GMT

hi,

the solution suggested by Jay Sadaram is correct.

you have to use the "lower case" addition.

and i dont think, you can make it case-insensitive because in database table it is stored in case sensitive form.

or try using the LIKE keyword in the select statement instead of "=".

Edited by: vikram shah on Oct 1, 2008 11:29 AM