Identifying Tables - Employee number field and email address field

[Former Member]

We need to identify specific tables for data extraction purposes.

The tables we need are - "employee number" tables (used in SU01) and "email address" field - (techinical info. field name - SMTP_ADDR)

Thanks.

Marie

[RichHeilman]

If you are looking for email addresses tied to user master records, then the table is ADR6, you must link to this thru USR21.

* Get email address
  clear smtp_address.
  select single adr6~smtp_addr into smtp_address
                from usr21
                   inner join adr6
                        on  usr21~addrnumber = adr6~addrnumber
                       and  usr21~persnumber = adr6~persnumber
                               where usr21~bname = sy-uname.

Not sure that I've ever seen an employee number tied directly to a user in SU01.

Regards,

Rich Heilman

[Former Member]

If you can run ST01, then select DB Access (SQL Trace). Log in and run the tcodes that have the info you need (IE SU01). Turn off the trace and look at the logs with Analysis. Enter the username of the user you used for testing under general restrictions and also the general time frame around when you ran the tcodes. That will tell you all the tables that were hit.

Ray

P.S. If helpful, please award points.