topic Re: uppercase lowercase problem in Application Development and Automation Discussions

uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 06:40:14 GMT

hi! to all the experts in sap

i have a weird problem, maybe it may not seems a big problem to you.

i have created a custom table called zschema in which i have a field BEZEI in which i have entered the city names like delhi mumbai newyork etc.

the main problem is that when a user enters the city name like DELHI then it is saying the entry not found.

what should i do to avoid this as i have already entered the city delhi in lowercase.

so if anyone has a solution to this problem then please let me know.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 06:46:34 GMT

Hi,

create a z-domain for the field and check the checkbox for lower-case.

whenevr user will enter the data it will take in lower case only

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 06:51:27 GMT

Create a Field exit for the screen data element FIELD_EXIT_ZXXXX , when user enters value convert

the value in FM to lower case & later it should work same...

To create Field exit use the program RSMODPRF

Devendar

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 06:51:36 GMT

thank you very much for your reply.:)

could you please tell me how can i do that.

plus i want to tell a thing also some entries of the table are like this Jammu,Patna and Goa.

so for these what should i do.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 07:18:49 GMT

thanks .but i have already created a custom table with the field bezei with 450 entries .so i just want to apply the above mentioned changes to this field only.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 07:33:04 GMT

Check the domain created for field BEZEI. Double click on the domain maintained. Check Lowercase option. Your only field BEZEI will be maintained for your case conversion

Re: uppercase lowercase problem

anjan_paul — Wed, 22 Dec 2010 07:56:42 GMT

Hi,

You can use the conversion routine in domain level and then write some code like 'TRANSLATE string TO LOWER CASE'.

Edited by: Anjan Paul on Dec 22, 2010 1:26 PM

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 08:41:33 GMT

i have checked the domain name for the field bezei

the domain is text20 and here lowercase is already selected ,

but the enduser has entered all enteries for this field like Mumbai, Delhi etc

so the main problem that iam facing now is that whenever i enter a field name like delhi it shows the entry do not exist ..so what should i do for this now.

so help me in this regard.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 08:50:23 GMT

Create a domain of your own of CHAR20 . don't check the lower case options. I tried and it work's fine.

Edited by: K.Manas on Dec 22, 2010 9:52 AM

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 08:59:37 GMT

1) Create a domain ZBUZEI.

2) Set the length as CHAR20.

3) Make a entry as Delhi.

4) Go to selection and in BUZEI field type delhi. Press F8.

Edited by: K.Manas on Dec 22, 2010 10:01 AM

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:05:21 GMT

thanks for your reply but sir as i have already told that my entries in the table are like Delhi,

so you see first letter is capital next all are small,so i request you to kindly please help me in this case so that if i enter delhi then also i can access the data as presently after applying your steps i am getting delhi changed to DELHI and when i execute it it says entry not found.

so please help mein this regard

and again thank you for your generous reply.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:12:40 GMT

now this problem is also showing in other table but that table is standard table and there i cannot change the domain there lowercase is also checked so please tell me what step can i take to solve this issue . as far as i know i need a search help exit to solve this issue but now i am clueless about what to do for this issue.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:13:43 GMT

Ravi,

Case-1

If you have text names already maintained. For Ex as Delhi in your table. You need to type as it is to retrieve that particular record.

Case-2

To resolve your issue you need to set all the texts (which are already maintained in the table) to be changed to upper case, so that you deal with that.

The only possible way is to change the texts to upper case.

You can follow the steps i mentioned for adding new records if required and translate all the maintained texts which are in table earlier to upper case.

Edited by: K.Manas on Dec 22, 2010 10:17 AM

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:18:11 GMT

i am checking this in the contents of the table

and the enduser has created the entry beginning with uppercase letter(Delhi)

so whenever i try to access field with name delhi i get no entry exist error.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:21:17 GMT

but manas sir . the table which contain the city data has around 4000 records in it beginning with uppercase letter.

so is there no way to change all entries in one strock.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:22:51 GMT

Ravi,

I did a few changes to my prior reply after checking. If already maintained as Delhi in table you need to enter as Delhi to retreive that record. Morever you have standard domain text20 which already has lower case selected.

You can create a new domain and avoid that case sign or change the maintained entries to upper case.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:30:11 GMT

manas sir thanks for your reply but the client here is having this requirement wants to enter data in any case lowercase or uppercase..and they want the data to be displayed by doing this...is there no way of solving this problem

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:33:43 GMT

or how can i change 4000 maintained entries to upper case easily .

if this is not possible then i think this is the drawback of sap...

but i have not seen such a problem in my career till now.

so no solution exist for this problem

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:40:32 GMT

Write a simple report to change the entries.

Re: uppercase lowercase problem

Former Member — Wed, 22 Dec 2010 09:41:24 GMT

See Ravi, All that depends on the domain characters that is maintained. In your case domain text20 has lower case checkbox selected.

Some of your table entries has uppercase and some with lower case text maintained as such as 4000+ entries. You can write a Z report and update all the texts to upper case , but at the same time your client wants to maintain in his way possible. Tell them about the restrictions in SE11 and how the text works.

This check box applies only to character based fields. If a string containing lowercase (as opposed to UPPERCASE) letters is valid for this domain, then this field should be checked. If the field is left unchecked, then any entries will be converted to uppercase. Note that should your input field be a key field into a table it would be wise to make sure that it's all upper case as 'this' is different to 'This' and is different again to 'tHiS' which could lead to some very confused users.....

If not, once maintained as aBcd , i need to enter aBcd to retrieve in your maintained domain case.

Edited by: K.Manas on Dec 22, 2010 10:45 AM