Upper case

[Former Member]

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]

use -- translate variable to upper case.

nyoy

Message was edited by:

Varun Verma

[Former Member]

hi Senthil,

Check out this example

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

Regards,

Santosh

[Former Member]

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]

Hi senthil..

Use TRANSLATE keyword

eg

translate mara~wrkst to upper case.

Regards,

pankaj singh

[Former Member]

hi

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

thanks

pavan

[Former Member]

thanx for all your replies.

senthil