topic Re: Upper case in Application Development and Automation Discussions

Upper case

Former Member — Wed, 06 Dec 2006 07:33:01 GMT

dear gurus,

I have a query like this

SELECT

mara~matnr

makt~maktx

mara~wrkst

In this wrkst has got small letter

i want to convert in to upper case and then i have to sort it

how this can be done

waiting for u r replies

senthil

former_member69765 — Wed, 06 Dec 2006 07:34:41 GMT

use -- translate variable to upper case.

nyoy

Message was edited by:

Varun Verma

Former Member — Wed, 06 Dec 2006 07:36:03 GMT

hi Senthil,

Check out this example

DATA letters(3) TYPE C. 
MOVE 'abc' TO letters. 
TRANSLATE letters TO UPPER CASE.

Regards,

Santosh

Former Member — Wed, 06 Dec 2006 07:38:11 GMT

after u get the data to internal table

loop at itab.
 
 TRANSLATE ITAB-WRKST TO UPPER CASE.
 MODIFY ITAB INDEX SY-TABIX.

ENDLOOP.

Former Member — Wed, 06 Dec 2006 07:38:29 GMT

Hi senthil..

Use TRANSLATE keyword

translate mara~wrkst to upper case.

Regards,

pankaj singh

Former Member — Wed, 06 Dec 2006 07:45:37 GMT


loop at itab assigning <fieldsymbol>.
  TRANSLATE ITAB-FIELD1 TO UPPER CASE.
endloop.
SORT ITAB BY FIELD1.

thanks

pavan

Former Member — Wed, 06 Dec 2006 08:17:52 GMT

thanx for all your replies.

senthil