Question Re: CRM Customer Data in Technology Q&A

CRM Customer Data

Former Member — Wed, 05 Jan 2011 11:39:37 GMT

Hi All,

I require some info about CRM customer. I am working on a report lost opportunities and require the customer and customer master data info.

I have looked at opportunity header datasource & opportunity Item datasource but does not have data about customer.

please guide me to get the customer data like customer code, customer name, customer address, customer contact number.

Thank you for your inputs.

Kind Regards

James

Re: CRM Customer Data

Former Member — Wed, 05 Jan 2011 12:01:27 GMT

Customer details comes with the masterdata of the data sources in CRM.

Refer some of the Business Partner Datasources like

0CRM_BPART_ATTR

0CRM_BPART_TEXT

Thanks

Re: CRM Customer Data

Former Member — Wed, 05 Jan 2011 16:03:25 GMT

Hi suganya

Thank you for the info. Is there a way to join the below datasources.

Opportunity Header : 0CRM_OPPT_H

Opportunity Item : 0CRM_OPPT_I

to the master data

0CRM_BPART_ATTR &

0CRM_BPART_TEXT

any lookup to join the data for reporting.

Kind Regards

James

Re: CRM Customer Data

Former Member — Thu, 06 Jan 2011 09:07:29 GMT

Hi Harrison,

It would be better to extract the Opportunity data and Customer master data individually in BW and then join the data.

The reson being Opportunity data is transaction data which can be stored in DSO and Customer info can be stored in Customer master in Master data. You can create an InfoSet to join the two data. This way you will not have to write any code.

Cheers!

Re: CRM Customer Data

Former Member — Thu, 06 Jan 2011 09:26:16 GMT

you cannot join the data sources, extract the data into BI and build consolidation DSO instead of using info set. infoset is not recommended in terms of performance and data integrity.

Re: CRM Customer Data

Former Member — Thu, 06 Jan 2011 09:43:03 GMT

Hi,

Thank you for the info.

What would be the common data between the oppertunities data and business partner data to join in the infoset.

I essentialy have the below columns as the report requirement.

Contact Number |

Thanks

James

Re: CRM Customer Data

Former Member — Thu, 06 Jan 2011 11:00:16 GMT

Try if you can link using 0bpartner. Check how data is fetched using opportunities DS. If it contains customer or account number then you can link it easily using 0bpartner.