Data extraction using ODS objects

[Former Member]

Hello everybody,

I am trying to extract CRM data into SAP BW.

Found a standard ODS Object 0CRMBPKPI, which i think is relevant as i need to extract Business partner data from CRM.

Does anybody know the procedure how to extract data using this ODS object?

or exists any standard InfoCube to extract Business partner data?

Thanks in advance.

Regards,

Mohan

[Ashwin]

Hi mohan!

have you cheked the saphelp on this perticulat ods.

http://help.sap.com/saphelp_nw04/helpdata/en/83/19bf78cb902e48bc9efc0a64e59907/frameset.htm

hope this helps.

with regards

ashwin

[Ashwin]

Hi mohan!

in analytical crm we load primaryly we maintain the data of a business partener in the master data of infoobject 0BPartner.

the main datasources for bp in CRM are present under the root-PI_BASIS->OCA_BP->OCA_BP-io

but in general Business partner maintainace is a very complex thing in analytical crm part. so it depends on for which attributes of business partner you need and also on the customizations in the CRM systm.

just give me some more details on where exactly do you need the BP info and what attributes of th eBP are used.

with regarding

ashwim

[Former Member]

Hi Ashwin,

Thank u, i got very useful info about that particular ODS from the link which u posted.

I need to extract basic details of BP like name and address. You can find them in CRM with Transaction code: BP.

Also, I have not activated the datasources under the root PI_BASIS->OCA_BP->OCA_BP-IO. Actually i transferred the DataSources that starts with 0CRM..

Thank u.

Regards,

Mohan