Skip to Content
Author's profile photo Former Member

Clear values in Lookup Field in SAP MDM through Import Manager.

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

Assigned Tags

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

      Hi Ankit,

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

      Regards,

      Rohini.

      Author's profile photo Former Member
      Former Member
      Blog 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,

      Author's profile photo Rahul Pandey
      Rahul Pandey

      Hi Ankit,

      Good Document!

      You can achive this requirement by using the below assignment too./wp-content/uploads/2014/03/assignement_412944.jpg

      Thank you

      Rahul