Show TOC

Process documentationDisplaying Data with Excel Inplace Locate this document in the navigation structure

 

By default, the data is displayed in the ALV Grid Control view. Alternatively, you can switch to the Excel view. Your data is sent to Excel and displayed instead of the grid. The toolbar of the ALV Grid Control remains in unchanged form; you can also continue to use the functions provided in the Excel view.

Prerequisites

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

Process

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

In full-screen mode, choose   Views   Microsoft Excel  .

Result

Your data is sent to Excel, where it is displayed instead of the grid. The information and settings from the grid view are copied over, and displayed on the Format sheet. When this is done:

  • The column headers are copied over.

  • The column sequence and the column width are copied over.

  • The lead columns are displayed 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. 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 Grid Control toolbar are also available in Excel. Any changes that you make using the ALV Grid Control toolbar are applied to the new view when you switch view.

Returning to the Grid View

To return to the grid view, choose Grid (Grid).

In full-screen mode, choose   Views   SAP List Viewer  .