Table for User Address details

[Former Member]

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

[thomas_mueller8]

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

[Former Member]

Hi Thomas,

Thanks for the reply. But I am unable to understand as to how do I link these tables. I get user's personal number from one table, address details from other table, but I am not understanding how are these tables linked?

Also, I am unable to find the function module, you mentioned: BAPI_USER_GETDETAIL in the system.

Could you please elaborate on how to link these fields?

Regards,

Ancy

[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