topic Re: User tables in Application Development and Automation Discussions

User tables

Former Member — Fri, 20 Oct 2006 18:36:46 GMT

HI Frenz,

in which tables i can find username, user's address, phone number, email id?

i have user ID... i need to print other details also.

Regards

Re: User tables

RichHeilman — Fri, 20 Oct 2006 18:39:39 GMT

You can get the user address information from the ADRC, and ADR6 tables. Check ADRC to get the relevant fields for address.

For example, here is how to join the tables.



report zrich_0001.

data: begin of user_info,
      bname type usr21-bname,
      name_text type adrp-name_text,
      tel_number type adcp-tel_number,
      tel_extens type adcp-tel_extens,
      smtp_addr type adr6-smtp_addr,
      end of user_info.


* Get User Data
clear user_info.
select single  usr21~bname adrp~name_text adcp~tel_number
        adcp~tel_extens adr6~smtp_addr
                into corresponding fields of  user_info
                  from usr21
                  inner join adrc
                    on  usr21~addrnumber = adrc~addrnumber
                  inner join adrp
                    on  usr21~persnumber = adrp~persnumber
                  inner join adcp
                    on  usr21~addrnumber = adcp~addrnumber
                    and usr21~persnumber = adcp~persnumber
                  inner join adr6
                    on  adcp~addrnumber = adr6~addrnumber
                    and adcp~persnumber = adr6~persnumber
                            where usr21~bname = sy-uname.


write:/ user_info-bname, user_info-name_text, user_info-tel_number,
        user_info-tel_extens, user_info-smtp_addr.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

Re: User tables

Former Member — Fri, 20 Oct 2006 18:40:11 GMT

Hi,

Check the following tables

USR01

USR02

USR03..

You can use the BAPI BAPI_USER_GET_DETAIL..

Thanks,

Naren

Re: User tables

Former Member — Fri, 20 Oct 2006 18:53:50 GMT

try to use FM SUSR_USER_ADDRESS_GET

Re: User tables

Former Member — Sun, 22 Oct 2006 08:13:38 GMT

Hi ,

for a standard organisation they will be storing all employee/personal data for communication in "communications Infotype" where different subtype shows mail id,phone number etc....usually it is a custom developed infotype ...it will be starting with PAxxxx....

eg:pa9006...its a very large place to hunt down......

Regards

Re: User tables

Former Member — Sun, 22 Oct 2006 11:50:09 GMT

hi,

one more point----

please try pa0105 table with subtype 20 for phone numberfield =>usrid

pa0105 table with subtype 10 for mail idfield =>usrid_long

it is a communication table and a standard infotype..varying subtypes could give you your desired results

Regards

Re: User tables

Former Member — Mon, 23 Oct 2006 21:20:43 GMT

Check this code...

Select single pernr uname

from pa0105

into ( l_pernr, l_user )

where subty = '0001'

and usrid = sy-user.

endselect.

for subty 0010 in pa0105, you will get the e-mail id.

with the help of this pernr, do a select on pa0006 to get the details like address and phone number.

select (fields required)

from pa0006

into table itab

where pernr = l_pernr

and subty = '1'

and endda = '99991231'.

Regards

Navneet