Get Contact person relation TelePhone , mobile and email Data

[former_member207526]

Dear Experts ,

I want to get contact person relation ->telephone , mobile and email Data .

What are the tables that store all above fields information ....Please help

Just want to confirm my requirement :

Suppose i have Contact : 1115406

a. Open transaction BP and enter 1115406 ( Role : Contact person ) and click on " Relationship" button

b.

    Double click on " Description "  then new window open and display General Address information

c.

Now , My requirement to get telephone, email and Mobile number as shown below? ...  What table store All this information ??

Table But050 store  telephone and email   ( Is am correct ? )

What table store Mobile ?

Regards ,

Rishi verma

[former_member193634 · Accepted solution]

Hello,

You may want to consider BAPI BAPI_BUPR_CONTP_ADDR_GETDETAIL to get phone number (either standard phone or mobile) and email maintained on the contact person relationship.

Output table BAPIADTEL of this BAPI retrieves all phone number maintained. You can differentiate mobile phone number using the R_3_USER attribute.

Hope this helps.

Best regards,

Sylvain AGUETTAZ

[former_member207526]

Thanks a lot,  Sylvain & Kamfrk for your helpful answer  .My  next requirement to modify data in that contact relationship  so i have used FM : BAPI_BUPR_CONTP_ADDR_CHANGE   and its working fine for me .

Thanks ,

Rishi verma

[kamran_farooqui]

Hi Rishi,

You can get details from below tables;

Tables : ADRC (Telephone, Ext, Fax, Ext,).

              ADR2  (Mobile Number).

              ADR6  (Email id's).

For these you need to have the address number and that you can get it from Table BUT020.

Regards,

Kamfrk.