Skip to Content
0
Former Member
Oct 21, 2009 at 10:54 PM

Master Data Validation

20 Views

Hello All,

I have a requirement in product maintenance..

Let me explain..

I have products created with different product categories.

Say for e.g:

Product Category1-->Product 1

Product Category2-->Product 2

Product Category3-->Product 3

And for each product category there Is an attribute value called product type maintained in Product masters like

Product masters with Product Category1 will have Product type1

Product masters with Product Category2 will have Product type2

Product masters with Product Category3 will have Product type3

So the above example becomes like

Product Category1 > Product 1 >Type1

Product Category2 >Product 2 >Type2

Product Category3 >Product 3 >Type3

I need to write a data validation programme that checks product in such a way that

Product1 created using Product Category1 should only have product type1 and not other product types 2 or 3.

How do I achieve this?

Thanks in Advance and awarded for sure

Arshad

Edited by: arshad ahmed on Oct 22, 2009 12:55 AM