Displaying Data in Excel Inplace View in sap

Use

By default data is displayed in the ALV Grid Control view. You can also display data in an Excel view. Your data is transferred to Excel and displayed there in an Excel sheet within the window instead of the grid. The ALV Grid Control toolbar is still visible and you can use its functions in the Excel view.

Prerequisites

To use the Excel view, Excel must be installed on your PC.

Procedure

To display the data in Excel, choose ® Excel inplace.

In full screen view, choose View ® Microsoft Excel.

Result

The data is transferred to Excel and displayed in the Excel view instead of the grid. This view includes the information and settings from the grid view and is displayed in the Format sheet. This includes the:

• Column headings
• Column sequence and column width
• Key fields displayed in turquoise
• Identical type and view of totals and subtotals as from the grid view (see display of
Totals and Subtotals)

In addition to the Format sheet, the following sheets are provided:

• Header (only in full screen mode): This sheet includes the addition of
Header Information displayed above the list data.
• Pivot: This sheet displays the pivot table of your list data.
• Sub1-Sub10: These sheets display only the subtotal of the corresponding subtotal level.
• RawData: The list data is displayed without any additional information such as key columns,
Header information, totals, or subtotals.
• RawHeader (only in full screen mode): Only the
Header information is displayed.

These sheets are based on the Excel view templates delivered from SAP. You can define your own templates or templates for all customers (such as by adding your company logo to the sheets. See Managing Templates.

Do not change the data of the displayed sheets. If you want to edit the data, create your own sheet by choosing Add ® Table. Changes you make to the data will not be applied to another view if you change the view.

The ALV Grid Control toolbar functions are also available in the Excel view. Changes you make using the toolbar will be applied to another view if you change views.

• 
  
Calculating and Deleting Totals
• 
  
Calculating and Deleting Subtotals
• 
  
Exporting Data
• 
  
Choosing Layouts
• 
  
Changing Layouts

The settings you select on the Display tab page will not be applied in Excel, but will be applied when you change to the ALV Grid Control display.

In the Excel view, you cannot sort and set filters using the ALV Grid Control toolbar. Use the Excel filter and sort functions instead. These settings will not be applied to another view.

• 
  
Saving Layouts
• 
  
Managing Layouts
• 
  
Display List Graphic

Procedure

To return to the grid view, choose ® Grid.

In full screen mode, choose View ® SAP List Viewer.