Below is a listing of SQL which you can review for ideas or use in your SAP B1 System:
(Back to SAP B1 SQL Tips and Tricks Main Page - SAP B1 SQL Tips and Tricks )
SAP B1 SQL I-PR Components within Bills of Material for Any or All . Frequently Requested SQL. This is a simple SQL view which shows all the Bills of Material associated with a specific product code or all product codes with their assoicated Bills of Material. There is a good example of how to use LIKE in the WHERE clause that allows for a variety of selection entries.
SAP B1 SQL I-PR To Check the Components upto 6 levels deep into a BOM . Useful SQL. This SQL will list all the components (upto 6 levels deep) for the selected Parent (father) item. I frequently saw in the Forum that some people needs to run the MRP for specific Sale order or for specific items. This query won't fulfill their needs but it is surely helpful for those kind of scenarios.