4 Replies Latest reply: Jul 24, 2014 3:35 AM by ashok Velisetty RSS

    Suggest Best Data Modeling in this situation??

    ashok Velisetty

      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.