Application Development 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: 

A table contains user data.

Former Member
0 Kudos

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

JozsefSzikszai
Active Contributor
0 Kudos

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

former_member223537
Active Contributor
0 Kudos

Hi,

USR01

USR02

USR03

USR04

..... & so on

Best regards,

Prashant

JozsefSzikszai
Active Contributor
0 Kudos

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

0 Kudos

very appreciate your help