MMS002 sorting order 2 selection on item number, shows all warehouses with item status per warehouse, acquisition code,...

Other option could be to use power query on table MITBAL.