Address Tab on SU01

[Former Member]

In Transaction SU01 on the Address Tab, i would like to pull out a report with 4 fields i.e (Last Name, First Name, Tel No and Internet Mail).

I want to see a number of users without Tel numbers and e-mail addresses on their profiles so i can correct this.

Thanx

[Former Member]

Hi,

USR01 User master record (runtime

USR02 Logon Data (Kernel-Side Use

USR03 User address data

USR04 User master authorizations

USR05 User Master Parameter ID

USR06 Additional Data per User

hope it help's

[Former Member]

You may try Table USER_ADDR

[Former Member]

or tcode S_ALR_87101200.

Note: According to the comments in the report of this transaction, table USR03 is obsolete for address data.

Cheers,

Julius

[Former Member]

Goto SU10 --> addess data --> give user = * and you will get the report as you want.

Cheers,

-Sunil

[Former Member]

Hi Benton,

You can get the reoprt from table <b>USER_ADDR.</b>

There are some other tables like ADRP, ADCP, etc...

Hope it helps.

Please award points if it is useful.

Thanks & Regards,

Santosh

[Former Member]

Hi,

If i have understood your querry properly is it like you want to develop a report to populate the First Name, Lastname,Tel No., Mail ID of the users.

For this use the following tables:

ADR6 tbl SMTP_ADDR fld for Email ID

ADR2 tbl TEL_NUMBER fld for Tel No

ADRP tbl NAME_FIRST fld for First name

ADRP tbl NAME_LAST fld for Last name

All these tbls are related via fld PERSNUMBER.

So Use these tables and join them via PERSNUMBER and populate the internal table.

Otherwise if u dont want to use a zreport for this download the concerned fields+persnumber field from diff tbls mentioned above to excel and use the vlookup function to draw a combined report.

Hope this resolves your requirement.

It is to mention here that u cant pull out such a report directly from SU01.

Pl dont forget to award if resolved.

Regards

[Former Member]

You can get this information by creating a query in SQVI or writing your own ABAP report.

Here is a list for tables and how they are linked

USR02 -> USR21 via BNAME

This will get you your PERSNUMBER and ADDRNUMBER which is what you need to query address information

USR21 -> ADRP via PERSNUMBER

This will get you Firstname and Lastname

USR21 -> ADR2 via ADDRNUMBER

This will get your telephone number

[v_veeramalla]

Run the Report RSUSR007...and select the fields as per u r requirement..

U will get the report.

This will solve u r problem..