Displaying Data with Excel Inplace

Your data is sent to Excel and displayed instead of the ALV list. The toolbar of the list remains in unchanged form; you can also continue to use the functions provided in the Excel view.

Prerequisites

To display the Excel Inplace view, Microsoft Excel must be installed on your computer.

Process

To display the data in Excel, choose (Excel Inplace).

In the Fullscreen View, choose Views Microsoft Excel .

Result

The data is displayed copied to Microsoft Excel. The information and settings from the list view are also copied over, and displayed on the Format sheet.

Column headers are copied,
Column sequence and column width are copied,
Key columns are shown in turquoise.
Totals and subtotals from the grid view are copied over and displayed in the same way. (See display of Totals and
Subtotals).

The following sheets are provider in addition to the displayed Format sheet:

Header (only relevant for full-screen mode): On this sheet, additional header information is displayed above the list data.
Pivot: This sheet provides the pivot table for the list data.
Sub1-Sub10: On these sheets, only the subtotals for the corresponding subtotal level are displayed.
RawData: The list data is displayed without any additional information, such as lead columns, header information, totals, or subtotals.
RawHeader (only relevant for full-screen mode): Only the header information is displayed.

These sheets are based on the Excel view templates delivered by SAP. The template for the Excel sheets are labelled as such. You can also define your own or cross-customer templates as required, into which you can add a company logo to the sheets, for example. See Managing Templates.

Caution Caution

Do not change the data in the executed sheets. If you want to edit the data, create your own worksheet by choosing Insert Table . Any changes that you make to the data are not copied to another view if you switch view.

End of the caution.

The functions provided in the ALV list toolbar are also available in Excel. Any changes that you make using the ALV list toolbar are applied to the new view when you switch view.

Displaying and Deleting Totals
Calculating and Deleting Subtotals
Exporting Data
Selecting Layouts
Changing Layout

Note

The settings that you make on the Display tab page are not displayed in Excel; however, they are copied over when you switch to the ALV list.

End of the note.

Note

In the Excel view, you cannot define filters and sorting options using the toolbar of the ALV list. You can use the filter and sorting options from Excel. These changes are not copied over when you switch the view.

End of the note.
Saving Layouts
Managing Layouts
Displaying Graphics for Lists

Returning to the Grid View

Grid View:
To return to the grid view, choose (-> Grid).
Fullscreen View:
In a list in Fullscreen View, select Views SAP List Viewer .