Skip to Content

CRM Activity DataSource not fetching all data


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.



PS: BWA1 Selection tab is empty.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2013 at 08:51 AM


    even if the datasource is different, have you read this?

    Let me know


    Add a comment
    10|10000 characters needed characters exceeded

    • 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
      iv_process_type = ls_extract_data-process_type
      ev_result = lv_proj_result.

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


      ct_data = lt_extract_data.



      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.



  • Posted on May 26, 2013 at 04:45 AM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.