Suggest Best Data Modeling in this situation??

[#1]

Hi All,

I have four tables

1.Material Base (like master)it contains "plant&material". it doesn't contain year and month.

2.Mard

3.Mssl

4.ZZMM

rest of the three contains plant,material,year&month.

In the front end we need to use plant,material from "Material Base" only and common year and month for all tables.

we need to show mard-stock separately,Mssl-Stock separately and ZZMM-Stock separately for plant and material wise which is coming from Material Base table.

What i did : created hard coded master calender and outer join with Material Base table after that i given link to all other tables with "Plant&Material&year&Month". But i think this is not accurate because with out any reference i joined calender and Material base table.

so suggest me any good way.

Thanks in advance,

Ashok.

[umerikhlas]

Can you add more details about your tables? fields for every table separately. so that it could be more easy to understand your need.

[#3]

If possible can u share the table view of your data that will be more easy to understand and help you.

[avinashelite]

Hi Ashok,

Please share sample data, so that it will helpful for to suggest.

Regards,

@vi

[#5]

Material Base-Table

Plant , Materialgroup , Material

MARD-Table

Plant  ,Materialgroup, Material,  Year,  Month , Stock

MSSL-Table

Plant  ,Materialgroup  ,Material,  Year,  Month,  Stock

ZZMM-Table

Plant , Materialgroup , Material  ,Year , Month , Stock