topic Re: comparing string in select query in Application Development and Automation Discussions

comparing string in select query

Former Member — Fri, 14 Jul 2006 07:48:33 GMT

Hi,

select single *

from mara

where matnr = wa-matnr.

Here matnr is char18. Can we compare string like this?

When wa-matnr is in lower case it is setting sy-subrc = 4, even though the matnr exists in mara. When converted to upper case and used it is setting sy-subrc = 0.

Is there any other solution for the problem? I have checked out with matnr's conversion routine. It is also not working.

Re: comparing string in select query

Former Member — Fri, 14 Jul 2006 07:51:20 GMT

Hi ,

You can convert the string to upper case using the function module TERM_TRANSLATE_TO_UPPER_CASE, and then check for the value,

Hope this helps,

Rgds,

Re: comparing string in select query

Former Member — Fri, 14 Jul 2006 07:52:15 GMT

Hello,

First translate the WA-matnr to UPPER case using translate to uppercase and then use it in the select query.

If useful reward points.

Vasanth

Re: comparing string in select query

Former Member — Fri, 14 Jul 2006 08:03:49 GMT

just try dat way...

ex...

data:wa_matnr like mara-matnr.

data:wa_matnr1 like mara-matnr.

data: gv_matnr like mara-matnr.

wa_matnr = 'comptest'.

CALL FUNCTION 'TERM_TRANSLATE_TO_UPPER_CASE'

EXPORTING

LANGU = SY-LANGU

TEXT = wa_matnr

IMPORTING

TEXT_UC = wa_matnr1

EXCEPTIONS
NO_LOCALE_AVAILABLE = 1
OTHERS = 2

IF SY-SUBRC <> 0.

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

ENDIF.

select single matnr

from mara into gv_matnr

where matnr = wa_matnr or matnr = wa_matnr1.

write : gv_matnr.

Re: comparing string in select query

Former Member — Fri, 14 Jul 2006 08:07:02 GMT

Hi mudhukeshwar,

1. If your field wa-matnr

a) is defined with LIKE MARA-MATNR.

b) is defined as parameter on selection-screen,

(so that the value comes from screen,

and not hardcoded into the program)

2. then automatically

a) uppercase

b) zero padding

will be taken care of , and u will get the record.

regards,

amit m.