topic Re: Data Dictionary in Application Development and Automation Discussions

Data Dictionary

Former Member — Thu, 06 Jul 2006 19:21:54 GMT

HI Friends,

I have created a table and when i creat some entries into that table it always reset everything in enter in UPPER CASE. However i want to send the data to an external system which would read only lower case.

Please let me know what should be done.

Shejal.

Re: Data Dictionary

Manohar2u — Thu, 06 Jul 2006 19:23:15 GMT

You check the field's domain, there is a check box lower case. when you check this it will be stored in case sensitive, else always in capital letters.

Regds

Manohar

Re: Data Dictionary

Laxmana_Appana_ — Thu, 06 Jul 2006 19:23:56 GMT

Hi,

select the lower case option of the domain of the field.

Laxman

Re: Data Dictionary

Former Member — Thu, 06 Jul 2006 19:25:10 GMT

hi Shejal,

In DOmain there is a checkbox set to lower case ... enable that one... this solves your problem

Re: Data Dictionary

Former Member — Thu, 06 Jul 2006 19:25:39 GMT

Use a domain that has the checkbox 'lowecase' checked and then enter the text in lowercase. But this will preserve the case and so if you enter in mixed case, the text will be in mixed case.

Alternatively you can, after getting the records from the database into an internal table, convert the text to lowercase before downloading.

Re: Data Dictionary

RichHeilman — Thu, 06 Jul 2006 19:25:40 GMT

For your field you must use a data element which uses a domain which will allow for lower case. So in SE11, double click on the data element next to your field, now double click on the domain, On the defintion tab, you will see a lowercase checkbox. This must be checked in order to have lowercase character in your field. If you are not use custom data elements and custom domains, create these and check this box. Or search for a data elment that is using a domain that has this checked.

Regards,

Rich Heilman

Re: Data Dictionary

ferry_lianto — Thu, 06 Jul 2006 19:26:51 GMT

Hi Shejal,

Go to output characteristics section in domain level and select lower case option.

Regards,

Ferry Lianto

Re: Data Dictionary

Former Member — Thu, 06 Jul 2006 19:27:01 GMT

Thanks for the suggestion,

I am using SAP standard domains and i dont want to change the domain as it requires an access key to change. However i wan wondering is there a way that i could change in the coding.

Shejal.

Re: Data Dictionary

Manohar2u — Thu, 06 Jul 2006 19:28:25 GMT

No, as it is already stored. I don't think you can control.

Regds

Manohar

Re: Data Dictionary

ferry_lianto — Thu, 06 Jul 2006 19:29:58 GMT

Hi,

It will not store as lower case value if you are using standard one eventhough you handle the translation from program.

You need to copy standard domain and data element to custom one and apply to your custom table. Ensure checked the lower case option.

Regards,

Ferry Lianto

Re: Data Dictionary

RichHeilman — Thu, 06 Jul 2006 19:33:12 GMT

The only way now, is to create a custom data element which uses a domain that has it checked, or you can create a custom domain and tie it to your data element, then use that data element in your table.

Regards,

Rich Heilman

Re: Data Dictionary

Manohar2u — Thu, 06 Jul 2006 19:34:51 GMT

You can copy the domain and makesure to check lowercase option.

Regds

Manohar

Re: Data Dictionary

Former Member — Thu, 06 Jul 2006 19:35:30 GMT

Thanks all for all the suggestions.

Shejal.

Re: Data Dictionary

Former Member — Thu, 06 Jul 2006 19:36:22 GMT

As I said, once you read the table contents into your internal table, you can then convert the text to lowercase using TRANSLATE itab-text TO LOWERCASE option and then download.

Re: Data Dictionary

sridhar_k1 — Thu, 06 Jul 2006 19:36:53 GMT

If u don't want to use custom domain, Convert the text to lower case using TRANSLATE text TO LOWER CASE statement.

Regards

Sridhar