Prevent selection screen input fields conversion to upper case?

Question

I have the table with field title_medi which contains two rows like Mr. and Ms.

Also I have input field called title with search help of title_medi. When I'm selecting Mr. in the search help it gets displayed in the textfield.

If I compare that text field value with the database field. I'm getting an error.

But when I debug and see the value is somewhat getting converted to all uppercase like MR. not as exactly in the table.

Could you please help me out with this?

Solution 1

In order to solve this you have 2 options:

1. Go to the domain of the table field and check Lower case check this
2. Use TRANSLATE ABCD TO LOWER CASE before making the comparison check this

Solution 2

additional info

In HR, possible quality (Mr, Ms...) are stored in table t522. Corresponding texts are stored in T522T. The data element is ANREX, associated with the domain of same name. This domain is lower case enabled.

moreover, this also give you the person's gender.

Solution 3

I checked the data element but that is also been checked with the lower case. So what i did is i have checked the check-box for upper/lower case attribute in screen painter for the concern field. It works fine