Inventory Consumption Report in Table Format

[jfry805]

I am searching for an inventory consumption report that can be exported to Excel in columns and rows. To date all the reports (MB51 for example) do not export properly to Excel for analysis. Can anybody provide an existing report that is exportable to Excel in columns and rows?

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[RAHEEL_BABAR]

Hi,

You can see material consumption and all movement of material by using the same t-code MB51.

You can see and import data in tabular format by using Flat List option as following.

Accept and upvote if it's helpful for you.

Regards

[RAHEEL_BABAR]

Furthermore if you haven't this option, after execute MB51 report you can click on this button and system will convert data in ALV format.