translate

[Former Member]

Dear Friends,

I have a select-option: ltxa1 like plpo-ltxa1.

if i give the lowercase value noting is picked up from the select query. i need to translate to uppercase before retriveing the table.

can anyone suggest the code for do the above

regards

karthik

[Former Member]

Dear Friends,

I have a select-option: ltxa1 like plpo-ltxa1.

if i give the lowercase value noting is picked up from the select query. i need to translate to uppercase before retriveing the table.

can anyone suggest the code for do the above

regards

karthik

[Former Member]

INITIALIZATION.
translate ltxa1-low to upper case.
translate ltxa1-high to upper case.

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Dear sekar,

I used the code like below

IF ltxa1 NE space.

translate ltxa1-low to upper case.

translate ltxa1-high to upper case.

but it is affecting only the header line of ltxa1 not the option table.

how to modify the option table.

regards

karthik

[Former Member]

Hi Karthik ,

In case of select-options you need to loop on the select options and get the low and high value into the worl area , convert them into upper case and then modify the internal table.

Looping is very important becase select-options gives your the freedom to input more than one set of values.

Do revert back in case of any queries.

Regards

Arun

[Former Member]

loop at ltxa1.

translate ltxa1-low to upper case.

translate ltxa1-high to upper case.

modify ltxa1 index sy-tabix.

endloop.

[Former Member]

you can loop at the table

if not ltxa1[] is initial.
loop at ltxa1 into wa_ltxa1.
  translate ltxa1-low to upper case.
 translate ltxa1-high to upper case.
 modify ltxal from wa_ltxa1.
endif.

[Former Member]

use translate syntax.

TRANSLATE LTAX1 TO UPPERCASE

then write ur query

[Former Member]

hi,

if ltxa1 is not initial.

translate ltxa1 to uppercase.

select * from dbtable where xyz in ltxa1.

endif.

regards,

keerthi

[Former Member]

Hi,

U can do like this :

TRANSLATE s_test TO UPPER CASE.

select * from ybsp into table itab where userid in s_test.

-Regard,

Satya Priya

[Former Member]

hi karthik,

int he message u mentioned as

I have a select-option: ltxa likeplpo-ltxa1.

according to me we have to mention select-option : ltxa for plpo-ltxa1.

and as long as u dont mention the paramameter value in ' ', independent of the case of the text, the data is retrieved from the data base.

hope helps and make sense.

regards.

[Former Member]

Hi Karthik ,

I should be handled automatically by the select options , but incase if it does not , then in the event at selection-screen , use the command TRANSLATE text to upper case.

Regards

Arun