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

[Former Member]

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

[Former Member]

Hello Jay,

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

rgds,

Didier

[Former Member]

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.

[Former Member]

HI Michael,

Thank you for the info.

Pls could you give some instruction how to use event CRM0_200.

Regards

Jay

[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.