Ztable is Case sensitive

[Former Member]

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.

[bpawanchand]

Hi

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

Regards

Pavan

[Former Member]

it is case sensitive..

[Former Member]

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.

[valter_oliveira]

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.

OR

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.

[Former Member]

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 -

[Former Member]

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