Skip to Content

This blog explains how to export/select records which are not available in any of the Masks. Till the time I didn’t find this Modify Mask Functionality, it was looking quite difficult to achieve within MDM and needed lot of thinking. So just check it out how this Property enables select/export of records which are not available in any Masks using Another Mask “Records without Mask“.

I am taking example with two masks (Mask1 and Mask2), you can do similarly as per your number of Masks maintained in MDM Data Manager.

Logic is pretty simple: Records without Mask = Total number of records in repository – Total number of records in Mask1 – Total number of records in Mask2

Procedure:
Firstly, create a new Mask Named say Records without Mask in Masks table when you select Masks table as your current table as shown below:

Masks Table

Now again select Main table as your current table. Now reset search which will show X of X records (all records available in your data Manager), Go to Records Pane, Select all the records by using Ctrl + A, then right click–>Add to Mask–>Records without Mask. So this Records without Mask contain all the records of your repository.

Now in Search Prameters, select Mask1 which show number of records available in this mask out of Total number of records in Data Manager. Go to File–>Export To–>Text as shown below.

Text

A pop-up window will come, Here just select a single field ( Fields to export from Available fields) which has unique value for each records available in your data Manager. It may be your Display field (DF).

popup

A Text file will be exported out of SAP MDM Data Manager containing all records available in your Mask1. Similarly you have to do for the remaining Masks. I mean here for Mask2 as well. 

Now you have two local Text files available on your desktop corresponding to number of records available in Mask1 and Mask2.

Now Go to Data Manager–>Reset Search. Afterwards Go to Records–>Modify Mask

left

Once you click on Modify Mask a pop-up window comes as shown below. Modify Mask–>Select Operation Remove (radio button) and source Records from file(radio button)–>Also make sure you selected masks as Records without Maskfrom Available masks and then Press OK. Select the Mask1 Text file and thats it.

Modify Mask

Now, you will see that now the records from Mask Records without Mask has reduced because you have subtracted the number of records which are available in Mask1.

Simialrly you again do it for the remaining mask, here for Mask2 that is Go to Data Manager–>Reset Search–>Go to REcords–>Modify Mask–>Select Operation Remove (radio button) and source Records from file(radio button)–>Also make sure you selected masks as Records without Mask from Available masks and then Press OK. Now mask Records without Mask will have the exact number of records which are not available in any of the mask.

Note: Even if you have some common records available in both Masks that is Mask1 and Mask2, you do not need to worry. It works fine.

Scenario Example: I have say 10 records in data Manager.
Material number (DF):
Mat No. 1
Mat No. 2
Mat No. 3
Mat No. 4
Mat No. 5
Mat No. 6
Mat No. 7
Mat No. 8
Mat No. 9
Mat No. 10

After exporting records for Mask1 say it has these below records.
Mat No. 1
Mat No. 2
Mat No. 8
Mat No. 10

After exporting records for Mask2 say it has these below records.
Mat No. 3
Mat No. 4
Mat No. 8
Mat No. 9

Here, though Mask2 has common record Mat no.8 which is already available in Mask1, it will not fail when you do Modify Mask operation remove, records from file for Mask2.

So once you created a Mask say Records without Mask containing all the 10 records. You need to remove records from Mask1 which will result in 6 records that is 10-4 = 6

When we do it for Mask2, though it is containing 4 records but one record Mat No. 8 already removed because of Mask1, so it will subtract 3 records. That is 6-3= 3. So now you will have Mask Records without Mask containing only 3 records which is required and desired result.
Mat No. 5
Mat No. 6
Mat No. 7 

So in this way, you can export these records available under mask Records without Mask using SAP MDM Data Manager or MDM Syndicator.

To report this post you need to login first.

3 Comments

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

    1. Mandeep Singh Saini Post author
      Thanks Shiv,

      Further, if we want less time to do it. I think we can do it without exporting and importing files too.

      Approach2 (Not mentioned in blog): 1stly, Create a Mask “Records without Mask” which should contain all the records available in repository.

      In Search Parameter’s: Select all the Masks using Ctrl+A which will display all the records available in Masks (This is a sort of drill-down search by selecting all the masks under search parameters). Now using Modify Masks, Select Mask as “Records without Mask”, Operation as “Remove” and Select source as “Search Results” which will remove these search records (done using Drill-down search earlier by selecting all masks using Ctrl+A). Thus this way also we can do it and can reduce time consumed while exporting and importing all Mask text files.

      (0) 

Leave a Reply