Application Development and Automation 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: 
Read only

adding entries to table

Former Member
0 Likes
1,128

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,084

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
Read only

Former Member
0 Likes
1,084

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

Read only

Former Member
0 Likes
1,084

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

Read only

Former Member
0 Likes
1,084

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

Read only

0 Likes
1,084

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]

Read only

Former Member
0 Likes
1,085

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.

Read only

0 Likes
1,084

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

Read only

0 Likes
1,084

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

thanks so much!

Read only

Former Member
0 Likes
1,084

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