Re-migrating records with migration cockpit

Sometimes in test and dev, we need to migrate the same content more than one time.

The steps to do it for any object are:

1st - Delete the records in the target.

2nd – Delete the records in the Migration Cockpit

The second step depends on the approach you are using for migrating your object.

While in the Migration cockpit 1909 version and older ones, it was not possible to migrate again the objects already migrated using the direct approach; in the newer versions (2020 and onwards), it is possible.

 

Direct approach

 

For deleting the records in the migration cockpit object, direct approach you will need:

1st - Execute report CNV_PE_MC_DEL_ITEMS (Transaction code SA38):

 2nd - Select the project ID

 

3rd – select the Migration object ID.

 

Uncheck “Test Run” option and check the “Delete also migrated instance”.

And that is it!

File/stage transfer

 For the file stage/stagging table approach, it is easier.

Go to the "select data" section and select all the records.

Click the option Delete all Records

 

Delete the old version of the template (excel file).

 

References

https://blogs.sap.com/2020/04/04/sap-s-4hana-migration-cockpit-direct-transfer-can-i-repeat-the-selection-1909/

 

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.

Handling Excel functions (Look-up Values)

 Hi guys, 

I took a bit to understand how the lookup function works in Excel, but after you know some tricks it is very useful (you can even use it in your little monster of 150K). 

Ok, first of all, you need to understand that the values to show in your "main table" need to be on the left of your sheet. I tried on a different sheet and it did not work. 

So the issue I faced was when I tried to identify in Excel if a Business Partner was, at the same time, Customer and Supplier. 

So as you can see in the picture for Business Partner 20 we have 2 entries that say the business partner is customer and 2 entries that says that the business partner is a supplier.

To fulfill the request I started by creating the  Business partner ID list in the column A (Home --> fill --> series

after that, I created two extra columns (B and C), B is for mark if the business partner was identified as a customer and C other if the business partner was identified as a supplier in the original data.

So doing an and between B and C I got the flag of the Business Partner as Customer/Partner  (column D)

Formulas used 

B: =COUNTIFS('All BPs'!E:E;'All BPs'!A2;'All BPs'!P:P; "*Cliente*")

C: =COUNTIFS('All BPs'!E:E;'All BPs'!A2;'All BPs'!P:P; "*Proveedor*")

D: = AND(B2;C2)

Lookup: =LOOKUP(E7;A6:A150005;X6:X150005) --> not sure that this is correct

I hope this is helpful. 

Soon or later you will have to use excel for some crazy requirement stuff. better know as much as possible.