topic Re: Select + uppercase; lowercase in Application Development and Automation Discussions

Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 10:45:38 GMT

Hello Friends,

I am facing a problem:

I need to write a simple select satement, in on FM, :

My select statement was not working, however when I go directly to database, it works fine, and then in debug mode I found out that runtime environment automatically convert the value in uppercase. for example my FM recieved the value "Test", then when I read on table the runtime environment makes it "TEST", how I can avoid this issue ?

I cannot convert in lowercase, as "test" is also not working...

Regards,

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 10:47:28 GMT

Hello,

before the select stmt use

<b>TRANSLATE TEXT TO LOWER CASE.</b>

Vasanth

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 10:48:27 GMT

Hi Shah,

TRANSLATE Character conversion incharacter fields

Check this Function Module,

HR_P06I_CONVERT_TO_LOWERCASE.

Thanks.

Reward If Helpful.

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 10:51:14 GMT

Hi,

If u are passing the value to a FM, then there is a check box

"Upper/lower case".

Check this check box.

Rgds,

Prakash.

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 10:51:37 GMT

hi shah,

check in the domain of that field if the <b>Lowercase</b> checkbox is checked for that field, i think this is not checked for that field, if that is a Z domain then you can check that to avoid that error or

follow Vasanths solution

Re: Select + uppercase; lowercase

kiran_k8 — Fri, 15 Jun 2007 10:59:36 GMT

Shah,

Say thanks to Himanshu Agarwal,who helped me with this program long back.

&----

*& Report ZKK12

&----

ALL THE BEST IS SHOWN AS All The Best.

&----

REPORT ZKK12.

data:begin of itab occurs 0,

str(35),

END OF ITAB.

data : str type string value 'ALL THE BEST ? '.

*data : str type string value 'all the best ? '.

SPLIT str AT SPACE INTO TABLE ITAB.

loop at itab.

CALL FUNCTION 'STRING_UPPER_LOWER_CASE'

EXPORTING

DELIMITER = ' '

STRING1 = ITAB-STR

IMPORTING

STRING = ITAB-STR

EXCEPTIONS
NOT_VALID = 1
TOO_LONG = 2
TOO_SMALL = 3
OTHERS = 4

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

MODIFY ITAB index sy-tabix.

ENDLOOP.

clear str.

loop at itab.

concatenate str itab-str into str separated by space.

endloop.

write:/ str.

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 11:04:49 GMT

hello,

You guys, I dont want to make it lowercase, I want it remains as it is, as I mentioned, if the value is Test, then it should remain Test, and not using lowercase, test ?

Regards,

Re: Select + uppercase; lowercase

Former Member — Fri, 15 Jun 2007 11:22:30 GMT

Thanks kiran, it wroks for me too

Regards