CRM BP Master Data query or report?

[Former Member]

Hello Everyone:

I have been asked to pull information out of CRM showing users BP number, userid, first name, last name, physical address, phone, fax, cellular, email and org data such as job and department. I know that all of this data is stored in our BP records but I am having trouble locating the exact data locations or table names for these specific BP data elements.

Does anyone know of an existing standard report that might contain this data? Or, will this type of information require a query to be written? I am fairly new to CRM and I've spent quite a bit of time searching for this information with no luck.

Any suggestions from you would be extremely helpful and very much appreciated!!

Thanks!

Robin

[Former Member]

Hello Priyanka and Samantak,

Thank you so much for your very helpful information! Would you also have any suggestions on how to link the Employee user name of the Identification tab on the BP to the USR02 user master table? I need to include the current userid on my BP Master Data query and I'm not having any luck on mapping these two fields.

Also, I am having trouble finding the exact location of BP phone record information. I've looked in ADR2, ADRC and BUT051 but these records do not match up to the BP information. Any help again would be greatly appreciated!!!

Kind regards,

Robin

[Former Member]

Robin,

Please check the table ADCP or ADCPS with the Address Number. Else you can use the Function Module 'BAPI_BUPA_CENTRAL_GETDETAIL' to get all the details.

Regards,

Shyamak

[Former Member]

Hi Robin,

There are a lot of Reports, Function Modules, and other Objects already available to extract data for the Master Data Business Partner. The best ways is to do a Where - used - List on the BUT000 Table with selecting the required entries.

I found a BAPI - BAPI_BUPA_ADDRESS_GETDETAIL which accepts business partner number as input and will give you the address details along with other information. You can write your own report where you simply need to take the BP Number as input and then use this function module to retrieve the rest of the information.

Hope this will help.

Thanks,

Samantak.

[Former Member]

Hi Robin,

Below are the list of tables to get list of BP data you were refering to from crm system:

BUT000 - BP general data line name, business partner category etc

BUT020 - BP address numbers

ADRC - complete address(with above address numbers get address)

BUT050 - BP relationship data

BUT051 - relationship data department, function, etc

ADR6 - Email address of bp

ADR2 - Telephone numbers

ADR3 - fax numbers

Use FM CRM_CENTRALPERSON_GET to get User id related to BP by passing bp guid

Thanks,

Priyanka