Skip to Content
0
Aug 09, 2011 at 08:28 AM

Reading Table data - case in-sensetivity.

37 Views

Hi ABAPers,

I have an issue in reading data from table.

Issue is : Need to read all recrods(upper, lower, alter) from 2 tables(join) depending on input value.

I tried with native sql

EXEC sql performing email_change.

SELECT usr21-bname usr21-persnumber adr6-SMTP_SRCH adr6-smtp_addr INTO wa_user_email

from ( usr21 left OUTER JOIN adr6 on usr21-persnumber = adr6-persnumber )

where UPPER(adr6-SMTP_addr) eq v_addr.

if sy-subrc <> 0.

MESSAGE i000.

ENDIF.

endexec.

I am getting short dump for this code.

Please help

Thank you.

Ameen