CRM Activity DataSource not fetching all data

[Former Member]

Hi,

We are on CRM 7.0 EHP1 and BW 7.3.

While trying to extract data for Activities DataSource 0CRM_SALES_ACT_1 in BW, we are not getting some of the records as from 0SALES_P (Channel Partner).

Checked in CRM BWA1: Not all field were mapped in Mapping tab. There were some custom field created by CRM team which appeared to be mapped. Standard fields were not mapped. BWA1 check shows same warning messages. >>> I then re-activated DataSource from RSA5. This time Mapping for standard field appeared but custom filed mappping diappeared!

So currently in BWA1, I dont have mapping in 'Mapping' tab for custom fileds but these are present for Standard fields.

Can anyone please throw some light on how to resolve this issue of Mapping and extracting all fileds records correctly? Will be so thankful.

Regards,

Nirmit

PS: BWA1 Selection tab is empty.

[former_member182470]

HI,

I don't know the functionality of CRM. But I want to suggest you one thing.

After installing from RSA5(only Standard Mappings happened), can you map your custom fields in RSA6? Because, all post processing s have to be done in RSA6 only. Make sure your datsource with all mappings in RSA6 finally.

Then, you try to extract your datasource.

Regards,

Suman

[Former Member]

Hi Suman,

Thanks for your reply. As far as I have come, it appears ECC and CRM DataSources handling methods are bit different. However, though RSA6 could definitely be used for enhancement, CRM (we're on 7.0)enhances DataSource directly via AET as per my post above. We are going through later path thus looking for solution on that.

Nirmit

[Former Member]

Hi

even if the datasource is different, have you read this? http://scn.sap.com/thread/1717503

Let me know

a

[Former Member]

Hi Andrea,

Yes I had gone through this thread earlier but could not get the problem resolved for me.

1. After I checked in SPRO for BADI code, I could find some standard code written and no mention of any custom stuff. As I am not an ABAPer, could nto interpret it. Secondly, I am not sure if BADI deals at individual DataSource level as I was not asked any Filter or Entry Criteria for some DataSource name to be given for the BADI of that one to be displayed.

The code is as below:

   METHOD if_ex_crm_bwa_mflow~enhance_data_source .

  DATA: lt_extract_data                 TYPE TABLE OF crmt_csdr_bw_proj_h,
        ls_extract_data                 LIKE LINE OF lt_extract_data,
        lc_project_datasource(30)       VALUE '0CRM_CSDR_PRJ_ATTR',
        lc_assembly_datasource(30)      VALUE '0CRM_CSDR_ASS_ATTR',
*        lc_proj_proc_type(4)            VALUE 'DRGP',
*        lc_asy_proc_type(4)             VALUE 'DRGA',
*        lv_clear_data                   TYPE char1,
        lv_proj_result                  TYPE CRMT_BOOLEAN.

*  lv_clear_data = ''.
  lv_proj_result = ''.

  IF i_datasource EQ lc_project_datasource OR i_datasource EQ lc_assembly_datasource.

    lt_extract_data = ct_data.

    LOOP AT lt_extract_data INTO ls_extract_data.

      CALL METHOD cl_crm_csdr_tools=>isproject
        EXPORTING
          iv_process_type = ls_extract_data-process_type
        receiving
          ev_result       = lv_proj_result.

      IF i_datasource EQ lc_project_datasource AND lv_proj_result = ''.
          DELETE lt_extract_data.
          CONTINUE.
      ELSEIF i_datasource EQ lc_assembly_datasource AND lv_proj_result = 'X'.
          DELETE lt_extract_data.
          CONTINUE.
      ENDIF.

    ENDLOOP.

    ct_data = lt_extract_data.

  ENDIF.

ENDMETHOD.

Could you help how to proceed with this if this step is at all needed?

2. Is it always a manual procedure to update the Mapping tab in BWA1. While creating custom fields, our CRM team had flagged them BW relevant and Extract Structure got enhanced automatically as a result. (For all the DataSources) Believe its a new functionality in CRM AET.

3. For another DataSource, 0CRM_LEAD_H, everything is working just fine. BWA1 Mapping tab has all the standard as well as custom fields. Delta is fetching data for custom fields as well.

Appreciate your helpful guidance.

Thanks

Nirmit