topic Re: Ztable is Case sensitive in Application Development and Automation Discussions

Ztable is Case sensitive

Former Member — Mon, 29 Sep 2008 10:42:40 GMT

Hi all,

I have created a Zprogram and a Ztable - Based on the execution of the Zprogram my Ztable will be filled with Data

Now I am writing another Zprogram1 - where in the selection screen I am entering the data in smalls - then my select statement is not picking the data.

If I enter in CAPS then it is fetching the Data.

I tried to use Translate statement too, with this only the data is converting into Capitals, but it will be in the Header it self - so when my select statement getting failed to pick my data from the Ztable.

Could any one help me in this issue plz.

Re: Ztable is Case sensitive

bpawanchand — Mon, 29 Sep 2008 10:44:29 GMT

The data values are case sensitive might be the values in teh tables are in the upper case check out

Regards

Pavan

Re: Ztable is Case sensitive

Former Member — Mon, 29 Sep 2008 10:46:01 GMT

it is case sensitive..

Re: Ztable is Case sensitive

Former Member — Mon, 29 Sep 2008 10:48:41 GMT

Hi,

Run the query in SE16 by entering the selection criteria and see if you get entries. follow the same in your program.

check if , in the domain, the lowercase check box is selected for the field in question.

If this flag is set, upper case and lower case are distinguished when you enter values with screen masks. Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

regards,

Advait.

Re: Ztable is Case sensitive

valter_oliveira — Mon, 29 Sep 2008 10:54:08 GMT

Do this:


AT SELECTION-SCREEN.

 CALL FUNCTION 'TERM_TRANSLATE_TO_UPPER_CASE'
      EXPORTING
        langu               = sy-langu
        text                = p_table "your selection-screen data
      IMPORTING
        text_uc             = p_table "your selection-screen data
      EXCEPTIONS
        no_locale_available = 1
        OTHERS              = 2.


AT SELECTION-SCREEN.

  LOOP AT s_table.
    CALL FUNCTION 'TERM_TRANSLATE_TO_UPPER_CASE'
      EXPORTING
        langu               = sy-langu
        text                = s_table-low
      IMPORTING
        text_uc             = s_table-low
      EXCEPTIONS
        no_locale_available = 1
        OTHERS              = 2.
    CALL FUNCTION 'TERM_TRANSLATE_TO_UPPER_CASE'
      EXPORTING
        langu               = sy-langu
        text                = s_table-high
      IMPORTING
        text_uc             = s_table-high
      EXCEPTIONS
        no_locale_available = 1
        OTHERS              = 2.
    MODIFY s_table.
  ENDLOOP.

Regards,

Valter Oliveira.

Re: Ztable is Case sensitive

Former Member — Mon, 29 Sep 2008 11:15:18 GMT

Thanks for all your replies -

I have done a very sillly mistake like -

I have declared a table with another Ztable where the Domain has been checked 'Lower Case' instead of my ztable.

Now I have changed the field in my selection-screen declaration to my table field where I have already unchecked the 'Lower case'.

Still Iam thankful to you all -

Re: Ztable is Case sensitive

Former Member — Mon, 29 Sep 2008 14:47:36 GMT

Got the solution on my own by declaring the select-option perfectly