Activities : 0CRM_SALES_ACT_1

[Former Member]

Dear all,

I need to extract the Activities from CRM to BW. This data must be extracted with the standard extractor 0CRM_SALES_ACT_1, in the ODS 0SAL_DS01, then in the InfoCube 0CSAL_C01. When I test this extractor in RSA3 (in CRM), I obtain "720 records", but when I want to extract the data in BW (from the InfoSource 0CRM_SALES_ACT_1 to the ODS 0SAL_DS01), I obtain "0 record"...

Does anybody know how to resolve my problem?

Thanks

[former_member188975 · Accepted solution]

Hi Aube,

Is the load process still running (yellow in the monitor)? This extractor takes a long time to complete the job...

[Former Member · Accepted solution]

Hi Bhanu,

In Fact, I tried a full update and in the monitor, it's still yellow but I obtain the following message :

"No data available

Diagnosis

The data request was a full update.

In this case, the corresponding table in the source system does not

contain any data.

System response

Info IDoc received with status 8.

Procedure

Check the data basis in the source system."

Then I tried to do an Initialization, and I obtain exactly the same thing...

[edwin_harpino · Accepted solution]

hi,

we encountered the same, there is data with rsa3 but no data extracted to bw, solved with oss note 669436, try to check CRM_SALES_ACT_1_MAP function module ....

Symptom

Tasks (activities) are not available in SAP BW Content, since they are already filtered out during extraction in CRM. Therefore, analysis or reporting is not possible for tasks in BW.

Other terms

Extraction, tasks, Case Management

Reason and Prerequisites

Tasks are filtered in the standard installation and therefore cannot be reported in BW.

Solution

To perform task analyses as part of Case Management, make the following adjustments in CRM and BW:

1. Make adjustments in CRM

In CRM, adjust the following part of the CRM_SALES_ACT_1_MAP function module (in the area of line 170-210):

>> LOOP AT ls_bdoc-activity_h INTO ls_activity_h.

>>

>> .....

>> MOVE-CORRESPONDING ls_activity_h TO extract_data.

>> READ TABLE ls_bdoc-orderadm_h INTO ls_orderadm_h

>> WITH KEY orderadm_h_guid = ls_activity_h-orderadm_h_guid

>> BINARY SEARCH.

>> IF sy-subrc = 0 AND NOT

>> ls_orderadm_h-object_type = gc_object_type-task.

>> ......

Replace the last two lines with:

> > IF sy-subrc = 0.

After you make this change, both the CRM business activity (object type 'BUS2000126') and the CRM task (object type 'BUS2000125') are extracted with the '0CRM_SALES_ACT_1' DataSource.

[Former Member · Accepted solution]

Thanks, I read the OSS note 669436. How can I change the CRM_SALES_ACT_1_MAP function module? Which transaction is it?

[former_member188975 · Accepted solution]

You can change the mapping module in SE37...but are you using tasks (BUS2000125)?

[edwin_harpino · Accepted solution]

system will ask for 'access key' in se37, please provide the R3TR FUGR ... to your basis to get the key.

please don't forget assign points if it helps or solves the problem.

[Former Member · Accepted solution]

I don't think I am using task. I looked in RSA3, and in my records, I have only BUS2000126, BUS2000116, BUS2000120, BUS2000115... I think I will try to make the changes in the function module, but I'm not sure it will solve my problem.

[Former Member · Accepted solution]

I changed the CRM_SALES_ACT_1_MAP function module (as in the 669436 OSS Note), then I tried to extract again the activities, but there are still 0 records in BW.

[edwin_harpino · Accepted solution]

hi,

have you re-activate the function module ? think it should solve the problem.

[Former Member · Accepted solution]

Yes of course I have re-activated the function module, but it still doesn't work... I'm not sure that I'm using task, because in RSA3, I have no record with BUS2000125.

[edwin_harpino · Accepted solution]

re-save the datasource, transaction bwa1, bwa5, replicate in bw, re-activate ?

[Former Member · Accepted solution]

Yes I did all that but there is still the same problem

[Ashwin · Accepted solution]

Hi!

just to be clear with the problem.check the data from full update to confirm whether the records that you get are of type activities.

with regards

ashwin

[Former Member · Accepted solution]

Hi Ashwin,

I don't understand what you say. I get 0 record when I try to make a full update in BW, so I can't check the data!!! But when I test my extractor in RSA3 (in CRM) I obtain some records.

Aube

[Former Member · Accepted solution]

Hi A.H.P,

Is it necessary to make ALL the adjustements given in the 669436 OSS note, or is the first point (adjust the function module) sufficient? I've only made adjustement in CRM_SALES_ACT_1_MAP, I didn't do the point 2. to 5.

Thanks

Aube

[Former Member · Accepted solution]

Hi Aube,

here we have a BW 3.5 connected to a CRM 3.0 with the same data flow that you have and we never had taht problem... this extraction has always worked right.

About the note, I havent read it, but probably you need to apply all the points.

About the extractor, what happens to us is that it takes a lot of time to load, last load was 54 hours for 502000 records. Does someone has the same problem? or better... someone knows how to fix it!??!

[Former Member · Accepted solution]

Hi Ignacio,

I think you should read the OSS Note 829397 : "Activity extraction takes a long time". I don't have this problem, but I read the note and I think it should help you.

Good luck

Aube

[Ashwin · Accepted solution]

Hi!

What I want to know is when you are testing the extractor in RSA3. whcih kind of recrds are displayed. you can check the field Business process type. are all of them activities or not.

do you have any selections in infopackage?

669436 note is solution to extract Tasks (which are a category of Activity) into BW. I dont think 669436 is relavent for your problem.

with regards

ashwin

Message was edited by: Ashwin Kumar Gadi

[Former Member · Accepted solution]

Ashwin,

As I said, when I'm testing the extractor in RSA3, I have BUS2000126, BUS2000116, BUS2000120, BUS2000115 in the field Business Transaction Type. I don't know if all of them are activities.

Furthermore, I didn't make any selection in my InfoPackage.

I don't think either that note 669436 can solve my problem, because I do not have any BUS2000125 in my records in RSA3.

With regards

Aube

[Ashwin · Accepted solution]

Hi!

normally you must get all the objets of type BUS2000126 into BW. is 0crm_sales_act_1 is active in BWA5 and can you see the mappings in BWA1. check the tables SMOXHEAD_s and SMOXRELP_S.

with regards

ashwin

[Former Member · Accepted solution]

Yes, 0crm_sales_act_1 is active in BWA5 and there is a mapping in BWA1.

The table SMOXRELP_S contains the mapping like in BWA1.

In the table SMOXHEAD_S, I have :

- structure = CRMT_BW_DS_ACTIVITY

- SELFUNC = CRM_BWA_INIT_BUS_TRANS

- MAPFUNC = CRM_SALES_ACT_1_MAP

- FUNCSTAMP = 0

- DELTA = X

- CANCELFLD = RECORDMODE

[Ashwin · Accepted solution]

Hi!

I dont find any problem with settings as per your description. Can you check your data source once again in RSA3 with Process_type filetered to 00000 activities.

check the CRM transaction CRMD_BUS2000126 - Maintain Activities and check if you have any activities in the system.

with regards

ashwin

[Former Member · Accepted solution]

Ashwin,

What do you mean by "Process_type filtered to 00000 activities"???

I check the CRM transaction CRMD_BUS2000126, and there are a lot of activities in the system.

Best regards

Aube

[Ashwin · Accepted solution]

In RSA3

selections the field OBJECT_TYPE is not available and hence we can make selections only with PROCESS_TYPE field and the value "0000" for General activity and "0010" for general activity so I wanted you to select these values to filter activities in RSA3.

with regards

ashwin

[Former Member · Accepted solution]

I went in RSA3 and I filtered with the OBJECT_TYPE. With the value "0000" I have 3 records, and with the value "0010" I have 1 record, for a total of 837 data records.

