Skip to Content

The behavior of checkbox (aka. indicator, boolean, etc.) fields in the C4C Migration Workbench can be confusing when using the modify mode. With this blog post I want to explain the behavior.

C4C Migration Workbench – Modify Mode

The Modify mode is used to update individual fields of already migrated records, e.g. update the ABC-Classification of an already migrated Account. You can change the migration mode for each migration file in the Properties window, which opens when clicking on the Properties button.

Don’t confuse the Modify Mode with the Enhance Mode, which is used to upload new entries in sheets for already migrated objects, e.g. upload additional Addresses for an already migrated Customer.


The description of the Modify mode says Migration mode to modify field contents only for those fields for which there is an entry in the template. Blank field contents are ignored. For example, to populate new field extensions. – But this is not valid for checkbox fields, like the Prospect field in Accounts. – This is what this blog post is about.


The Migration workbench knows 2 values for checkbox fields, “X” and “empty”. Where X means true (checked) and empty means false (unchecked). Given that, checkbox fields are never considered as blank. This means that if you leave a checkbox field empty while using the Modify mode, the field will be set to false – no matter what the value was before.


In my previous example, where I want to update the ABC classification (or any other field on the root node) of an account which has the Prospect flag checked (= true), I must maintain the Prospect field as X in the migration file for all records where the Prospect flag shall remain checked. Otherwise the empty value in this record will be interpreted as false and the Prospect becomes a Customer by mistake.


This behavior is valid for all other checkbox fields (standard and custom) in all other migration files as well. – be aware of it when using the Modify mode in the Migration Workbench.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. rindang cahyaning

    hello, where i can find the migration workbench?

    Here we need to migrate copied data from test tenant to production tenant,

    thank you šŸ™‚

     

    (0) 
    1. Eduard Stelle Post author

      Hi Rindang,

      you can find the Migration Workbench in the Activity List of the Implementation Project.

      • Navigate to “WoC Business Configuration” > WCView “Implementation Projects”
      • open the Activity List of theĀ current Project
      • select tab “Integrate and Extend”
      • open a activity of type “Data Migration”, e.g. “Migration of Customers”
      • open the migration tool > the Migration Workbench opens in a new browser window

      I hope this is helpful.

       

      Regards,

      Eduard

      (0) 
  2. Krishnendu Laha

    Hello Eduard,

     

    Thanks for the blog but I think this is an error from SAP side as programmatically there should be way to handls this behaviour. I mean when “Prospect ” was not added in Excel sheet it should not simply update the record.

     

    Could you please raise an Incident at SAP and parallel raise an Idea in idea.sap.com?

     

    Thanks for your effort in advance.

     

    Regards,

    Krish

    (0) 

Leave a Reply