Skip to Content

This document explains how to clear a value from lookup field from backend i.e. Import Manager.

Suppose Currency is a not changeable field for the End-User i.e. cannot be changed by end user after initial approval of record or even if it’s a changeable field user cannot set blank value in that field since blank entry cannot be maintained in lookup table, hence field cannot be set to blank from data manager.

Now my requirement is that I want to clear the value from field Currency.

/wp-content/uploads/2014/03/1_409569.jpg

Create a excel file with Unique Field(SAP MDM ID) and required field(Currency) as blank.

/wp-content/uploads/2014/03/2_409570.jpg

Now, map the required fields in Import Manager.

/wp-content/uploads/2014/03/3_409586.jpg

Since the required field is lookup field so we need to map the destination value. Now we doesn’t have blank value in our lookup table. So the first thing we try is to map it with null any try to execute import, but unfortunately the values doesn’t get updated.

The solution is to Set NULL Interpretation appropriately in Map Fields/Values Pane, Destination fields section, setting it as Overwrite in currency field will serve the purpose.

/wp-content/uploads/2014/03/4_409587.jpg

Now again Map the blank value to <null> and set NULL Interpretation as Overwrite and Execute Import

/wp-content/uploads/2014/03/5_409588.jpg

Now, if you check in Data Manager the Currency is set to blank.

/wp-content/uploads/2014/03/6_409589.jpg

To report this post you need to login first.

3 Comments

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

  1. R J

    Hi Ankit,

    Nicely explained the procedure to clear the lookup field values. This document is helpful for new comers.

    Regards,

    Rohini.

    (0) 
    1. Ankit Negi Post author

      Hi Rohini,

      Yes this document is intended for new comers in MDM, since i faced such kind of situation while working on a project in my early days, i thought it will be useful to document it.

      Thanks & B. Regards,

      (0) 

Leave a Reply