Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Or just use SE16 or SE16N to look at tablename USER_ADDR. If you're certain that the names that you have match the names in the SAP accounts, you can use the various fields to filter the data using the MORE and IMPORT FROM TEXT FILE features.
Or you can just use SE16 or SE16N to dump the entire contents of USER_ADDR to a spreadsheet, eliminate the columns you don't want, and have a master directory in spreadsheet form. If your userbase is fairly static, your data will stay "good" for awhile.
Mark A. Toney
SAP Security Analyst
Sodexo NorthAmerica
From: QuintinKidd via sap-security [mailto:sap-security@Groups.ITtoolbox.com]
Sent: Thursday, July 01, 2010 11:48 AM
To: Toney, Mark
Subject: RE: [sap-security] List of names and need SAP user id
Posted by QuintinKidd
on Jul 1 at 11:46 AM Mark as helpful
I'd use tcode SQVI and do a table join of USR02 to USR21 to ADRP. USR02
has the basic user master info; USR21 has the link of User ID to Person
Number and ADRP has the Person number with the First and Last Name.
Quintin
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments
may contain proprietary and privileged information for the use of the
designated recipients named above. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.
________________________________
From: KatherineP via sap-security
[mailto:sap-security@Groups.ITtoolbox.com]
Sent: Thursday, July 01, 2010 10:43 AM
To: Kidd, Quintin
Subject: [sap-security] List of names and need SAP user id
Posted by KatherineP
(Associate Business Analyst)
on Jul 1 at 11:39 AM
Hi I have a list of name and we need to know their user id. Is there a
way to do a mass look up rather than looking them up one by one.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Mark Toney
SAP Security Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement _.____.__ |
Mark as helpful
