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

Uniqueness in Qualified tables

Dear MDM experts,

I have this requirement wherein we have a qualified table wherein the user shouldnt enter duplicate entries.

e.g. in the case of customer master data,the user may have only 1 qualified table record per company code. (can have differnt company codes)

I have set Company code as an NON QUALIFIER but it does not enforce any kind of uniqueness.

<h5>Is it possible using qualified tables to have such an enforcement ?


Also as an alternate can I write a validation rule such that it will allow me to enter data in the qualified table only once per company code.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 04:21 AM


    Is your company code set to Unique Field in Console under your qualified table, if not then set it.

    Then DM will allow you to enter single record per company_code.


    Alok Sharma

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 28, 2008 at 05:08 AM


    First of all make your company code field as unique field then go through this link

    this might help you.Please reward if you find it useful.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      yes this will work in the case only, if you have your customer name as a master table field. Try this:

      1. Customer Name and qualified are two fields in Main table.

      2. In QT you have Comp_Code as unique Field as non qualifier and other data like company_name, Loc as non Qualifier or what ever you want.

      then DM allow you to enter same company code for two different records.

      now this is also possible that a person may have worked in 2 different organizations then you can put 2 records in QT and you can select them for a single customer.

      Rewards if found helpful.


      Alok Sharma

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.