Skip to Content
0
Former Member
Oct 17, 2005 at 04:52 AM

Problem in select query

11 Views

Dear All,

I have written the query

SELECT

pymt_type

FROM zww_pymthd_std

INTO gv_pymt_type

WHERE bukrs = zcompany_code AND

pymen = zpayval.

Ex:- zcomp_code = 'SCCC'

zpayval = 'Bill Payment'

Now sy-subrc becomes 4 because internally in the program Bill Payment gets converted in to upper case and does not match with the same lower case in the data base. I want to avoid the internal conversion. can anybody suggest me how??

Regds,

Anup.