<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic upper to lower case in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161085#M457088</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;is there any function module to manage upper case and lower cases&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 25 Apr 2007 06:35:53 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2007-04-25T06:35:53Z</dc:date>
    <item>
      <title>upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161085#M457088</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;is there any function module to manage upper case and lower cases&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:35:53 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161085#M457088</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:35:53Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161086#M457089</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;make use of keyword&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE Character conversion incharacter fields &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Prabhu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:37:45 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161086#M457089</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:37:45Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161087#M457090</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Use translate command:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Translate f1 into lowercase/uppercase.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Jogdand M B&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:38:02 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161087#M457090</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:38:02Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161088#M457091</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DATA letters(3) TYPE C. &lt;/P&gt;&lt;P&gt;MOVE 'abc' TO letters. &lt;/P&gt;&lt;P&gt;TRANSLATE letters TO LOWER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For more infromation...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variants: &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. TRANSLATE c TO UPPER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2. TRANSLATE c TO LOWER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;3. TRANSLATE c USING c1. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;4. TRANSLATE c ...FROM CODE PAGE g1...     TO CODE PAGE g2. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;5. TRANSLATE f ...FROM NUMBER FORMAT n1... TO NUMBER FORMAT n2. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;Like all string processsing statements, you can only use character-type operands here. &lt;/P&gt;&lt;P&gt;If the type of an operand is not STRING, the operand is treated like a type C field, regardless of its actual type, even though no actual conversion takes place. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In an ABAP Objects context, a more severe syntax check is performed that in other ABAP areas. See Only character fields allowed in string processing. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variant 1 &lt;/P&gt;&lt;P&gt;TRANSLATE c TO UPPER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variant 2 &lt;/P&gt;&lt;P&gt;TRANSLATE c TO LOWER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Effect &lt;/P&gt;&lt;P&gt;The first variant converts all lowercase letters in c to uppercase. The second variant converts all uppercase letters to lowercase. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example&lt;/P&gt;&lt;P&gt;DATA letters(3) TYPE C. &lt;/P&gt;&lt;P&gt;MOVE 'abc' TO letters. &lt;/P&gt;&lt;P&gt;TRANSLATE letters TO UPPER CASE. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;letters now has the contents 'ABC'. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;The classification of upper- and lowercase, and the actual characters used are determined by the current text environment (see SET LOCALE LANGUAGE). &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variant 3 &lt;/P&gt;&lt;P&gt;TRANSLATE c USING c1. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Effect &lt;/P&gt;&lt;P&gt;Translates the contents of c according to the rule in field c1. &lt;/P&gt;&lt;P&gt;When a character from c corresponds to a character from c1, it is replaced by the next character that occurs in c1. If the character appears more than once in c1, its first occurrence is used in the replacement. If a character from c does not occur in c1, it remains unchanged. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example&lt;/P&gt;&lt;P&gt;DATA: letters(20) TYPE C VALUE 'abcabcabcXabc', &lt;/P&gt;&lt;P&gt;      change(15)  TYPE C VALUE 'aXbaYBabZacZB'. &lt;/P&gt;&lt;P&gt;TRANSLATE letters USING change. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;letters now contains 'XaZXaZXaZXXaZ'. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variant 4 &lt;/P&gt;&lt;P&gt;TRANSLATE c ...FROM CODE PAGE g1 ...TO CODE PAGE g2. &lt;/P&gt;&lt;P&gt;Parts marked with " ..." are interchangeable &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE c TO   CODE PAGE g2. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE c FROM CODE PAGE g1. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Effect &lt;/P&gt;&lt;P&gt;Converts the contents of the field c from character set g1 to character set g2. This variant uses the conversion table g1 to determine the SAP character, which is then used to determine the new character from g2. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Transaction SPAD allows you to display and maintain character sets. If one of the conversion tables does not exist, the runtime error CONVERSION_CODEPAGE_UNKNOWN occurs. Conversion combinations that are maintained as part of the runtime system for performance reasons do not trigger runtime errors, and you cannot change them using Transaction SPAD. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example&lt;/P&gt;&lt;P&gt;DATA c(72) TYPE C. &lt;/P&gt;&lt;P&gt;TRANSLATE c FROM CODE PAGE '1110' TO CODE PAGE '0100'. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This statement converts the contents of field c from the HP-UX character set to IBM EBCDIC. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;Fields with types I, P, F, and X remain unchanged by the conversion. The syntax check only allows character fields for specifying the codepage. However, since the codepage is maintained in table TCP00 as a type N field with length 4, you should use this type. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variant 5 &lt;/P&gt;&lt;P&gt;TRANSLATE f ...FROM NUMBER FORMAT n1 ...TO NUMBER FORMAT n2. &lt;/P&gt;&lt;P&gt;Parts marked with " ..." are interchangeable &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE f TO NUMBER FORMAT n1. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE f FROM NUMBER FORMAT n1. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Effect &lt;/P&gt;&lt;P&gt;Converts the number formats in f. Currently, the number formats '0000' (HP, SINIX, IBM) and '0101' (DEC-alpha OSF) are supported. Other formats trigger the runtime error TRANSLATE_WRONG_NUM_FORMAT . If you omit FROM NUMBER FORMAT or TO NUMBER FORMAT, the system uses the system number format. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example&lt;/P&gt;&lt;P&gt;DATA: f TYPE F, &lt;/P&gt;&lt;P&gt;      hex(2) TYPE X, &lt;/P&gt;&lt;P&gt;      nform LIKE tcp00-cpcodepage. &lt;/P&gt;&lt;P&gt;... &lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;The contents of fields hex and f are stored in /ARCHIV &lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;from another platform. hex is stored in a valid number &lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;form when it is saved, and can therefore be read on &lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;all platforms. &lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;READ DATASET '/ARCHIV' INTO hex. &lt;/P&gt;&lt;P&gt;READ DATASET '/ARCHIV' INTO f. &lt;/P&gt;&lt;P&gt;nform = hex.  "Conversion from non-host-specific. HEX into N(4) &lt;/P&gt;&lt;P&gt;TRANSLATE f FROM NUMBER FORMAT nform. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Effect &lt;/P&gt;&lt;P&gt;Converts the contents of f from the nform format of a given platform into the system representation. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;This converts fields with types I and F. As in variant 4, you should define the number formats with type N and length 4. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can display system codepage and number formats using the function module SYSTEM_FORMAT. This allows you to store additional information for archiving purposes. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;Performance: &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Converting lowercase letters to uppercase (or the other way round) in a 10 byte character field requires around 7 msn (standardized microseconds). &lt;/P&gt;&lt;P&gt;If you use ... c USING c1... to replace two characters of a 10 byte character field,the runtime is around 9 msn. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Note &lt;/P&gt;&lt;P&gt;Runtime errors: &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TRANSLATE_WRONG_NUM_FORMAT: Invalid number format. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Don't forget to reward&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:41:46 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161088#M457091</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:41:46Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161089#M457092</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You can use the ABAP command TRANSLATE as follows:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;DATA text TYPE string. 
