I need a report/table which lists all the materials with their last movement date.
For example a material "A" has postings (GR, GI etc) made on:
06/01/2008 - 125ea
06/03/2008 - 50ea
06/09/2008 - 100ea
I need the report to show material number along with the most recent posting date. In this case i need "A" with 06/09/2008 posting date in the output of report/table. MB51 and MB5B doesnt help as i need the entire list of materials with most recent posting date.
Any input is highly appreciated.