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: 

Conversion is happening even though there is no conversion routine?

former_member202077
Participant
0 Kudos
1,826

Hello

I have a Z table and one of field is a my_text field.

1) When i am mainitianing this table in SM30, for example, i entered as 'Test data in my_text field' in my_text field in SM30, its saving all in upper case, as 'TEST DATA IN MY_TEXT FIELD', but i want to save as is as user entered.

2) In other way, when i am pulling text data from another Z table, am getting text in upper case in my_resport, even though the vaue saved in lower case

When i chekced there us no conversion routine at domain level

Pls. let me know How can i save text as is in data base

How can get/pull data as is in data base into my_report?

Thank you

1 ACCEPTED SOLUTION

raymond_giuseppi
Active Contributor
0 Kudos
197

Create or use a domain with "Lower case" checked in definition tab (Look at domain like TEXT132 (*) and CHAR132 to see the difference) - look at [Creating Domains|http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21edf2446011d189700000e8322d00/frameset.htm] in Other Options.

Distinguish uppercase/lowercase: If you want to distinguish uppercase and lowercase for the fields referring to this domain, you have to select Lowercase. Otherwise, all the entered letters are converted to uppercase in the database. Entries can only made for this field in data types CHAR and LCHR.

Also some remarks

- Is your system single-language (and not unicode) else put the text in a [text table|http://help.sap.com/saphelp_40b/helpdata/en/cf/21ea9e446011d189700000e8322d00/content.htm] and add a language key, the regenerate the maintenance dialog of the main table/view.

- Do you intend to create a search-help on this text field, if yes, you may add a second (hidden in maintenance) field in the table or text table, without lower case, and use this field in search help, use [Event 01: Before Saving the Data in the Database|http://help.sap.com/saphelp_nw04s/helpdata/en/91/ca9f0ba9d111d1a5690000e82deaaa/frameset.htm] of maintenance generator to copy data from lower case displayed field to upper case hidden field when inserting or updating report. (only if there will be many records, not a problem for a table with few records)

Regards,

Raymond

(*) SAP created many TEXTnnn domain and data element that you can use.

3 REPLIES 3

former_member206439
Contributor
0 Kudos
197

Hi,

In ABAP when you enter the text and press the Enter button by default the text will convert to UPPER case no need of require any Conversion routine for this.

If you want to save the text in Lower case then follow the below step.

At the Domain level you have check box called Lower Case under the Definition tab.

Check that check box then your text will be in lower case.

let me know if there are any concerns.

Thanks

Naresh

raymond_giuseppi
Active Contributor
0 Kudos
198

Create or use a domain with "Lower case" checked in definition tab (Look at domain like TEXT132 (*) and CHAR132 to see the difference) - look at [Creating Domains|http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21edf2446011d189700000e8322d00/frameset.htm] in Other Options.

Distinguish uppercase/lowercase: If you want to distinguish uppercase and lowercase for the fields referring to this domain, you have to select Lowercase. Otherwise, all the entered letters are converted to uppercase in the database. Entries can only made for this field in data types CHAR and LCHR.

Also some remarks

- Is your system single-language (and not unicode) else put the text in a [text table|http://help.sap.com/saphelp_40b/helpdata/en/cf/21ea9e446011d189700000e8322d00/content.htm] and add a language key, the regenerate the maintenance dialog of the main table/view.

- Do you intend to create a search-help on this text field, if yes, you may add a second (hidden in maintenance) field in the table or text table, without lower case, and use this field in search help, use [Event 01: Before Saving the Data in the Database|http://help.sap.com/saphelp_nw04s/helpdata/en/91/ca9f0ba9d111d1a5690000e82deaaa/frameset.htm] of maintenance generator to copy data from lower case displayed field to upper case hidden field when inserting or updating report. (only if there will be many records, not a problem for a table with few records)

Regards,

Raymond

(*) SAP created many TEXTnnn domain and data element that you can use.

Former Member
0 Kudos
197

Hi,

If you use standard data element or domain for text then SAP will automatically converts it to Uppercase. To avoid this create your own domain and then data element.

While creating DOmain make sure that Lower Case checkbox is clicked. This will not convert the same into upper case.

Shiva