qualified table issue

[Former Member]

My excel sheet has 3 coloumns taxcategory taxclassification taxclassificationdesc

my main table come with fields countrycode classification and others

i need to model this in my repository

I have metioned taxclassification as my lookup qualified table with fileds

1 tax classification qualifier lookup flat taxtypes table

2 country code noqualifier lookup flat countries table

taxtype table fields taxcategory taxclassification taxclassificationdesc

when i load the values and see i find that this has been modelled incorrectly

because it should have the below relations ship

countrycode taxcategory taxclassification taxclassdesc

IN MWST 0 NO TAX

IN MWST 1 FULL TAX

IN GST 0 TAXABLE

IN GST 1 50 PERCENT TAX

IN GST 2 low TAX

US IST 0 NON TAXABLE

US IST 1 FULL TAXABLE

MX PGT 1 FULLTAX

MX CST 1 FULLTAX

etc

so under MWST should have look up values 0 no tax

1 full tax

gst 0 taxable

1 50

2 low tax

IST 0

1

urg pls

regds

ve

[Former Member · Accepted solution]

Hi Veena,

Currently You are in which version of SAP MDM 7.1 or 5.5 ????

Select Table Tuple instead of qualified table

Kindly Follow the step:

1. Create Tuple Table as TAX

2. Create fields TAX table i.e. taxcategory taxclassification taxclassificationdesc

3. Create field TAX DETAILS Type Tuple Multi value in main table and set Multi-Value = "Yes" in properties Pane

I have tested the senario and at my end and its working fine

Hope above point will resolve your problem if not revert back

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

Hi Jignesh,

I am currently working on 7.1 initial version

1. Create Tuple Table as TAX

2. Create fields TAX table i.e. taxcategory taxclassification taxclassificationdesc

3. Create field TAX DETAILS Type Tuple Multi value in main table and set Multi-Value = "Yes" in properties Pane

in the above solution by TAX DETAILS did you mean tax classification... if not pls explain TAX DETAILS part

also pls let me know how to load the data into the tuples, and is their any order to load tuples.

Also, when i created the repository a default categories taxonomy table is created, i wanted to delete this..... but gives me an error. Is this possible?

thanks,

ve

[Former Member · Accepted solution]

Hi Veena,

in the above solution by TAX DETAILS did you mean tax classification... if not pls explain TAX DETAILS part

No, I mean to create one field in main table and give name as TAX Classification, select Type Tuple Multi value

and set Multi-Value = "Yes" in properties Pane for that field

also pls let me know how to load the data into the tuples, and is their any order to load tuples.

No, there is no order you can load the data as you want

Also, when i created the repository a default categories taxonomy table is created, i wanted to delete this..... but gives me an error. Is this possible?

You donot require to delete the Taxonomy table, Create new table with Tax category with lookup type and assign to tuple table field TAX Category

Thanks,

Jignesh Patel

[Former Member]

Hi ve,

I am not able to understand your structure.

I have metioned taxclassification as my lookup qualified table with fileds

1 tax classification qualifier lookup flat taxtypes table

2 country code noqualifier lookup flat countries table

taxtype table fields taxcategory taxclassification taxclassificationdesc

these taxclassification are same or different.

Thanks,

Sudhanshu

[Former Member]

My excel sheet has 3 coloumns tax category, tax classification, tax classification desc.

my main table come with fields country code, classification and others.

i need to model this in my repository

I have metioned tax_classification as my lookup qualified table, with fileds

tax classification - qualifier, loopup flat , tax_types table.

country code - noqualifier, lookup flat, countries table)

tax_type table fields (tax category,tax classification, tax classification desc)

when i load the values and see, i find that this has been modelled incorrectly.

because it should have the below relations ship:

countrycode, tax_category, tax_classification, tax_class_desc.

IN MWST 0 NO TAX

IN MWST 1 FULL TAX

IN GST 0 TAXABLE

IN GST 1 50 PERCENT TAX

IN GST 2 low TAX

US IST 0 NON TAXABLE

US IST 1 FULL TAXABLE

MX PGT 1 FULLTAX

MX CST 1 FULLTAX

etc .

so, under MWST should have look up values 0 no tax

1 full tax

gst .... 0 taxable

1 50

2 low tax

IST .... 0

1

regds

ve

[Former Member]

Hi Veena,

because it should have the below relations ship:

I think in your countries table you should have Countycode as only Display field.

For Tax_Type, you should have tax category,tax classification, tax classification desc (all three) as Display fields.

Just check and revert with above changes, are you getting the required relationships or not.

Regards,

Mandeep Saini

[Former Member]

Hi Jignesh/Mandeep,

i have mapped the tuple fileds(TAX table) countrycode, tax_category, tax_classification, tax_class_desc,

But I do not see the import buttom highlighted to do the import.

am I doing something wrong, Is this tuple import like a flat lookup import?.... can you give me an example to do the import

I have done excatly what is told

1. Create Tuple Table as TAX

2. Create fields TAX table i.e. taxcategory taxclassification taxclassificationdesc

3. Create field TAX DETAILS Type Tuple Multi value in main table and set Multi-Value = "Yes" in properties Pane

thanks,

ve

[Former Member]

Hi Veena,

follow the step

1. First import data for Tax Category table as it's lookup table

2. then import tuple data example as follow

Material Number->Country->Tax_Category--->Tax_Class>Tax_Class_Desc

000000000010001-> IN-----> MWST -

---

> 0 -

---

> No Tax

000000000010001-> IN-----> MWST -

---

> 1 -

---

> Full Tax

000000000010001-> IN-----> GST -

---

> 0 -

---

> Taxable

000000000010001-> IN-----> GST -

---

> 2 -

---

> Low Tax

000000000010001-> US-----> IST -

---

> 0 -

---

> NON Taxable

000000000010001-> US-----> IST -

---

> 1 -

---

> Full Taxable

000000000010002-> US-----> IST -

---

> 0 -

---

> NON Taxable

000000000010002-> US-----> IST -

---

> 1 -

---

> Full Taxable

in above example Material Number is field of main table and all other are tuple fields map one to one field at destination side and select Material Number as Matching field in Match Records tab and import the data

Note : tuple records data can not import directly it require atleast one main table field and it should be display field then select this main fileds as matching field in match records tab then only it will allow to import tuple data

Thanks,

Jignesh Patel

[Former Member]

Jignesh and All

Thanks a lot

SOLVED.