Using Compleo Suiteġ.) First, send an output request to a device that is being monitored by Compleo Supervisor (this example uses a list of sales orders):Ģ.) Ensure your Compleo Supervisor scenario is configured correctly (you can skip this step if you’ve already set it up.) If you really want to get into some more nuanced options for converting SAP-Excel, check out this SAP blog post. Without Compleo Suiteġ.) Right click the list you’re working with and select “Local File”:ģ.) Paste the contents of your clipboard into an Excel spreadsheet, either by using CTRL + V or right-clicking and selecting “paste”: Let’s take a look at two main ways you can transform SAP data. With Compleo Suite, you can automatically convert an SAP spool file into a formatted Excel file. This is where SAP-certified third party applications such as Compleo Suite can come in handy. This is much easier than manual entry, but formatting this data to your specifications can be a timely endeavor. Once you start working with the data and creating more complex spreadsheets, you’ll find yourself needing a faster, more robust solution.Īlternately, your SAP ERP system contains several inherent functions that allow users to export SAP data into an Excel-friendly format. This, however, takes a lot of time and effort. One clear-cut method is to copy each individual record from SAP, one-by-one, and enter that data into an Excel spreadsheet.

The only trick is to figure out which approach works best for your organization. So you have SAP data that you need to place into an Excel spreadsheet? Luckily for you, there are several options available to choose from. Select a different file format to export.Documents Made Simple: How to Convert SAP Data to Excel Files by Andy Hughes, U.S. So now, you can right-click on any value in the list and select ‘Spreadsheet…’ or click on the ‘Export’ button. This can be achieved with Settings > Switch list. You have to ensure you are in the ALV grid mode. Solution referred as in SAP Note 1678355 – Cannot export Line Items Display Reports to different spreadsheet file formats. So, once the above step(s) are done, you can try to export your spreadsheet again. Click on Remove to delete the user format setting.

Click on Edit to change user format setting or.Look for the impacted user and click on it. Select on User-Specific Settings for SAP GUI ALV. Launch report SALV_BS_ADMIN_MAINTAIN via transaction code SE38/SA38. If the flag is set, the data is always transferred in the selected format when you export an ALV grid without you being able to define a new format. By default, user will not be able to export line item display data to different spreadsheet file formats after checking the ‘Always Use Selected Format’ option.

Alv export to local file