Skip to Content
author's profile photo Former Member
Former Member

How to search record in Sap MDM Data manager?

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:59 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 10:35 AM

    This forum Useful to me

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.