How to search record in Sap MDM Data manager?

[Former Member]

Hi,

I am just beginner of MDM. I want to search record on Sap MDM Data manager tool. I found Search menu but i need steps to search particular record in MDM tables.can you please tell me the steps to search the record?

Thanks.

[Former Member]

This forum Useful to me

[Former Member]

Hi,

MDM Data Manager provides two types of Search Mechanisms

1. Drill Down Search

2. Free Form Search

Drill Down Search:

All types of lookup tables will participate in this type of search. Lookup tables are available on the left hand side in the Data Manager. When you select the particular value from the list, all the records which contain that value will only be visible. You can now select any value from another table and the output i.e. records containing the values from all the tables you have selected will only be visible hence the name Drill Down search.

E.g. Your repository contains 3 lookup tables countries, material type and material code. All these tables will be visible on the left hand side. Now when you select India from the Countries list, all the records having Country=India will be visible. Now select Material type=FERT then all the records having Country=India and Material type=FERT will be visible.

Free Form Search:

Appears on the left hand side after the lookup tables list and named as free form search.In this you need to type the value in the fields available and you will get the corresponding records. Select the proper criteria like equals, contains etc.

Regards,

Jitesh Talreja

[Former Member]

Thank you guys. It is useful to me.

[Former Member]

Hi,

Please Mark the thread as Answered and REWARD THE POINTS ACCORDINGLY.if your query is solved or else let it be open if you need some more help regarding this.

Regards,

Jitesh Talreja

[Former Member]

Hi,

MDM provides two type of search mechanism;

1.Drill Down search and 2.Free form search

Drill Down Search:

With drilldown search, you can make selections from each search tab, where each tab corresponds to a lookup field in the table (such as Manufacturer or Category). You can also make selections for each of the attributes linked to the selected category, and each of the qualifiers of a qualified table record. You can make selections in any order, to constrain the search results and converge on one or more products, and you can also remove search selections in any order to expand the set of search results and find similar products.

At each step along the way, the system narrows down the choice of values for each search dimension to show only those that are valid given the current result set based on the previous search selections. This is known as limiting and guarantees that you can never go down a dead-end path. For example, if you select Chain Saws in the Category tab, and then open the Manufacturertab, only the manufacturers of chain saws will be listed. (The specific names of tables and search tabs may be different in your particular repository). The result is an extremely flexible and powerful search capability, delivered through an exceptionally smooth and intuitive process.

Free form search:

With free-form search, you can perform searches on any field that does not lookup its values from a subtable. Free-form search also allows you to do u201Cfuzzyu201D searches with a variety of search operators; however, the down side of this approach is that you can also end up with no matching records, which cannot happen with drilldown search.

For eg.if want to search a record with ID 100 then you can just type value 100 against the field Record in the free form search.

Regards,

Kaushik Koli.