Hi, when working with SAP and especially when processing material valuations using transactions MRN2 (individual valuation by material) and MRN9 (total valuation by valuation area), there can indeed be challenges if you want to export the results cleanly for further analysis. Unfortunately, there are no specific standard spreadsheets or Fiori apps that directly list and provide the results of these valuations in a more user-friendly format such as ALV. SAP's standard functionality often offers limited export options, which can lead to the problems you mentioned, especially with large amounts of data. One possible solution could be to customize or develop a custom report. Here, you or your SAP development team could program an ABAP report that pulls the data directly from the relevant tables (such as MBEW for material valuation data) and displays it using ALV (ABAP List Viewer). ALV reports offer great flexibility in presentation and export functions, including export to Excel. Another approach could be to use SAP Query or a Report Painter report if you do not want to implement a directly programmatic solution. These tools also allow you to extract specific data from SAP and present it in a more friendly format. In addition, the following tips could help: 1. Better preparation of the spool for Excel: - Try using a text editor to manually clean the data before transferring it to Excel to remove the recurring headers - Use tools such as Excel itself to edit and filter data after import 2. Use of SAP Fiori Apps: - Although no specific Fiori App exists for your concern, a generic Fiori App for data export could be helpful if your SAP version and license supports it. 3. Automation of export: - Automation scripts or software that facilitate the handling of large amounts of data can also be an option to generate regular reports. If you have internal ABAP development capabilities, I would recommend going this route to create a solution exactly according to your needs. Alternatively, SAP consulting can also help you implement an optimal solution.
Need more help from our chatbot? Click here and visit our AI SAP Helper on the SAP learning platform et.training.1
1. log in with your Espresso Tutorials account. Digital subscription or trial access required.
