Response:

ManEx is available upon request to provide simple queries.  But when it involves MRP demands, that is anything but simple.  The method in which the ManEx system compiles the MRP information is very complex with 1000’s of lines of codes that the system goest through to provide the correct demand for the parts within the system.  Every file used by Inventory, Purchasing, Work Orders, Kitting, Sales orders and Forecasts are used in the MRP Generation. All information from each file is gathered and incorporated in the tables beginning with “MPS” and “MRP”. The data in these tables are further managed by logic rules that are very complex relationships.

ManEx does not have the resources to in providing the users with the Possible 1000’s plus line of SQL statements that would ben needed to get the end results of MRP, but if the nature of the information sought after is explained in further detail, there is the possiblity that more specific table/releationships can be provided.   

You may find partial answers in the tables mrpsch2 and mpract.