Skip to Content
0
Former Member
Sep 11, 2007 at 01:22 PM

Complex data model question regarding master data

24 Views

Hi Experts,

I have a requirement to add master data retail price and master data cost into BW.

Both amounts are based on plant and material. How do I model this?

Here is how the records are coming in via the datasource:

Plant Material UofM Cost CostFrom CostTo Retail RetailFrom RetailTo

0001 1000321 EA $1.00 5/1/07 5/9/07 $2.99 6/6/07 6/9/07

0001 1000321 CS $8.00 5/5/07 5/7/07 $9.99 8/6/07 9/9/07

Here's what I am thinking....

1. Add UofM, Cost, and Retail prices as attributes of 0MAT_PLANT infoObject

Also make those attributes time dependent.

2. Use ABAP slit up the cost info and the retail info and use the valid dates above for the time dependent from/to dates in 0MAT_PLANT

Example:

0MAT_PLANT attributes:

Plant Material UofM Cost ValidityFrom ValidityTo Retail

0001 1000321 EA $1.00 5/1/07 5/9/07

0001 1000321 CS $8.00 5/5/07 5/7/07

0001 1000321 EA 6/6/07 6/9/07 $2.99

0001 1000321 CS 8/6/07 9/9/07 $9.99

After looking at the above, I need to compound UofM with 0MAT_PLANT somehow. How would I do that?

Is this the best way to model this?

Thanks,

Chris