SLT Filter for Initial Load and replication (DMIS 2011_1_731 0015)

[velsankar_sundar]

Hi Experts,

I am new to SLT filter Concept. We are replicating data to Central Finance (CFIN) target system from 2 different source systems ( source system 1 and source system 2). Please let me know how to do the filter.

1. should we do through LTRC.--> if yes how to do.

2. Should we do through MWB pre-delivered rules.

Below is the requirement. Please help in how to proceed and how to identify the source systems.

Source system 1:

• .For the cost object replication, order type 05 and 20 needs to be filtered. Also, any order data created for UY13 should not be replicated.
• .For Finance and controlling master data perspective transaction data perspective, any transaction posted in UY13 should not be replicated to central finance system.
• The above two rules are applicable for both initial load and replication.

Source system 2:

• Only cost object created under company code 4000 should be considered for replication. Also order category 20 should not be considered for replication.

• Transaction data posted only for company code 4000 should be considered for replication. Also the data posted beyond 1^st of may should be considered for replication.

Thanks in advance

[Andrey_M · Accepted solution]

Hi,

regarding filtering: in case of cFIN scenario you can't setup filter in LTRS, while SLT create a migration object as copy of pre-defined migration object. So, if you would like to create an additional filter you have to change the migration object or template of migration object directly with transaction MWB.

The template you can find in follow path: project ZIUUC_<mt_id>, subproject with templates ZIUUC_<mt_id>_TEMPLATE

Here you have to define the field-releated rules. HowTo documentation to the rule is pretty well. Please use one.

Regarding cFIN application - sorry, I'm not an expert in this area.

[velsankar_sundar]

Thanks Andrews. I tried the same way by going to MWB. When i tried to add filter in the rule SKIP_COBK. there is some existing code

IF _VAR_GV_COEP_FOUND_S eq ' ' AND _VAR_GV_COEPR_FOUND_S eq ' ' AND _VAR_GV_OTHERS_EXIST_S eq ' '. SKIP_TRANSACTION. ENDIF.

This is already there but shows error. If i want to put filter here on cobk. it is showing error. can you help.

[Andrey_M]

For this particular case (cFIN scenario) you can create a filter on every migration object in configuration, but in such case if will need to regenerate runtime object you will lost the filter. So, the better way is to setup filter on template. Run transaction MWB, select you project and subproject (see names in my first answer) and choose appropriate migration object (objects with *_L are designed for initial load, *_R - for replication phase). Then click EDIT, then button Convertion object. In next screen you can navigate to menu RULES and here you can create a new rule for your migration object that later will be copied into the real migration object. And here you can find the complete docu howto create any type of rule.

Please notice, if you later would like to upgrade the content objects then you will lost all those rules. So the better way to implement rule is to use include. Next time you have just recreate rule header and call the include again.

[velsankar_sundar]

Hi Andrews,

How to set filter based on source system.

[velsankar_sundar]

Thanks Andrews for the reply