Making search non case sensitive

[Former Member]

Hi,

I have implemented a search help which I have copied from standard help ‘PREM’. I have created a Database view, taking that View I have created an Elementary search help and I have assign the elementary search help in the collective search help ‘ZPREM’ which is copied from ‘PREM’.  In the search help I have two fields (NACHN, VORNA), which are case sensitive fields.

How to make it Non Case Sensitive?

Regards,

Jitendra

[Former Member]

Hi,

I have implemented a search help which I have copied from standard help ‘PREM’. I have created a Database view, taking that View I have created an Elementary search help and I have assign the elementary search help in the collective search help ‘ZPREM’ which is copied from ‘PREM’.  In the search help I have two fields (NACHN, VORNA), which are case sensitive fields.

How to make it Non Case Sensitive?

Regards,

Jitendra

[former_member196651]

Hi Jithendra,

Why you had created a Z search help for PREM? If your requirement was to have an additional search help to be added to the standard one, you will be able to do it by append search help.

As far as I believe, it will not be possible to changes the case sensitiveness of the tsd. fields NACHN and VORNA.

Regards,

Abijith

[gouravkumar64]

Hi Jitendra,

Check pad_nachn domain of nachn from data element.

Lower case checked or unchecked.

Like this.

Thanks.

[Former Member]

Hi Gaurav,

The lower case checkbox is Checked.

[Former Member]

Hi Jitendra ;

The same reason for the PAD_VORNM (domain).

You should create a new domain without checked "Lower Case"

Regards.

Özgün

[Former Member]

Hi Özgün,

I created Domain and Dataelement without checking  "Lower Case" and I assigned it. it is also not working.

[dibyajeeban_jena]

Hi ,

without checking  "Lower Case" ,  any  case(upper/lower)  u are entering will be  converted to upper case internally and the respective data will be displayed .

With checking the lower case check box in domain  , u will get the  exact  case  data  in which u have entered .

but if ur requirement  is like ,   if u enter   a*  in VORNA  FIELD  and it should display

a*

A*     - ie. all the names starting with the both 'a'  or  'A'   ,   then

You can go for Search Help Exit . Inside the function module catch the  entered  name and select  required records from DB as per ur requirement and insert  result  into  RECORD_TAB[]  internal table  , having  standard search help result  list .

Regards

DJ

[dibyajeeban_jena]

Hi,,

I think u can use Search help exit function module and  translate the input value on the screen to

upper/lower case and pass  both the value as input to the search help .

Regards

DJ

[Mohamed_Mukhtar]

Hello Jitendra,

Please go through the doc  http://scn.sap.com/docs/DOC-29057 . Thanks

[Former Member]

Hi All,

Thanks for your valuable reply. Problem solved instead of 'VORNA' and 'NACHN', I used 'VNAMC' and 'NCHMC' field of PA0002 table.

Regards,

Jitendra