case sensitive issue

[Former Member]

When searching for a contract, certain fields are case sensitive and will not provide results if the lower case is used. For instance, when search in the Contract Name field in "Active Contracts", if you enter xyz no values will come up. If you enter "XYZ* several locations will come up.

Is there a way for this to either be corrected to accept and recognize both upper or lower case or at a minimum provide a warning to use only capital letters? It is frustrating getting "no values" for a location that we know exists. Its urgent ... pls help gurus

Thank you,

[Former Member]

if you are doing that programaticcy then use statement TRANSLATE text TO UPPER CASE to chng the data to upper case always and then use..

otheriwse check for any EXITS or OSS notes for that TCode...

That's the only option...

[Former Member]

Hi Ram

Thanks for the same... but i am not doing it via program .... i have debugged also there i found the TRANSLATE<> TO UPPERCASE .... can u give me some other suggesstions how do i proceed....... thanks a lot

[Former Member]

If this is in a SELECT statement, you may be able to use native SQL.

Rob

[Former Member]

if you are tring to search using the find button

then in the popup that comes up, the is a check box <b>Match Case</b> , check that and search

[Former Member]

HI

let me tell u clearly .... i am in the transaction RECN ... here i enter the company code . and for the contact no i use the search help .... in the same i do for the active contract and in that if i enter the contract name in lower case it will not take... and if i enter the same in the upper case ... it displays the result .... i hope i made myself clearer .... how can i give a warning message to avoid this mistake.... pls help

[Former Member]

What table does the search help look at?

Rob

[Former Member]

THE VIEW IS V_RECNCNB , RECNCNB is the serch help

[Former Member]

OK - I think it's a user education issue. The users will have to understand that they have to match the case when using this search help.

To answer your other post - I don't think there are relevant OSS notes on this. Please close one or the other (or both) thread.

Rob

[Former Member]

Hi CAN U HELP ME HOW DO I PROCEED IN THIS CASE THEN? URGENT.....

[Former Member]

HI

Use TRANSLATE statement for this problem.

Ex:

Data: it_tab type c(10) value 'AeAdare'.

Translate it_tab to uppercase.

Result will be AEADARE.

Reward me if its helpful

Regards

Ravi

[former_member189059]

Check this code and output

This is the output

Rm167 is matched by pattern #R#m167

rm167 is not matched by pattern #R#m167

RM167 is not matched by pattern #R#m167

rM167 is not matched by pattern #R#m167

using this code:

FORM ANY .
DATA:
  lr_text TYPE RANGE OF text40 with header line,
  lv_text1 type text40 value 'Rm167',
  lv_text2 type text40 value 'rm167',
  lv_text3 type text40 value 'RM167',
  lv_text4 type text40 value 'rM167'.
  lr_text-sign = 'I'.
  lr_text-option = 'CP'.
  lr_text-low = '#R#m167'.
  APPEND lr_text.
 
  IF lv_text1  IN lr_text.
    WRITE: / lv_text1, 'is matched by pattern', lr_text-low.
  ELSE.
    WRITE: / lv_text1, 'is not matched by pattern', lr_text-low.
  ENDIF.
  IF lv_text2  IN lr_text.
    WRITE: / lv_text2, 'is matched by pattern', lr_text-low.
  ELSE.
    WRITE: / lv_text2, 'is not matched by pattern', lr_text-low.
  ENDIF.
  IF lv_text3  IN lr_text.
    WRITE: / lv_text3, 'is matched by pattern', lr_text-low.
  ELSE.
    WRITE: / lv_text3, 'is not matched by pattern', lr_text-low.
  ENDIF.
  IF lv_text4  IN lr_text.
    WRITE: / lv_text4, 'is matched by pattern', lr_text-low.
  ELSE.
    WRITE: / lv_text4, 'is not matched by pattern', lr_text-low.
  ENDIF.
 
ENDFORM.                    " any