Skip to Content

ECC-CRM filter setting not working

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


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 21, 2013 at 01:56 AM

    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?



    Add a comment
    10|10000 characters needed characters exceeded

    • 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


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.