Using the Pivot Interface

Use

You define it with reference to the interface i_oi_pivot.

The pivot interface allows you to insert the contents of an internal table directly into a pivot table in a spreadsheet program. It also contains methods that allow you to change the formatting of the pivot table from within your SAP application.

For information about the currently supported Office products please refere to .

Prerequisites

Before you can use the pivot interface, you must create a central document management instance. To find out whether the document type of the instance supports the pivot interface, use the method has_pivot_interface.

Microsoft Excel must be installed on the front end (see also 722513 ).

Process

1. In the data declaration part of your program, declare a data object with reference to the interface i_oi_pivot:

   DATA pivot TYPE REF TO i_oi_pivot.

2. Use method get_pivot_interface on the document management instance to create the instance for the pivot interface.

3. Use the instance from step 2 to work with the pivot table: