Skip to Content
avatar image
Former Member

Table for User Address details

Hi All,

I wanted to know in which table the address of the employees (users) saved in SRM5.0? I checked function module BAPI_BUPA_ADDRESSES_GET, but it just links the business partner number to the Address Guid. How do I find which address detail is linked to this Guid? I checked table ADRC, but couldnot find it there. Could anyone help me on this?

My actual issue is that, for a particular user,the address information doesnot showup in the shop screen(when I try searching for this user using 'shop for' option). The users in SRM are replicated from HR Org structure in ECC6.0

So, I wanted to know which table of SRM is not updated with the address linking this user.

For this particular user, I can find 2 address guids from the function module, BAPI_BUPA_ADDRESSES_GET. Is that the reason for this issue?

How do I resolve this?

Regds,

Ancy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 24, 2010 at 06:49 PM

    Hi Ancy,

    there are two tables for the address information:

    ADRP - Person

    ADRC - Companies

    Maybe it helps if you have a look to function BAPI_USER_GETDETAIL as well.

    Business Partner information are stored in BUTxxx tables.

    Kind regards,

    Thomas

    Edited by: Thomas Mueller on Aug 24, 2010 8:49 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The link between these two business partner number is Person number.. Following is the architecture..

      1) User will have a Business Partner number in SRM

      2) Company/org will have a Business partner number in SRM

      3) There is something called User and company relationship will exist by person number, i.e. User's official information like Building, Floor, Room Number are stored under company's /org's BP address number refer to person number..

                              • BP u2013 Business Partner *************

                              This should be helpful..

                              Thanks!!

                              Bharath