problem in upper case while updatating and saving

[Former Member]

hi

i am updataing database table by module pool

but when i enter data it is working fine for caps lock up

the functionality is like that whne user enters customer number the name1 is selected from kna1 table and hte third field is emailid

the problme is that if he name1 is in small letter then the duplicate data is created one in caps lock and one in small letter in the table...

also not able to delete also the small letter once is updated in database table

regards

regards

Arora

[Former Member]

HI,

Goto that table, and Double click on the Data element, then Double click on Domain, then check whether the Lowercase Check box is checked or not, if that is checked then the Field is Case sensitive, so it will accept the Same Values in Small and Capital letters because SAP think that these both are differennt ..

Regards

Sudheer

[Former Member]

hi

the problem is like that if the name 1 which is being selected from kna1 table based on the customer number if it is in lower case then the problem arrises

and if in caps lock no problem

also i want to be same as the name 1 in kna1 so cannot change how it will store in database it should be as it is and it is updating like that only

pls suggest

regards

nishant

[suredarreddy_pulimamidi]

for this while creating while creating domain there is a one checK boxes are there sign and lowercase. select lowercase check box then while entering data into data base all values are stored as lowercase. then your problem will be sloved.

[Former Member]

Rather than KNA1-NAME1, use KNA1-MCOD1. This is KNA1-NAME1 translated to upper case (and truncated).

Rob

[Former Member]

HI rob

didnt got ur point my requiremen is to fetch name1 value from table

now the problem is that if the name1 is in lower case it is not being delted not updated in the maintainence table

whne i press enter in table maintianece in new enteries it is translated to upper case so if it is small the table contorl gives two values one of upper and one of lower and two records are created ...one lower and one upper

and i am not able to delte the lower case from table by my maintiance program also as table control is making it upper case all fields on entry or deltion or save...

how to avoid this upper case conversion...

in my table lower case is saved but i am not able to delte it after save...pls suggest

and eloborate on ur new field and i cannot chage the to new field as i have to make major changes if i change field now

regards

nishant

[Former Member]

Hi,

You are stating your problem in very ambigous way.

what is your requirement?

Do you want to read NAME1 from KNA1 in caps or in lower case?

Since you are updating the table through your own module pool program before checking anything else, check your program.

Check for the internal table that you are using to update the Database table.

Check why the internal table that is having the value is having the duplicate values.

I believe the problem is in your code itself in the first place.

Hope this helps

Regards

Nishant

[Former Member]

HI

MY PROBLEM IS like that

whne i am pressing enter or delete or save

the fields in the maintainence table is converting automatically to upper case and i have not coddes anywhere that?

as simple as th at so now the internal table has two records

one earlier one and one converted one

regards

nishant

[Former Member]

Hi nishant,

Because it is based on the domain setting of that field.

Just go to SE11 and domain of the field you want to update and go into defination tab. there is a check boxfor lower case. If it is checked then only you can update lower case values.

Regards,

Atish

[Former Member]

so atish

for updating i should check both the lower case and upper case

as for updatating database table..i need to update both upper case and lower case whatever it may be

[Former Member]

hi atish

u r saying correct but presently it doesnt matter as my records are all converted to upper case when i press enter on the screen pls suggest on this.

whne in table maintainece screen i press enter the records are conveted to upper case....all the three fields automaticall i want to avoid this it shuld not be cnverted to uppe case when pressing enter

nishant

[Former Member]

As I said earlier, MCOD1 is NAME1 translatred to upper case. If you can use MCOD1 instead of NAME1, you chore will be simplified.

Rob

[Former Member]

Dear All,

Need a small suggestion.

Currently, I have a standard SAP domain without Lower Case checkbox selected and it is storing the data with capital letters.

Now, my requirement is to store the data in Lower cases.

As per my understanding,  if we translate text LOWER Case with User exit of BADI, then also values be stored in CAPITAL letters as  the domain itself doesn't have the Lower case checkbox selected.

Please correct me if I am wrong.

My query is, what is way to convert the text in lower case for the SAP standard domains with Lower case checkbox NOT selected.

Appreciate your inputs.

Thanks and Regards

Anuja Telware