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

Regarding CRM data extraction


My datasource is 0CRM_OPPT_I.

There is a field called TERR_GUID(Territory ID).

When a transaction is created in the source system,this field value is not extracted to PSA(when the transaction is first fetched to BI).

If there is a delta in the transaction,then the field is fetched to PSA in the delta.

Hence any records that do not have delta are not having this field's value in BI.

In rsa3,the value is fetched.

In the source system(CRM),the field gets determined as soon as the transaction is created.

Going through the change history of the transaction in source system shows that the TERR_GUID is not entered some time after the transaction is created.

Please help!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 12:54 PM


    For Delta Extraction of CRM to BI pelase follwo the below steps

    Go to transaction GNRWB

    Select BUS_TRANS_MSG

    Select (on the right, the services): BWA_DELTA3, BWA_FILL, BWA_queue

    Press Generate.

    Also check for the following:

    1. The delta should have been initialized successfully.

    2. Confirm that all Bdocs of type BUS_TRANS_MSG

    are processed with success in SMW01.

    3. If there are queues in SMQ1 with erroneous status then activate

    these queues.

    In Transaction SMQ1 if there are Queues existing with

    names beginning with CRM_BWAn (n is number) then

    activate these queues in the same transaction.

    4.a)If required activate the datasource

    Go to transaction BWA5 > select the required datasource and


    4 b) The Delta may not be active ,activate the delta in BWA7 by

    selecting the name of the datsource and pressing the candle icon for

    'activate delta'.

    5. In BW system

    Go to transaction RSA1 > modeling > infosources > select the

    info source > right mouse click on the selected

    infosource > choose option replicate datasource

    Activate the infosource.

    6. Go to the scheduler for the infosource > select delta in the

    update >choose the option PSA only (in the Processing tab)

    start immediately

    Check the entry in the RSA7 in the OLTP(CRM system)

    Hope It helps You.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 05:24 AM


    How u r extracting data in to BI through BADI or any other extraction method?

    Check the record in CRMD_ORDER transaction,give the record number and check the respective field values are ther in CRM or not.

    If BP is not created for that transaction number then some fields wil be missed.

    In our project also v r facing the same issues,I created a flat file data source and uploading the data for the respective field through flat file manually.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sidarth..

      The BP is created and the Territory information is there in CRM.

      The only problem is it is not extracted when a transaction is first created.

      Once a change is made in the transaction,the territory information is coming with the delta.



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.