topic Re: SE16 Uppercase selection screen in Application Development and Automation Discussions

SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:28:29 GMT

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.

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:34:15 GMT

Hi,

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

Regards,

Nick

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:35:49 GMT

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?

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:36:25 GMT

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

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:38:45 GMT

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

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:42:27 GMT

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

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 13:58:19 GMT

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.

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 14:03:29 GMT

yes,

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

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 14:10:02 GMT

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...

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 14:15:12 GMT

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..

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 14:36:19 GMT

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.

Re: SE16 Uppercase selection screen

Former Member — Mon, 12 Oct 2009 14:43:19 GMT

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..