topic Re: translate in Application Development and Automation Discussions

translate

Former Member — Tue, 23 Jan 2007 12:14:55 GMT

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

Re: translate

Former Member — Tue, 23 Jan 2007 12:16:46 GMT


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

Message was edited by:

Chandrasekhar Jagarlamudi

Re: translate

Former Member — Tue, 23 Jan 2007 12:17:45 GMT

use translate syntax.

TRANSLATE LTAX1 TO UPPERCASE

then write ur query

Re: translate

Former Member — Tue, 23 Jan 2007 12:18:14 GMT

hi,

if ltxa1 is not initial.

translate ltxa1 to uppercase.

select * from dbtable where xyz in ltxa1.

endif.

regards,

keerthi

Re: translate

Former Member — Tue, 23 Jan 2007 12:22:48 GMT

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

Re: translate

Former Member — Tue, 23 Jan 2007 12:27:04 GMT

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.

Re: translate

Former Member — Tue, 23 Jan 2007 12:40:25 GMT

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

Re: translate

Former Member — Tue, 23 Jan 2007 12:40:38 GMT

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

Re: translate

Former Member — Tue, 23 Jan 2007 12:43:06 GMT

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

Re: translate

Former Member — Tue, 23 Jan 2007 12:43:25 GMT

loop at ltxa1.

translate ltxa1-low to upper case.

translate ltxa1-high to upper case.

modify ltxa1 index sy-tabix.

endloop.

Re: translate

Former Member — Tue, 23 Jan 2007 12:44:38 GMT

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.