Skip to Content
author's profile photo Former Member
Former Member

CRM data source enhancement

Hi

Iam working on CRM analytics part of BW to generate reports.

In crm after opening an transaction by giving transaction no the details will be displayed. Next to details in tabpage 'DATE' they had added a new custom field called 'NEXT Contact Date.

So my req is to get this 'Next contact date' based on transaction no. in BW reports.

Please anybody help me on how to get this in BW.

If it is by enhancing datasource in CRM guide me which data source has to be enhanced and how to do.

OR

If there is other way inform me.

Thanks

Ucas.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jun 19, 2006 at 06:29 PM

    Ucas,

    If you search the forums, there is a previous post on this question, but I will give you the high level answer:

    1. Extend the datasource structure and add the new field.

    2. Create a new implementation of CRM_BWA_MFLOW to retrieve the additional data into the extraction structure. The badi has an example implementation.

    3. Enhance the cubes on the BW side to use this field.

    Look at this thread for more details:

    Extract Custom Fields to BW

    Good luck,

    Stephen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Stephen,

      Charmed on ur interest.

      My ques is different. It is; i had enhanced(Added) an extra field in date tab of activities in CRM; named 'Next Contact Date'.

      But i donot know where the data, for this field is getting populated. If i know the default table where these custom defined date fields are stored accordingly i can enhance the extract structure and get these data in BW.

      When u got pl. post the sol.

  • Posted on Jun 20, 2006 at 08:41 AM

    Hi Ucas,

    The date related fields are stored in SCAPPT.

    You can link SCAPPT, SCAPPTSEG and CRMD_LINK tables to

    get the values for the date fields.

    <b>Reward points if it helps.</b>

    Add a comment
    10|10000 characters needed characters exceeded

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.