Skip to Content
Technical Articles
Author's profile photo Sarah Vilarinho

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

Hello guys,

For you, that is starting to use Migration Cockpit 2020 now and want to use Direct transfer you might know that you can exclude some records from the selection in the Fiori app

Or you can use the functionality “Mass Processing”

However, this can be very slow in the process. So I recommend you to do this in the migration object in the backend. This tutorial will teach you how to do it in LTMOM.

 

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

Start the selection

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.

And that is it!.

Let me know if you have any questions or comments about the content.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andreas Keplinger
      Andreas Keplinger

      Dear Sarah,

      I have defined selection criteria in my migration project for Direct Transfer of Purchase Info Records by LTMOM as described in your Blog. I defined filter values for the field EINE-WERKS and the according preselection table /1LT/OTP00000506 was filled in the source system.

      Then I found out that data is missing and I changed the filter for EINE-WERKS to select also records where the field EINE-WERKS is empty.

      But when I redo the data selection in the migration cockpit the preselection table is not updated.

      How can I refresh the preselection table after change of filter criteria?

      Answer: I removed filter logic "WERKS" and left only the relevant values in the select option "Additional selection criteria". Then the preselaction table was updated.