Skip to Content
0
Former Member
Aug 09, 2016 at 01:38 PM

MB5M report export to Excel

7106 Views

Hello Peers,

I use MB5M code to run the pending expiry report every week. Every time, I have to copy and paste the material and batch associated with it to excel and then create a report in excel. It finds to me that this way is time consuming especially when the list of expiring products is large.

I tried customizing the layout to simplify the screen so as to copy only the material and batch at once, but it says I cannot change the mandatory filed (esp. material description - I do not need this).

Is there any way to export the list directly to excel, same as it works in other Tcodes?

Regards,

Anup