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