topic Re: adding entries to table in Application Development and Automation Discussions

adding entries to table

Former Member — Sun, 08 Mar 2009 06:41:06 GMT

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

Re: adding entries to table

Former Member — Sun, 08 Mar 2009 06:59:46 GMT

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

Re: adding entries to table

Former Member — Sun, 08 Mar 2009 06:59:46 GMT

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

Re: adding entries to table

Former Member — Sun, 08 Mar 2009 07:09:24 GMT

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

Re: adding entries to table

former_member156446 — Sun, 08 Mar 2009 07:19:43 GMT

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]

Re: adding entries to table

Former Member — Sun, 08 Mar 2009 07:39:43 GMT

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.

Re: adding entries to table

Former Member — Mon, 09 Mar 2009 04:11:29 GMT

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

Re: adding entries to table

Former Member — Mon, 09 Mar 2009 06:08:28 GMT

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

Re: adding entries to table

Former Member — Mon, 09 Mar 2009 06:37:06 GMT

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

thanks so much!