Report is taking too long time. Please advice
I have created a report which is almost exploding the BOM and getting the all
material documents from MKPF for the given date and then based on those material documents selecting the 601 (Sales) from MSEG. Later based on the material, batch and 901 its drilling down. If it gets the raw materials in that, add those otherwise again if you find some FG or Semi finish in that further explode it.
like that this will go to the deeper level.
I have run this report for almost all the plants and they are updated successfully
but some plants are there which might have the large data due to drill down batch level. So atlast giving the dump.
Please suggest me how get it tuned so that my all plants give the data is speedy way. Thanks in advance.