Skip to Content
Product Information
Author's profile photo Elizaveta Kozhevnikova

Maintaining the mapping values with download/upload functionality – SAP S/4HANA migration cockpit

This blog post will give you an overview of the mapping values download/upload functionality. You will be able to see how to use this functionality with a practical example and discover all the possibilities and available releases.

Mapping upload/download functionality is available since SAP S/4HANA 2020 and SAP S/4HANA Cloud 2008. With this functionality you can:

  • insert mapping values
  • delete mapping values
  • replace the existing mapping values
  • confirm the uploaded mapping values at once.

Since SAP S/4HANA 2021 release, you can also:

  • delete the whole mapping task (with mapping values)

Please be aware that you can not delete the whole mapping tasks of a control parameter and fixed value type. Helpful KBAs:

  • Inserting and deleting entries for mapping tasks: KBA 3003068
  • Mappings with the control parameter and fixed value should be handled before uploading the file or before preparing mapping tasks: KBA 3076466

In the next paragraphs, I show you how to use the mapping values upload/download functionality.

Let’s assume, that for testing purposes, we have uploaded the data with the template files and deleted some of the data (some of the instances) from the staging tables. Then we repeated this step several times.

As you may know, when you delete the instances from the staging tables, the mapping tasks are not deleted automatically. Therefore, after the instance deletion, there are plenty of mapping tasks existing in the migration project. We aim to remove the unnecessary mapping values and handle the needed mapping values. As a result, we will get all the correct mapping tasks with the status confirmed and will not have any “dummy” values in our project.

In our project example, we see mapping tasks with different statuses – confirmed, error, to be confirmed.

To proceed with the simulation step, we would like to have all mapping values to be confirmed and the redundant values to be removed. We need to download the erroneous mapping values, edit them and delete redundant mapping values.

Redundant mapping values are those that refer to the instances that have been deleted and do not exist anymore in the project. In our example, the supplier instances SUP_100 – SUP_105 were deleted, but the mapping tasks are still existing in the project:

  • supplier instances = 69
  • supplier mapping values = 75

We also would like to delete these 6 mappings tasks for the suppliers (SUP_100 – SUP_105).

Step 1: Open the Mapping Tasks screen and choose the needed mapping tasks. Click Download Values. In this example, I have chosen the mapping tasks with the statuses “Error”, “To be Confirmed”. I have also chosen the “Mapping of Supplier” to delete the unnecessary values (the mapping tasks of deleted instances).

Step 2: Accept the warning message and open Monitoring screen to download the Zip file.

Step 3: Open the zip file with mapping values. Open the excel file “Mapping of Supplier” and unprotect the sheet under “Home, Format, Unprotect Sheet” for your convenience.

Step 4: Delete the mapping tasks for the suppliers (SUP_100 – SUP_105) and save the excel with a new name.

Step 5: Fill the remaining excel files with the mapping values. Afterward, you can compress the excel files to the zip folder for your convenience.

Step 6: Upload the Zip folder to your migration project (you can just drag and drop it). The excel files will be unzipped automatically.

Step 7: Choose options for confirming values “Confirm Values Automatically” and options for existing values “Replace Existing Values”. Select all the mapping tasks and click “Upload values”.

Done! The mapping values are successfully replaced and confirmed, and the unnecessary mapping values are deleted.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mark Kirkup
      Mark Kirkup

      Thanks for this write up, it was very helpful.  I have been looking for these functions and could not see them in front of my eyes.  I actually had to look twice even after seeing your training documentation.

      Thanks again for your valuable contribution to the support network.

      Author's profile photo Hubert Weber
      Hubert Weber

      Thanks Elizaveta for this helpful blog.

      During my project, I was asked if there is a log for changes in the mapping tables. This would be helpful to verify who created or changed the entries in the mapping tables.

      Do you know how to verify who changed what in the mapping tables?

      Any comment is appreciated.

      BR Hubert

      Author's profile photo Mark Kirkup
      Mark Kirkup

      Hi Hubert

      There is no logging of this area and this is where using the SAP ADM (Advanced Data Migration) offering from Syniti (formerly Back Office Associates) provides an advantage.

       

      Regards
      Mark