Skip to Content
0

How to use SQL without BSP login

Jun 13, 2017 at 01:48 AM

19

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers