Skip to Content
avatar image
Former Member

How to use SQL without BSP login

When I forget my password, I try to send out an initialized password to my email.

The email is stored in infotype0105.

I want to retrieve email from table pa0105 with pernr entered before login.

As follows:

SELECT SINGLE usrid

FROM pa0105 INTO email

WHERE pernr = l_pernr

AND subty = '0007'

AND endda> = sy-datum

AND begda <= sy-datum.

However, the result of sy-subrc is '4'.

Probably because I did not log in.

How can I use SQL without login?

Regards,

Lee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers