CRM DataSource Enhancement

[Former Member]

Hi,

I need to add a field to one CRM datasource(0CRM_SALES_ACT_1).I have done that using RSA6.Also written a code in 'EXIT_SAPLRSAP_001'.

The delta queue for this DataSource is working properly on CRM side but when I pull the same data to BW side it is not populating the added field.Also the added field is not visible in PSA - it is visible on CRM side.

Do I need to do something in SBIW?Please suggest.

Thanks,

Purbali

[Former Member · Accepted solution]

Hi Purabali,

To Populate the Enhanced Field of the data source...

-

---

Use the BADI - CRM_BWA_MFLOW

This Badi has a field C_T_DATA which you would use to populate the new field.

Reason for the new field not showing up...

-

---

There is a table ROOSFIELD which holds the properties of the fields of the Data Source.

Make sure that your enhanced field has the following properties set in this table...

Field SELECTION to be BLANK (make sure it is not 'A').

Field NOTEXREL to be 'Y' and not 'N'.

The above fields should be set for your data source field.

There are many notes available for the same.

Hope this helps.

Thanks & Regards,

Sh

[Former Member]

Hi Purbali Biswas/CRM-ABAP gurus

I need to add some Date fields to one CRM datasource(0CRM_SALES_ACT_1) .I have done that using RSA6. also created append structure for the same in structure CRMT_BW_DS_ACTIVITY .

Please tell me the logic to extract the custom fields to the data source 0CRM_SALES_ACT_1 in user-exit 'EXIT_SAPLRSAP_001'.

Expecting your valuable points.

My mail id: sankar.kannan@cognizant.com

Regards,

Sankar

[Former Member]

Hi

This should not be a problem (we do that all the time).

Try:

1. mmake sure you are viewing all the fields when looking at PSA. you can go to menu->Settings->Change Display Var

and make sure u choose the new fields for viewing!

2. make sure all the mapping are correct in Transfer Rules, Comm Struct, Upd Rules ETC.

3. Make sure u can see the fields via RSA3!

If you do then the problem is on the BW side.

Reg's

Edan

[Former Member]

Hi Edan,

I cannot see the field in display list using rsa3 but can easily see it in rsa2 (CRM Box).When I filter it from PSA I can see this field but it is not bringing the value.

But in CRM delta queue the field and its value can be seen.

Thanks,

Purbali

[Former Member]

Edan,

if you are able to see the data in RSA3, if you couldn't see in PSA. check this one:

<b>during extraction, the ALE userid may fails authorisation on getting this new datafield in the source system. check this one</b>.

similar issue resloved.

all the best.

Regards,

Nagesh Ganisetti.

[Former Member]

Purbali Biswas,

can you please try with BADI instead of User Exit. Today i saw 2 messages with same issue. every thing is correct but added field is not populated with data in BW. even in PSA.

I want to you to check with BADI and Let me know.

before doing this, make sure DS replicated and Transfer Rules Activated.

All the best.

Regards,

Nagesh Ganisetti.

[Former Member]

Hi Nagesh,

I am totally new to this CRM system .Can you please tell me how to preceed with BADI?

I have already replicated the Datasource and activated the Transfer Rule.

Thanks,

Purbali