I needed a quick way to pull Bill of Materials (BOM) for a group of finished goods to help calculate turns of raw material. I borrowed this from WIKI A bill of materials or product structure (sometimes bill of material,
XA (MAPICS) SQL to pull 10 levels BOM
![XA (MAPICS) SQL to pull 10 levels BOM XA (MAPICS) SQL to pull 10 levels BOM](https://code400.com/wp-content/uploads/2019/08/girlface.png)