Get Contact person relation TelePhone , mobile and email Data
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
Double click on " Description " then new window open and display General Address information
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 ?
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.