Selection Criteria for Delta loads triggered using MDM_CLNT_EXTR

[Former Member]

Hi ,

Currently we are required to load data only from two specific account groups . Therefore in the selection criteria in mdm_clnt_extr we maintian these two account groups and extract data.

However, when setting up the delta load there does not to be an option to restrcit the delta to a specify an criteria. Therefore, in our case several records from account groups which are not required are passed on to the MDM system.

Is there a way to address this requirement ?

1. There is an option to run the initial load variants at regular intervals, the problem with this is that in our case we have several variant creates as the R/3 system does not allows extraction on more that 999 records at a time. Therefore at point of time to capture the delta records , if we run all these jobs our network gets choked.

2. Run delta job, but without selection criteria it pulls out records which we don't require

Any suggestions on how this problem can be addressed are welcome ,

Thanks in advance,

Anita George

[michael_theis · Accepted solution]

Hi Anita,

MDM_CLNT_EXTR uses the ALE change pointers to collect all changes and send out the changed objects accordingly. As far as I know, it's possible to define the change pointer creation in ALE on a very detailed basis.

The question is: do you need change pointers for all of your objects? What do you do with those objects that are changed but as you say are currently not required? Will they be required later?

Could you explain your statement [quote]"as the R/3 system does not allows extraction on more that 999 records at a time"[/quote] in more details?

You should check if you can use

- ALE change pointer creation

- an appropriate XSLT on XI

- Import Managers filtering capability on look up values (see IM reference guide!)

for filtering.

BR Michael

[Former Member · Accepted solution]

Thanks Michael !

Well, regarding hte ALE settings, we did take a look in bd64 the filters are based on objects which one of these is relevant for customer account groups ? Probably in the future we would require all data, and then is it enogh to remove the filter ?

Can a filter be maintained at the XI level , this would be good as only the required account groups are passed on to MDM . Is there any documentation on available on this ?

Regarding the Import Manager, will have to check this functionality, as it is now no matter how many times we update the map/rename /load/unload it automated imports keep failing.

Our R/3 system seems to have problem extracting more than 999 records, as we tried with different number of records and all those extraction jobs got cancelled. So, currently we are running multiple jobs for the initial load and even this is very time consuming.

Thanks & Regards,

Anita George