Skip to Content
author's profile photo Former Member
Former Member

Initial Download (Filter)Error: R/3 to CRM 4.0

Hello

I want to bring customer master data from SAP R/3 to SAP CRM 4.0 using filter on country code 'US'. While creating filter i get this error- 'Object CUSTOMER_MAIN does not allow filter on KNA1.LAND1'. I am i doing any thing wrong. Can I create a filter for country codes, and account groups.

Good Day.

Thanks

Jay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2005 at 11:26 AM

    Hi Jay,

    Nope!

    you can only filter on the following fields of kna1:

    AUFSD

    BRSCH

    FAKSD

    KUNNR

    LIFSD

    LOEVM

    SORTL

    But you can use the PIDE transaction in R/3 to filter/map on account group, and use event CRM0_200 in R/3 to filter on the country. Take a look at function SAMPLE_PROCESS_CRM0_200 as example.

    Hope this helps,

    Grtz,

    Michael.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You'll need to create a Z-function with an interface like the sample function (simply copying it is the easiest).

      Activate the event using transaction FIBF in R/3:

      settings >> Process function modules >> of a customer (which is table TPS34). Enter process CRM0_200 with your z-function and a product which is activated in table TBE24.

      => this will call your function when you activate a download. You'll now need to code a filter (E_DO_NOT_SEND = 'X'), based on the object name (i_obj_name) and the contents of the bapi-structures (T_BAPISTRUCT).

      Be carefull! because this function will be called for each object that is interfaced from R/3 to CRM.

      Michael.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2005 at 02:27 PM

    Hello Jay,

    I think you could try maintaining table SMOFFILFLD with tx SM30.

    rgds,

    Didier

    Add a comment
    10|10000 characters needed characters exceeded

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.