Skip to Content
0
May 30, 2013 at 09:26 AM

Uniqueness of a master data

32 Views

Hi experts,

I have to create a new Master Data in BW. The issue is that 5 fields ensure the uniqueness of a record, below an example:

account

func area from

func area to

profit center from

profit center to

virtual account

6010101

0

0

1050013

1050013

R96101M

6010101

39

1050013

1050013

R96101M

6010101

0

0

1100016

1100031

R96101M

6010101

39

1100016

1100031

R96101M

6010101

0

0

3010101

3010206

R96101M

6010101

39

3010101

3010206

R96101M

6010101

0

0

3010208

3031443

R96101M

6010101

39

3010208

3031443

R96101M

I tought about creating the green fields as compounding. What do you think? Is that technically possible? Any other ideas?

Thanks for your support.

Amine