text = `Careful with that Axe, Eugene`. 
TRANSLATE text TO UPPER CASE.  or TRANLATE text TO LOWER CASE.&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:42:37 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161089#M457092</guid>
      <dc:creator>Faaiez</dc:creator>
      <dc:date>2007-04-25T06:42:37Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161090#M457093</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi rasheed,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;         Check this Function Module,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;               HR_P06I_CONVERT_TO_LOWERCASE.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Reward If Helpful.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:42:53 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161090#M457093</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:42:53Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161091#M457094</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Rasheed,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CALL FUNCTION 'STRING_UPPER_LOWER_CASE&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;K.Kiran.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:43:19 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161091#M457094</guid>
      <dc:creator>kiran_k8</dc:creator>
      <dc:date>2007-04-25T06:43:19Z</dc:date>
    </item>
    <item>
      <title>Re: upper to lower case</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161092#M457095</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Rasheed,&lt;/P&gt;&lt;P&gt;Try this FM to convert from lower case to upper case .&lt;/P&gt;&lt;P&gt;TERM_TRANSLATE_TO_UPPER_CASE&lt;/P&gt;&lt;P&gt;regards,&lt;/P&gt;&lt;P&gt;Raghav&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2007 06:45:20 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/upper-to-lower-case/m-p/2161092#M457095</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-04-25T06:45:20Z</dc:date>
    </item>
  </channel>
</rss>

