How to do a pre-selection of records in the direct approach: Migration Cockpit 2020

 

Requirements

Direct transfer project with the object you want to filter created.

Scenario

Let’s suppose that you want to load in the target only the Master Banks information with Country Key "DK" using direct approach transfer with Migration Cockpit.

Tutorial

This example is done for Master Bank object:

Go to the transaction LTMOM in the backend:

Choose your project where you have your Migration Object to be migrated:

Choose the object to filter.

Go to source tables and select the root node. Select the field to filter. Put the migration object in the change mode (ctrl +F1)

If you select more than one value to filter, after executing, it will appear just the first value but don’t worry; all values are selected.

The fields with filters will have the select checkbox black.

Save and put the object in the display mode again (ctrl + F1) 

Go to the Migration Cockpit

Choose your project

Click select data

The activities running will increase.

You can check if the selection is right by clicking in “Instances” (even during the selection running):

After the running activity is finished, you can proceed with the mapping.