contact person data in srm backend

[Former Member]

Hello experts,

would you know where i can find the maintained value in displayed in business partner data screen?

i checked SU01 and tcode BP but the email add maintained in those two are not the one I see on the screen.
I will need it because i will use the data in one of our forms.

Appreciate any help.

[ivy_li · Accepted solution]

Hi,

Please check table ADR6 where email address is stored.

Best regards,
Ivy

[Former Member · Accepted solution]

Ivy how about the telephone data and other data on the screen? (fax)

[Former Member · Accepted solution]

Hi Dex,

Email address can be found in table ADR6.

Fax Number can be found in table ADR3.

Telephone number can be found in table ADR2.

Regards

Pramod

[Former Member · Accepted solution]

Hi Pramod, thanks.
Would you also know the table for SU01d emails?

I chceked ADR6 but the one displayed here is the "Position" data email and not the User Account email (as displayed in User Settings). This User account email is the one used when RFx is being sent to the vendor so I'd  need to find where they are found in backend.

Thannks!

[Former Member · Accepted solution]

Hi Dex,

I checked from my end and i see the email address updated in the ADR6 table is from the SU01D. Can you please check

Field name in ADR6 is SMTP ADDR

Regards

Pramod

[ivy_li · Accepted solution]

Hi Pramod,

For ADR6, both email from SU01 and from BP(Overview) should be stored in this table, and please use the PERSNUMBER(you can get it from BUT000 for the user BP) to search the results.

BR,
Ivy

[vinita_kasliwal]

Hi Dex

I understand you basically want to use help in coding by identifying the email ID in SU01d

can you please try to use the FM  BAPI_USER_GET_DETAIL and in that when you execute using User ID you will get in table ADDSMTP  the email address of the concerned person as stored in SU01d .

Let me know if that helps

If you dont have the user ID you can use the Employee Id or something to fetch the user Id using FM

BP_CENTRALPERSON_GET  and then use the above one to find the email address ..

Regards

Vinita

[Former Member]

Check t-code:

bbpmainint

It`s neceesay ingress first /n

Regards