Start of Content Area

Procedure documentation Displaying Data with Excel Inplace  Locate the document in its SAP Library structure

Use

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.

Procedure

To display the data in Excel, choose This graphic is explained in the accompanying text  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

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.

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.

Displaying and deleting totals

Calculating and deleting subtotals

Exporting data

Selecting layouts

Changing layouts

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 Grid Control.

Note

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

Saving layouts

Managing layouts

Displaying graphics for lists

Procedure

To return to the grid view, choose This graphic is explained in the accompanying text  Grid.

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

 

End of Content Area