uppercase lowercase problem

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Write a simple report to change the entries.

[Former Member]

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

[Former Member]

If you check standard table KNA1 field NAME1 you will see the same situation.

[Former Member]

cann't i change the already maintained entries to upper case and reflect this conversion in my table

and thanks manas sir and reddy sir for your reply

[Former Member]

No Ravi, You don't have any such options available in SE11. Do it by writing a Z report to update the entries in uppercase.

[Former Member]

can i create a search help exit for this problem ...

so which search help exit would be useful for it

[Former Member]

You want to place search help for BUZEI field in that table. Right? . If so you can do that and user needs to select the record required and run that.

if you want to convert into upper case for the existing records, use Z report option. Ask the functional consultants or the users what would be useful for them in future. You can find lots of table and fields behaving as such in SAP. It's not a big deal.

[Former Member]

thanks all of you for help specially manas sir.

will tell my client about the possible solution of this problem.

[Former Member]

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

[anjan_paul]

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

[Former Member]

solved and closed.