Indented BOM search by Material Part

[dr_dan (Dan Ramirez)]

Top Level Where Used Query

Oddly enough I had this asked of me today and I found my recursive BOM Explosion BAQ that this site helped me create. And I thought it’s really just the same thing in reverse. So I’m posting this here to help anyone who might find this thread and have some use. I’m also looking to see if I’m missing something important. But it looks to do what you’d expect. Essentially I just reversed the join on the recursive subquery from MtlPartNum = PartNum to PartNum = MtlPartNum. I also filter out inactive…

Check this out. It’s exactly what you describe. It starts with the indented BOM concept but instead joins the tables in such a way that it searches up. Try it out and let me know what you think.