Skip to Content

SAP table for Userid , First Name & Last Name

Hi Guys,

Can somebody tell me the SAP table which has logon Userid, First name & Last Name.

Thanks,

mini

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jun 10, 2009 at 04:33 AM

    Use this View which is a combination of USR21,ADRC,ADRP tables.

    USER_ADDR

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2009 at 05:07 AM

    Hi,

    Goto USR21 table pass your SAP login name. You will get the PERSONNUM pass this number to ADRP table, you will get the First Name and Last Name.

    Pass the Address Number to ADRC table, you will get the address details.

    Hope this mabe be useful..

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2009 at 10:07 AM

    Hi,

    check "USER_ADDRP" table , here BNAME is userid ,name_first is firstname and name_last is lastname.

    hope it'll help.

    Regards,

    Sneha.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 10, 2009 at 01:22 AM

    did u check USR* tables?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 10, 2009 at 06:48 AM

    Hello,

    Check table USR03.

    Regards,

    Sujeet

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.