Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

A table contains user data.

Former Member
0 Likes
486

Is there a table that contains User data(logon account).

At SU01->Address , There are 'Person' box.

I'm looking for a table contains those contents..

Thank you

1 ACCEPTED SOLUTION
Read only

JozsefSzikszai
Active Contributor
0 Likes
441

hi Seung,

have a look:

DATA : lv_name TYPE adrp-name_text,

lv_persnr TYPE usr21-persnumber.

  • User personal number

SELECT SINGLE persnumber

INTO lv_persnr

FROM usr21

WHERE bname EQ sy-uname.

  • User full name

IF sy-subrc EQ 0.

SELECT SINGLE name_text

INTO lv_name

FROM adrp

WHERE persnumber EQ lv_persnr.

ENDIF.

hope this helps

ec

3 REPLIES 3
Read only

Former Member
0 Likes
441

Hi,

USR01

USR02

USR03

USR04

..... & so on

Best regards,

Prashant

Read only

JozsefSzikszai
Active Contributor
0 Likes
442

hi Seung,

have a look:

DATA : lv_name TYPE adrp-name_text,

lv_persnr TYPE usr21-persnumber.

  • User personal number

SELECT SINGLE persnumber

INTO lv_persnr

FROM usr21

WHERE bname EQ sy-uname.

  • User full name

IF sy-subrc EQ 0.

SELECT SINGLE name_text

INTO lv_name

FROM adrp

WHERE persnumber EQ lv_persnr.

ENDIF.

hope this helps

ec

Read only

0 Likes
441

very appreciate your help