[edwin_harpino · Accepted solution]

hi Aube,

for our case, we just make adjustment point 1.

in our customer message, oss also suggest to review 618953 and 615670

[edwin_harpino · Accepted solution]

hi, sorry i didn't finish read the message

0000150315 BW-Authorizations for Remote-User in BW and OLTP

0000444261 BW DeltaQueue: No data is extracted

0000529789 BW extraction/extractor checker differences

0000555229 IDocs hang in status 64 for tRFC with immediate processing

0000615670 Authorization check in operational reporting

0000618953 Authorization check activated in operational reporting

0000655872 Error in extracting CRM transactional data

[Former Member · Accepted solution]

Thanks A.H.P,

I'm going to take a look at those OSS Notes.

[Ashwin · Accepted solution]

Hi!

check this note 692195 Q2.here is extract from this note

<b><i>Question 2 : On executing transaction RSA3 I get records but I find 0

records when I load data from BW request.(No Data Available)

Suggestion 2: First check if there are any entries in the table

CRMD_ORDER_INDEX.Only if there are entries in this table you can

extract records.

If this is not the case then,

It is possible that the user does not have sufficient

authorities for extraction of the relevant objects.

Additionally, please review and implement the following notes

615670

161570

150315

618953

If you are in the release 4.0 then

To do BW extraction with the user please see that the following

authorization object exists(display mode is enough):

CRM_ACT, CRM_OPP, CRM_LEAD, CRM_SAO, CRM_SEO, CRM_CO_SE, CRM_CO_SC

CRM_CO_SA, CRM_CON_SE, CRM_CMP, CRM_ORD_OP, CRM_ORD_LP, CRM_ORD_PR

CRM_ORD_OE, CRM_CO_PU, CRM_CO_PD, CRM_ORD_PO

(all these objects are linked to transaction crmd_order).

Question 3 : The Deltas for my data source are not extracted . What can I do?

Suggestion 3: Please check the following.

Please Check if the services have been generated in transaction GNRWB.

If they are not active(not marked 'X' before their names) then activate

the services following the steps here.

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

infosource > 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)

Question 4: How can I extract the fields, which are not provided in the standard data source extraction .

Suggestion 4: Follow the steps mentioned below.

1. Enhance Extract Structure with the required fields. (Create & include

an append structure to the extract structure via transaction RSA6).

2.a) Release the fields of the append for usage. ( To do this, double

click on the Datasource and remove the flags in the column 'Hide

Field' for all fields of Append. )

2.b)If the new fields cannot be seen in the extract structure of

the transaction BWA1 then change and save the datasource, and then

activate it in RSA6.</i></b>

with regards

ashwin

Message was edited by: Ashwin Kumar Gadi

[Former Member · Accepted solution]

Thank you very much, we have search for so long and we couldnt find that note.

Our system department has it now, i hope it will reduce the time.

[Former Member · Accepted solution]

Hi Ashwin,

Thank you for your answer concerning the note 692195. I thought it could solve my problem because the description of question 2 was exactly my question, but I check the table CRMD_ORDER_INDEX and there are entries in this table... So it doesn't seem to be an authorisation problem

[Ashwin · Accepted solution]

Hi !

I think this is the authorization problem for background user. just go thrught the other notes refered in the solution.

with regards

ashwin

[edwin_harpino · Accepted solution]

hi Aube,

can ask your basis to grant full authorization SAP_ALL temporary to the ale/background user ?

[Former Member · Accepted solution]

Thank you Ashwin and A.H.P!!!

You were right, is was an authorization problem. I put the authorization "SAP_ALL" to the ALE user, and now it works!

The problem is, it is not very safe to let a "SAP_ALL" authorization... What do you think about that? And I have no idea of which authorization I should put...

Aube

[Ashwin · Accepted solution]

Hi!

We have already discussed about using SAP_ALL for ALEREMOTE user for extraction. As far as remember some one from SAP gave a reply for how to overcome the problems and how which profiles to use. just search the forum for the records from feb or march 2005.

with regards

ashwin