Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

adding entries to table

Former Member
0 Kudos

how can i add new entries into a table without converting the value to upper case?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

it doesnt have a checkbox. i dont need to translate the string into upper/lower case. i just wanted it to be added as how the user typed the text.

8 REPLIES 8

Former Member
0 Kudos

If table field type has declared as CHAR4 then you pass either upper case / lower case, so you no need to convert them.

Former Member
0 Kudos

Hi,

I dont think so you can do so...directly as tables convert them into the lower case...

But if this is a custom table, you can add an event before save : 01(SE10->Table maintenance->enviroment->events->new entries->01->form save->)

In the form save, write the code to convert the data into lower case...

Hope this helps you

Regards

Shiva

Former Member
0 Kudos

i make the entries in sm30. i want my entries to be added in the table as it is. but the system converts them to upper case. the data type i used is char because the values for the field are long strings

0 Kudos

if the data element / domain has the lower case checkbox checked then values will not change.... or you can implement the table maintainace events and convert them to lower case and save

[Table maintance events|http://www.google.com/url?sa=U&start=3&q=https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc&ei=cHGzSdCWMpWeMt-K1O8E&sig2=HyT2i2PuSp8l9Noh6vYUoQ&usg=AFQjCNHNaknEwTJgu1I6EzewzGc-hai6GQ]

Former Member
0 Kudos

it doesnt have a checkbox. i dont need to translate the string into upper/lower case. i just wanted it to be added as how the user typed the text.

0 Kudos

Hi.. You need to change the data element of the field for which you want the fields to be displayed as they are entered by user.

for that you need to check Lower Case checkbox while creating the data element or domain. without which it doesnt seem to be happening..

0 Kudos

i will never see the checkbox because i used the predefined type to set the data type.

thanks so much!

Former Member
0 Kudos

hi,

u need take change the value explicilty into upper case.if the domain for the particular element is maintained with upper case it will be taken automatically.

For saving data, if it has maintenance screen u can do it via sm30.in standard table the option of entering with be deleted..try entering via coding insert statemnt