Skip to Content
avatar image
Former Member

How to replace a qualified table with Tuple

Hi Experts!

I have a Qualified table woth 2 non qualifiers,which refer to 2 lookup flat table and one text field which is Qualifier.

Now I want to replace this design with tuple.Please give me steps to do so and also how is the linking of field relation maintained in Tuple.

Thanks

Ravz

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 07:00 AM

    Hi Ravz,

    Please refer the complete section 5. Migrating from Qualified Lookup Table to Tuple

    Here, must check Page No 48/58 example for converting Qualified tbale to Tuple. It will solve your problem.

    Sample: Manufacturer Part Number (MPN) in standard Products repository

    http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80765a21-78f3-2b10-74a2-dc2ab57a1bd2?quicklink=index&overridelayout=true

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 03:52 PM

    Hi Rav

    To add-

    Before doing the schema changes- remodeling in the repository data model also export the qualified table data into a separate excel file and then use the same file for reloading the values.

    thanks-Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 06:44 PM

    Dear Ravz,

    In addition also when you remodel your qualified table into a tuple: There will be no qualifiers and non qualifier fields.

    Regards,

    Pramod

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 10:05 AM

    Hi,

    To convert from qualified table to Tuple there is not such automation or option available, you require to build tuple table from scratch.

    to create tuple table Step as follows

    1. Create Tuple table in MDM Console

    2. Assign fields to Tuple table

    3. Create field in Main Table (Product) and Type = "Tuple", Tuple = "Name of Tuple Table"

    Thanks,

    Jignesh Patel

    Add comment
    10|10000 characters needed characters exceeded