Ask the Expert

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

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: