Regarding CRM data extraction

[Former Member]

Hi,

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!

[Former Member]

HI

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.

Regards

Sridath..

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

Regards

Manjari

[Former Member]

HI,

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

activate.

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.

Regards,

Nagaraju.V