Q

Run a program to find name changes in the user ID history

Security expert Corwin Slack describes how to find name changes in the history of a particular user ID.

Where can I obtain information on changes of first and last name for a particular user ID? One user ID was held by few different owners at different intervals and I want to know which particular staff member did an update to a data during a certain period of time.

I already noticed that there is no historical information on the user's first and last name.

There is no delivered solution that I am aware of. In later versions of SAP you can look up the user name in table ADR7 and then find the last name and first name associated with the corresponding person number in table ADRP. You'll want to try to correlate these changes to the addition and delete records in the change history reports in transaction SUIM.

The following program (used in conjunction with the change documents reports in transaction SUIM to find date ranges) can assist you in resolving the names assigned to a user ID.

report  zaddresslookup.


data: wa_adr7 type adr7.
data: wa_adrp type adrp.
data: i_adr7 type adr7 occurs 0.


parameters: uname like usr02-bname obligatory.


select * from adr7 into table i_adr7 where
   uname = uname.

loop at i_adr7 into wa_adr7..
  select single * from adrp into wa_adrp
         where  persnumber  = wa_adr7-persnumber.
  if sy-subrc = 0.
    write:/ wa_adr7-uname,
    wa_adr7-persnumber,  wa_adrp-name_last, wa_adrp-name_first.
  endif.
endloop.
This was first published in March 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close