What To Do If Query Results Exceed Excel’s Limit
First of all, SAP BW reporting (or any data warehouse reporting, for that matter) is designed to analyze highly aggregated data. So, it should be a very rare case that your query would reach Excel’s limit of 65,536 records. Query designers and end users, especially those who are new to SAP BW, must realize that the objective of BW is not for such transactional reports and need to think about creating proper restrictions and summarizations in the reports. If your primary purpose in BW is to analyze, do you really need millions of records to analyze meaningfully?
In case you really need to output such huge amount of records, there are some alternatives you may use:
- Web reporting
- Use transactions RSRT or RSCRM_REPORT to generate the query and send the output to a flat file or table,
- Using OpenHub tool, you can create an InfoSpoke and dump the results into a flat file.
