I am trying to find a table which has the material number field, the warehouse number and also which plant the warehouse is assigned to. I know how to assign a warehouse to a plant on customizing. I am trying to do a query for my client to view material records.
You need to combine two tables using a ABAP query to get the details.
The table MARD contains the plant + storage location for a material, and table T320 contains the plant+storage location assignment to warehouse.
So try to use MARA, MARD and T320 in the query to get the results.