Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you add more details about your tables? fields for every table separately. so that it could be more easy to understand your need.
If possible can u share the table view of your data that will be more easy to understand and help you.
Hi Ashok,
Please share sample data, so that it will helpful for to suggest.
Regards,
@vi
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