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.
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.