I want to be able to extract a report like what shows in MD04, but I need it exploded until the highest level, to show the finished goods consuming this raw material, not just the next-level product (I tried to explain in the drawing below).
MD04 usually shows the requirements of the next stage in explosion only. I need some similar report, but I would like to see it exploded until the last level.
The outcome I'm looking for is hopefully something like this for Raw Material (RM01) shown in the drawing:
which I will then throw into Excel for further analysis.
I'm only a user not a developer in my company, so it's not possible to do a custom report. Is there any workaround I can use to get this info? Someone in another forum mentioned using COOIS or COOISPI, but I wasn't sure how to extract that info from there.
Any ideas will be really appreciated.