Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Qualified table concept


I want to discuss, the concept of Qualified table in MDM 5.5.

Now, in my repository I have main table Business Partner which has a Lookup field Tax Number which is Lookup(Qualified-Flat) (multi-valued).

There are 2 fields in this table which are both Display field.

Tax Number is a Qualifier and Tax Number Type is Non-qualifier.

Now, for a record in Business Partner in Qualified Lookup field Tax Number, there are 4 values.

Tax Number Type| Tax Number

Permanent | 840987

Temporary | 432

Temporary | 432

Permanent | 5432

Now, according to Qualified table concept: For each association of Business Partner Record with Tax Number Type: Permanent or Temporary.

There should be a Tax Number as Qualifier. But it need not be unique. Then, the significance is, it as an association with the Tax number type.

Now, if we see from MDM point of view: The non-qualified value need not be duplicate.

So, my data is wrong but the values are Ok.


Kaushik Banerjee

Edited by: Kaushik Banerjee on Oct 14, 2008 12:46 PM

Former Member
Former Member replied

Hi Kaushik,

Tax Number Type| Tax Number

Permanent | 840987

Temporary | 432

Temporary | 432

Permanent | 5432

Two things I would like to share:

- When you select any data to be fit for saving in a qualifier table,you need to understand it very well.As given in your above example,Tax no type is the non-qualifier determing the Qualifier tax num.As far as i understand this data,it would not be absolutely correct to say that the Tax num type alone can determine the tax num.You can have all tax numbers either Permanent or temporary,but this alone cannot determine the tax number values.what i mean is that by jsut classifying the number as permanaent or temporary you cannot say the num to be so and so.In thsi case if you are saving this kind of data in a qualified table you may need another field to detrrmine the Tax num and the combination of the two of non qualifier field will decide the qualifier for all incoming records.

- When you import the qualified tabe,you will map the non qualifier.In this case out of your 4 non qualifier values only 2 will enter MDM as the matching field is tax num type and there are only two distinct values in this field.So in that case you will have two unique non qualifier values which will determine the qualifiers accordingly for all main table records

Hope It Helped

Thanks & Regards

Simona Pinto

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question