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

How to extract CRM data?

Hi guys,

Plz give me the steps to extract the CRM data into BW?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 10, 2005 at 12:49 PM

    Hi ram !

    welcome to SDN forum.what do you wish to extract in BW from CRM. it is generally. different fromany other extraction. but herea are the most common steps to follow.

    1) first identify the datasources in CRM system in tcode rsa5

    here you can find most of the data crm sources under tree root->0crm.

    select the usefull sources and transfer them .

    2)you can test these data sources in transaction RSA3 or just go to Rsa6 and chek there.

    3) if these data sources wont give the compleat information required can enhance them by adding more fields to them in transaction RSA6. but if you enhance them you eighter got to mapp them to an existing bdocs in bwa1 tcode and enable the deltas. or you cna write your own function module to fill those fields

    4) finally replicate these data sources in the BW system

    5) map them to the infosources and maintain transfer rules

    6) and then yau can create infopackages and extracthem

    hope this gives you a general overview of the process. if you need more details just ask about it.

    hope this helps

    ( .reward some points if any of the answer helps is the way to assing points ignore if you know it already. you can assign points to ur answers by clicking the radio buttons shown beside the post.. blue for 10,green for 6 and yellow for 2. this is a way you can say thanks to the people who helps you)

    with regards


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Mohan!

      This is a bit different Question from the above.I think it would be better if you can open a seperate post for this . which will help others to identify it easily and also gives you a chance for appricating them by assigning points.

      Extraction of the Business parter data from crm system is one of main issues in analytical crm. this perticuar ods is actually populated with data from other ODS with in your BW system like ods for activities, salles order items and backorderitems.

      with regards


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.