ECC-CRM filter setting not working

[sunsapblr]

Hi All,

We have a strange issue in the middleware.  In CRM system, the sales orders are supposed to be come  for Japan only. 

But we have huge number of orders flown to CRM from R/3 with transaction types not maintained in CRM and for other countries also.

I have done the following checking.

CRM Side

------------

1.Checked the filters in R3AC1 and found it is correctly maintained.

2.Checked the SMOFFILFLD table and it is also fine.

R/3 Side

----------

1. As per note,788822  the following tables checked.

   CRMPAROLTP table- CRMfiltering is active

   CRMFILTAB     table-Check if the table entries in the R/3 are synchronous

                                        with the table entries of the SMOFFILTAB : Both tables are in sync

Help Appreciated.

Thanks & Regards

Sunil

[nicolas_busson · Accepted solution]

Hi Sunil,

You can try to set a breakpoint in function module CRM0_READ_CRMFILTAB (or CRM_FILTER_DOWNLOAD_DATA) on ECC and create a sales order to check why it is replicated to CRM. Sometimes it's just missing leading zeros that cause filtering not to work, or a field that was added to SMOFFILFLD when the corresponding extractor on ECC does not support it... So could you please add a screenshot showing the table & field that you added to R3AC1?

Cheers,

Nicolas.

[sunsapblr · Accepted solution]

Hi Nicolas,

Thanks for the quick reply.

We had deleted some entries from the table CRMRFCPAR which were having the field DISCARDDAT='X'.  Now these entries got deleted, CRM system is flooded with orders.

So we have requested for reverting this change to this table + add entry to for this CRM with DISCARDDAT='X'.

Once this is done, hopefully issue will be resolved.  I will let you know, once completed.

Thanks & Regards

Sunil