SQL tables used to extract the Bill of Materials

There are several tables you’ll need to dig through to get a BOM as you have in your image. I’d first investigate using one of the BomListProc stored procedures before trying to write your own query.

That being said, I recommend not querying the database directly. The IEdmBomView API object can get you what you need.