Displaying the Excel Table 

Use

The wage type reporter uses Microsoft Excel to display the list in a table format.

Activities

When you use Microsoft Excel to display the form, SAP recommends that you use an Excel template and use the following procedure:

  1. Start the wage type reporter with the required data, however, do not specify an Excel template.

    2. The system creates a temporary table.

  2. Enter suitable column headers in the table. Insert the headers as the first line.
  3. Select all columns in the area containing the data.
  4. Choose the Pivot Table Report and create the required report.
  5. Insert this report in a new Excel sheet.

    6. The Pivot Table is displayed.

  6. To save the Pivot Table as a template, select all data in the temporary table. Do not select the column headers.
  7. Delete the selected data and place the cursor in the first column and second line.
  8. Save the template in the file format .XLT.

The template can be re-used for other Excel tables ; however, the objects selected must be the same as the objects selected when the template was created.

  1. In the Excel model template field, enter the path for the template.
  2. Start the wage type reporter.

    3. The new temporary table is displayed.

  3. Choose the sheet with the Pivot Table, and update the table.