2010 Apr 12 11:51 AM
Hello experts,
I have a selection-option field which is description (text) and I dont want to be case sensitive!
For example this is what I enter: NAME : Mous*
And if I put NAME : mOUs* it doesnt bring the same results!!!!
Generally I dont want the name field to be CASE SENSITIVE!!!!
THANK YOU!!!!
Nick
2010 Apr 12 11:55 AM
Hi,
first explain how you defined that field. If it is a reference to a table field, which in time is case sensitive, there´s nothing you can do against that.
You could work with TRANSLATE xxxxx TO UPPER/LOWER CASE but as I mentioned, if information is saved in the database as case sensitive, this will not be of help.
2010 Apr 12 12:04 PM
This can be maintained at the domain level..look for a domain and check the check box lower case.
search for a data element with such a domain.....and then assign that to your field.
regards,
kushagra
2010 Apr 12 12:06 PM
2010 Apr 12 12:17 PM
HI,
Domain for this field is TEXT40 and for this lower case check box is check, so it will recognize upper and lower case. User type CHAR40 insted of this.
2010 Apr 12 12:27 PM
Hi ,
Please check the sample code
PARAMETERS: p_name TYPE char40 LOWER CASE.
TRANSLATE p_name TO UPPER CASE.
write: p_name.
BR
Subhankar
2010 Apr 12 12:35 PM
Hi,
I had a very similar requirement.
Then I declared my Select option Name fields of type p0002-nchmc and p0002-vnamc.
Description for this fields in SE11 :
Last Name (Field for Search Help) and First Name (Field for Search Help).
This solved the 'Case Sensitive' Issue. Try it out.
And also used UPPER CASE Translations..
Thanks
Meenakshi