My requirement is:
We are using MRP Area for planning. When "MRP Area" is assigned in material master, the "Forecasting View" to be created using the daily background job (night job).
Assume the below example.
Today i have assigned MRP Area in the material master for 20 materials. And for those 20 materials "Forecsting View" to be created automatically with the night batch job.
Tomorrow i am assigning "MRP Area" for another 15 materials. And for those 15 materials "Forecsting View" to be created automatically with the night batch job. I should not consider the yesterday's 20 material also for today.
I am checking the table MDMA. In this table, i do not have field called "Created On". How to fetch the date on which the "MRP Area" view is assigned to materials?