Transferring Reports to XXL (SAP Library - CA

Transferring Reports to XXL

This function lets you export the entire report in XXL format (a special format for transferring data to a spreadsheet). This means that all characteristics of the report are available in the Excel List Viewer. This function makes it possible to execute a drilldown report in the Excel List Viewer. This factor distinguishes this function from the one which you can call up with transfer page to XXL.

Note that if you wish to transfer a drilldown list, it may contain no more than 16 384 lines / 256 columns. The exact formula for the data transferred by the application is:

26 + number of data columns + 5 * ( 1 + number of characteristics) < 256

As this function transfers all columns in the report list, all columns also go into the formula (not just the columns currently displayed).

Note that for each column transferred, an additional column is transferred for the unit of measure.

Prerequisites

You can only transfer a report to XXL under the following conditions:

You are displaying a drilldown list in a report. This function is not possible for detail lists due to technical reasons.

You have set the report display to "Absolute" using the function Settings ® Percentage/absolute. Transfer to XXL is deactivated as soon as you switch the display to "Percentage".

You chose the setting 'Read all data' in the performance settings for the report. Reports, for which data is dynamically reloaded at each navigation step, cannot be transferred to XXL.

Procedure

In a dialog box, choose the characteristics you want to transfer. It is recommended that you choose the option "All characteristics". If the report list is so large that your spreadsheet program cannot process it, you should only choose some of the characteristics.

When you transfer a report to Microsoft Excel, the data you transfer can consist of up to 16,384 rows or 256 columns. The formula for calculating the amount of data transferred from the application is:

26 + number of data columns + 5 * (1 + number of characteristics) < 256

Since this function transfers all the columns of the report list, you can use all the columns in formulas, not just those on the displayed list.

Note that an additional column for the unit is transferred along with each normal column transferred.

If you have chosen a characteristic with a hierarchy display, you should note that it is not possible to display hierarchy lists in XXL in the same form as in R/3. The data is therefore transferred as if there were no hierarchical structure for this data.

If you use an operating system which does not let you operate a spreadsheet program, you can still transfer the report to XXL; however, you can only store the XXL object in SAPoffice or in a PC file.