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 J-MR Minimum Data Check for MRP Completeness . Monthly Special. This SQL shows products not having all the minimum data required for running MRP in SAP B1. Since it is an "Exception SQL", it can be the basis for an Alert Message after all products have been properly updated by the End User.