LOWERCASE TO UPPERCASE

[Former Member]

Hi,

I have issue in BEx, i have one characterstic(version) with selected lowercase letters and data is loading from r/3 and flatfile,on this characterstic have created 7 variables in report level, in selecction screen if i enter in small letters it should be able to fetch data from database,because of my master data all are in captial letters out of 20, 2 of small letters,so i can write userexits for variable,but my problem is for every variable i couldn't write this code and it will be more complexity to change variable in every report,

even in infoobject level it doesn't allow to uncheck lowercase letter option,none of this if there is any option convert from lowecase letter to uppercase in report level without exits,plz let me know,

i would appriciate if anybody help me,

this is urgent requirement

[Former Member]

i agree with u, when it doesn't check lowercase letters infoobject level,my case is already it has checked lowercase leeters that'y it won't allow small letters,because of my masterdata contain in capital letter.

[Former Member]

You should create a second variable VAR2 filled by user exit.

Use the second variable to restrict the data.

Now implement the following coding in XRSRU01:

DATA:

i_var TYPE rrrangeexit,

l_s_range TYPE rsr_s_rangesid.

WHEN 'VAR2'.

if i_step = 2.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

read table i_t_var_range into i_var with key

vnam = 'VAR1'.

if sy-subrc = 0.

l_s_range-low = i_var-low(2).

translate l_s_range-low to upper case.

endif.

append l_s_range to e_t_range.

endif.

Best regards

Dirk

[Former Member]

Hi Dirk,

Than Q for ur response, but my problem is user doesn't want to write user exits for variables, we can do this way, other than user exits is there any option in BEx level to convert lowercase to uppercase,

Plz let me know,

Thanks Alot,

With Regards,

Ravi.

[Former Member]

You could create your own conversion exit. But this is a kind of user exit too only that nobody would ever expect it and if you have problems one day it will be much more complicated to debug.

I cannot think of another way.

Best regards

Dirk

[Former Member]

Hi,

i'm sorry to mention that, that infoobject has created without masterdata, it means it takes characterstic as an attribute,so on this characterstic have created variables,

i want to make entries from lowercase to uppercase without userexits,plz if there is any option let me know.

With warmregards,

Ravi

[Former Member]

ok,

normally all entries in variables for characteristics are automatically converted to upper case letters.

Siggi

[Former Member]

Hi Ravi,

I don't understand your requirement using lower case letters in characteristic for reporting issues. In BW you can load lower case letters only into characteristics that can be used as attributes only and which are not relevant for reporting. So how did you manage to get a characteristic into your cube that contains lower case letters?

regards

Siggi