Data Dictionary

[Former Member]

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.

[Manohar2u]

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

[Former Member]

hi Shejal,

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

[Former Member]

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.

[Manohar2u]

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

Regds

Manohar

[Manohar2u]

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

Regds

Manohar

[Former Member]

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.

[sridhar_k1]

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

Regards

Sridhar

[Laxmana_Appana_]

Hi,

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

Laxman

[Former Member]

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.

[RichHeilman]

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

[ferry_lianto]

Hi Shejal,

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

Regards,

Ferry Lianto

[ferry_lianto]

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

[RichHeilman]

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

[Former Member]

Thanks all for all the suggestions.

Shejal.