Where would it be better to run a report that contains calculations and returns a large amount of data in BW or MB51?
I know, it depends on several factors, such as the size and complexity of the data, the processing power and memory capacity of the systems involved, and the specific requirements of the report.
SAP BW (Business Warehouse) is a powerful data warehousing and business intelligence tool that is designed to handle large amounts of complex data and perform complex calculations and analyses. It is optimized for reporting, analysis, and data mining, and provides a range of tools and features to help users extract insights from their data.
MB51, on the other hand, is a transaction code in SAP that allows users to view material documents and stock balances in SAP. It is primarily designed for inventory management and tracking, rather than reporting and analysis.
As SAP consultants, can I have your views on this matter?
Thanks in advance.