need help in writing Query customer exit convert lower to upper case

[Former Member]

hi guys . i have a scenario.

our data is converted in to upper case from BW. in the query designer i need to create a variable, so when the user click on selection option and enter anything in lower case, it will convert it to upper case and do the search.

i have a created a customer exit variable.. ZPROJECTSEL

i am writing an abap code.

WHEN 'ZPROJECTSEL'.

CLEAR l_s_range.

DATA: t(10) TYPE c . ** do i need to declare a variable to hold the converted upper case data?

if i_step = 2.

• this is where i am lost****

t = ZPROJECTSEL.

TRANSLATE t TO UPPER CASE.

zprojectsel = t.

so any ideas in understanding variable exit would be helpful.

thanks

[Former Member · Accepted solution]

Hi Syed,

What you have done is alright. t = ZPROJECTSEL is not an expensive statement so, I think you are good.

Thanks and Regards

Subray Hegde

[Former Member · Accepted solution]

Thanks SUbray for replying. i am confused at is to use i_step 2 or i_step 3.

i know 1 is when using default values. 2 is when object is entered. the problem is i want this to check whenselection criteria .. like if you dont know the value and you click on the icon that bring up some values and one can search by text or key.. i want the user to able to put in lower or upper case and it converts lower to uppser case and do the search. do you know if that is possible?

[former_member184494 · Accepted solution]

t = ZPROJECTSEL. will not work - you would have to read xtab_low and get the value...

[Former Member · Accepted solution]

can you elaborate this xtab_low?

[former_member184494 · Accepted solution]

sample code segments available at

http://www.sapdev.co.uk/sap-bw/queryexit.htm

loop at I_T_VAR_RANGE into wa_range where VNAM eq '0S_GRANT'

also please search the forums before posting...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20f119d9-922d-2c10-88af-8c016638...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f002c608-2533-2c10-25a1-d0e7f7b5...

in a nice how to on customer exits.

Edited by: Arun Varadarajan on Jun 12, 2009 9:53 PM

[Former Member · Accepted solution]

this is all good but i need to create it on the help icon of the variable selection option.