What is the process to extract data from function module 'CRM_ORDER_READ' into BW?

[Former Member]

Hi,

We have a CRM function module  'CRM_ORDER_READ' available in CRM system. we want to extract the data from this function module to our BI system.

The function module is accepting most of the import parameters as tables and also the output parameters is also in the form of tables.

Do we have any standard datasources which can help in this scenario? or what is the process to extract data from this FM?

Thanks,

Akshara

[andrea_previati]

Hi

if you want to replicate exactly the extraction in the CRM_ORDER_READ in BW you should create a custom generic  BW extractor based on function module; in this rso2 extractor you should include the ABAP logic of the CRM ORDER READ in this new extractor

you can follow the procedure of the  document in the link to create an extractor based on function module; however it's  a medium/hight complexpity abap developement

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

[anton_kuznetsov4]

akshara, hi!

There is standard content extractors and BW objects for different CRM documents, but not a one simple exctractor for all (as in CRM_ORDER_READ).

You can first look at following extractors

0CRM_SALES_ACT_1 for activities

0CRM_OPPT_H     for opportunity headers and so on.

And 0SAPCRM infoarea in BW content.

[Former Member]

Thanks, for the reply Anton

Can we find relevant extractors, for the data which comes from these output parameters when the function module is executed?

ET_ORGMAN,

ET_ORDERADM_H,

ET_ORDERADM_I,

ET_DOC_FLOW,

ET_SCHEDLIN_I,

ET_OPPORT_H,

ET_PRICING_I,

ET_APPOINTMENT

[anton_kuznetsov4]

There is no on-to-one relation between CRM standard extractors and this structures.

One extractor usually takes fields from different tables. And every structure in CRM_ORDER_READ exporting parameters usually belongs to one table.

Example: exctractor 0CRM_OPPT_H returns data for opportunity headers and include data from CRMD_ORDERADM_H and CRMD_ORGMAN tables (which correspond to ET_ORDERADM_H and ET_ORGMAN structure)

See:

Opportunity Header - Sales Analyses - SAP Library

DIS_CHANNEL	Distribution channel	ORGMAN	DIS_CHANNEL
DIVISION	Division	ORGMAN	DIVISION

So, I think you need to find out which data do you need in BW reports from business point of view (opportunity, activity, ...?) and after that get standard exctractor for this and try to install business content in BW.

Load from FM is not a good way for many reasons. For example, it's hard to use delta load.

[Former Member]

Anton,

I am trying to find the quotes and it's visibility in the quarters. But as the fields which I require as per requirement, comes from these 8 output parameter tables.

For ex: I need Quote ID and Quote lines from ET_ORDERADM_H and ET_ORDERADM_I; Oppurtunity ID from ET_DOC_FLOW; District from ET_ORGMAN; net price from ET_PRICING_I.... so on

So, in this situation would generic extraction be prefered?

Akshara

[anton_kuznetsov4]

You can use 0CRM_QUOTATION_I for quotes.

It includes QUOTATION_GUID, ITEM_GUID, NET_PRICE and reference to opportunity in PRED_OPPT_GUID. I'm not shure about district, but even if there is no such field you can easily get it by enhancement the exctractor and filling district in user exit. Extractor working in delta mode.

I think this is better way.