SAP export to Excel any report with print to file

Quick links

SAP export to excel any report with print to file

It is possible to export basically any SAP list to Excel, the process being actually to print it to a file, allowing to choose several solutions, unconverted printing, MS Excel spreadsheet export, rich text format for display in notepad, HTML format for web browser display, and copy in the clipboard to copy manually.

Starting with a table from any report that has been executed in SAP, the first step is to select to data that is necessary to export – or take all of it – and select the standard print option.

SAP export to Excel any report with print to file : SAP process execution report to print
SAP process execution report to print

Now, what is important to be able to export this data, even if there is no standard option to export, is to select the correct printer, also called the output device.

SAP export to Excel any report with print to file : Print parameters
Print parameters

Spool print or directly to printer

Here, it is necessary to use the given form to be able to find a printer that will actually not print anything, as we want to use a ghost printer, simply to have the file available in the spool list.

SAP export to Excel any report with print to file : Restrict value range for printer selection in SAP
Restrict value range for printer selection in SAP

For example, without putting any search string, the whole printer list might be displayed, it is necessary to find a fake printer that will actually not perform any single physical operation, but simply store the file until we are done with it.

SAP export to Excel any report with print to file : Output device print parameters printer list
Output device print parameters printer list

In our example, the mock printer is the printer with four X, which is a test printer, not connected to any physical printer, but simply used to manage printing pools.

SAP export to Excel any report with print to file : Test printer found
Test printer found

Now that the printer has been selected, start the printing, and a message should confirm the success of the operation.

SAP export to Excel any report with print to file : Information message about printing, formatting set to something
Information message about printing, formatting set to something

Back in the SAP main screen, most likely the SAP Easy Access, go to the menu System > Own spool requests, where we will be able to retrieve our printer file.

SAP export to Excel any report with print to file : SAP Easy access own spool requests menu
SAP Easy access own spool requests menu

And here it is! This entry actually is the report printing we have triggered before. That report could not be exporter in any way, but here it is in a printer ready file.

Output controller list of spool requests tcode SP01.

SAP export to Excel any report with print to file : Output controller list of spool requests screen
Output controller list of spool requests screen

How to print spool request in SAP

It is now time to select the spool to print, or export to MSExcel, which in our case is only a single choice.

SAP export to Excel any report with print to file : Selection of the spool entry to export to Excel
Selection of the spool entry to export to Excel

That spool request can be graphically displayed, which is the first step to exporting it to the required file, by clicking on the appropriate icon on the top right.

SAP export to Excel any report with print to file : Save list in file icon
Save list in file icon

A pop-up will ask in which type of file the spool output should be saved, which can be by default unconverted, a spreadsheet, rich text format, HTML format, or copy the whole content to the clipboard.

SAP export to Excel any report with print to file : Save list in file export format selection
Save list in file export format selection

After having selected the format, another pop-up will ask for the file destination, which must of course be accessible in write mode by the SAP client, for example it could be the Documents folder.

SAP export to Excel any report with print to file : Graphical display of spool request export directory
Graphical display of spool request export directory

And that's it, a short confirmation message at the bottom of the SAP window should show that the operation has been successful.

An eventual message might say that displaying so many pages might cause a memory overflow, but for most standard files it should be fine, the message can simply be dismissed.

SAP export to Excel any report with print to file : Graphical display of spool request
Graphical display of spool request

How to export data from SAP to excel

The file can now be opened in Excel or another spreadsheet display program, and should show the table that was available in SAP.

SAP export to Excel any report with print to file : SAP export to excel
SAP export to excel

After the file has been exported, do not forget to go back to spool management transaction SP01, as it is important to clean the spool list to avoid server memory shortage.

SAP export to Excel any report with print to file : Output controller list of spool requests SP01
Output controller list of spool requests SP01

Select the spool that has been printed and isn't necessary any more, and select the deletion icon, a pop-up will ask for confirmation before deleting the spool.

SAP export to Excel any report with print to file : Delete spool request confirmation pop-up
Delete spool request confirmation pop-up

The spool request list should now be clean, and the file already exported on the computer.

SAP export to Excel any report with print to file : Clean list of own spool requests
Clean list of own spool requests

Problem description

How to export data from SAP to Excel, how to print spool request in SAP, how to print invoice in SAP, how to print PO in SAP, how to print in SAP, how to save spool file in SAP

How to create a material in SAP S/4HANA – SAP MM in SAP S/4HANA

Similar articles

Comments (0)

Leave a comment