Entering content frameFunction documentationExporting to Spreadsheets Locate the document in its SAP Library structure

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:

Prerequisites

Before you can transfer data to a spreadsheet program, the relevant program must be installed on your PC.

Activities

When you transfer data to Excel, the columns may be resorted – that is, they appear sorted by Characteristics and Key Figures.

Note

Totals rows are not included when data is transferred to the XXL interface. Also, the list formatting functions of the SAP 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 row markings.

Procedure

  1. To start the spreadsheet from the list, choose This graphic is explained in the accompanying text ® Spreadsheet.

In full-screen mode, choose This graphic is explained in the accompanying text. Alternatively, choose List ® Export ® Spreadsheet.
  1. On the Export List Object to XXL screen, choose Table or Pivot table.
  1. To confirm your entries, choose This graphic is explained in the accompanying text.

Result

Your list data is exported to the spreadsheet.

Leaving content frame