Spreadsheets

Spreadsheets

Use

The spreadsheet function transfers data across the XXL interface. To use this function, you must first decide what you want to do with the data. You can:

Save the data as an SAPoffice document
Save the data as a PC file
Transfer the data to Excel
Use the Excel pivot tab

This function is available in single-level lists.

Prerequisites

Before you can transfer data to a spreadsheet program, you must install this program. If you perform a download in Excel without first installing Excel, a file is saved in the proper format, but the data is not downloaded.

Activities

When you transfer data to Excel, the columns may be resorted – that is, they appear sorted by characteristics and key figures.

Totals rows are not included when data is transferred to the XXL interface. Also, the list formatting functions of the ABAP List Viewer are not available when data is transferred to the XXL interface into Excel. For example, there are no filter functions in the Excel list, nor can you display exceptions or row markings.