CRM Master Data Extraction

[Former Member]

Dear all,

Can anyone help me with how to paper about CRM Master Data Extraction? I need to know on how to extract Business Partner and its attributes (Relationship, Address and others), also on how to extract CRM Marketing Attributes for Business Partner.

Thanks for your help.

Ricky

[former_member188972]

I found:

for Business Partner Marketing Attributes:

http://help.sap.com/saphelp_crm50/helpdata/en/51/a39a653491e549b4476d90ab4b7c86/content.htm

I replicate the same flow for 0BP_ID and for the relationship.

I didn't found anything about the others address (there is only the datasource 0BP_DEF_ADDRESS_ATTR for the standard).

Regards,

Sergio

[Former Member]

Hi Sergio,

Thanks for your help. I will look at all the documentation that I have, then probably will try to make adjustment, based on the requirement.

Thanks,

Ricky

[Former Member]

Hello Ricky,

I haven't found any conclusive document about loading Business Partner from CRM 4.0 to BW 3.5. If there is someone out there who knows about that documentation I would really appreciate it.

Here is what we did regarding BP relations, marketing attributes and addresses:

1. Marketing attributes:

These data type is difficult, because you have to build a special extractor for each marketing attribute group. And because Marketing attributes cannot be transported, you cannot transport the extractor. This poses a big problem in many projects. Therefore we solved it by creating some view extractors on the appropriate CRM tables: AUSP, CABN, KSML, KLAH. I can give you some more details, if this will help.

2. BP relations:

We build a view extractor for this too, because it was much easier to extract the data from BUT050 and BUT051 than trying to find out, how the business content extractors do their work. Using this extractor, we build some special ODS and InfoCubes for the relations we were interested in.

There is Business content for BP relations, but we kept to the generic extractors, because they were easier to verify.

3. BP adresses:

We use 0CRM_BPDEFADDR_ATTR to get the primary address.

We use 0CRM_BPART_ATTR to get BP master data

We use 0CRM_BPART_TEXT to get BP text.

We have only about 300.000 BP in CRM, so we do a full update everyday.

I am not sure, if these three data sources are part of the current BW 3.5 business content, because we started with BW 3.0 and did not check for BC updates.

Kind regards,

Jürgen

Message was edited by: Jürgen Kirsch

[Former Member]

Hi Jurgen,

I just found one ODS from Business Content for Marketing Attributes, which is 0ATR_DS01. That's why I am searching information, whether to use the Business Content or to create my own ODS' and InfoCubes.

If you have any information, would please kindly send it to my email, r1ky@hotmail.com

Thanks for your help.

Ricky

Message was edited by: Ricky Amirudin

[Former Member]

Sorry Ricky,

I am looking for this kind of documentation myself, and haven't found one yet.

Can someone else enlighten us ?

Kind regards,

Jürgen

[Former Member]

Hello Jurgen,

Can you please provide some document for the 1st point mentioned by you below:

1. Marketing attributes:

These data type is difficult, because you have to build a special extractor for each marketing attribute group. And because Marketing attributes cannot be transported, you cannot transport the extractor. This poses a big problem in many projects. Therefore we solved it by creating some view extractors on the appropriate CRM tables: AUSP, CABN, KSML, KLAH. I can give you some more details, if this will help.

We also need something like this which captures the Marketing Attribute from CRM to BW.

Can you please send over the document to

'rakhanr@gmail.com'

With Best Regards

Rohit R

[former_member184494]

Ricky,

did you try extractring the data in the normal way for any master data ? I am not sure if CRN would be different for master data.. for transactions you have thechoice of using RFC / Business I Doc...

check if normal extraction works and then if it does not , then troubleshooting can be done for the same..

Arun

Assign points if useful

[Former Member]

Hi Arun,

Thanks for replying. Actually, our modeling requirement for CRM is very complex, such as many to many relationship on Business Partner to other objects, and also the marketing attributes. I just want to know whether SAP provides any how to paper or enhancement or even templates on Business Partner dan Marketing Attributes from CRM to BW.

Hope you can help me.

Thanks,

Ricky