SE16 Uppercase selection screen

[Former Member]

Hi experts,

There is a created table which name is starting with Z.

My problem is when I want to ask for the content is SE16 and write the selection criteria onto the selection screen it converts to UPPER CASE what I wrote onto the screen and did not find the record because of it.

[Former Member]

Hi,

The domain you are using for you field needs to be set for mixed case. Check the 'Lower case'.

Regards,

Nick

[Former Member]

Dear Nick,

I've already do that but it is still converting to Upper case. I think it had an maintenance view, but when I try to look at on it in SM30 then it gives me a dump. Could the problem related to maintenance view?

[Former Member]

Hi,

I guess everything needs regenerating. If SM30 is dumping (you don't specify what the dumps is) then the table could be inconsistent.

Regards,

Nick

[Former Member]

Hi ,

go to se11--> and enter yorr table and double click on the data element of your field which need to accept caps and lower case..

and next click on domain and select defination tab..and see lower case is selected or nor if selected try to uncheck and activate..

Prabhudas

[Former Member]

whats the dataelement and domain you are using? is it a zdomain?? or which one?

[Former Member]

It is a Z domain. The table is reactivated, now I can search if the lowercase flag is checked, but in other cases it doesn't work.

[Former Member]

yes,

in that z domain: is the lower case chek box is ticked?

[Former Member]

It is ticked. But if it is not ticked, that means the searc should be not case sensitive. But it did not found any records. I have no idea why...

[Former Member]

see, it depends on the dat astored..

say the check box is ticked before.. so the domain was case sensiive.. so when you enter data, its stored in the specific case..

so even when you take out the tick in 'lower case'tick box, the data in database is not going to be changed.... that is why you are not getting the required data..

so after changing the domain.. you have to fetch the ALL data once to a internal table, change the case to UPPER CASE, update the database table with these uppercase values... now the search will be case insensitive..

[Former Member]

Okay I understand what you're saying, but it was unticked all the time. And no matter how the data is stored, under- or uppercase. In se16 it should be find.

[Former Member]

just fetch the data once with select in your code and see the values... for case insensitive find data has to be stored in uppercase in database..