topic Re: Data as Pivot Table in Application Development and Automation Discussions

Data as Pivot Table

Former Member — Fri, 11 Jan 2008 05:49:02 GMT

Hi Exports

How to export the data in ALV as Pivot Table.

Pls help me on this.

Thanks in advance.

Regards

Rajaram

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 05:53:05 GMT

Hi Raja Ram,

Use this funciton module and problem will be solved:

FUNCITON MODULE: XXL_FULL_API.

AND CHECK THIS REPORT AND EXECUTE THIS REPORT FOR BETTER UNDERSTANDING.

REPORT: XXLTTEST

Award points if helpful.

Kiran Kumar.G.A

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 05:53:47 GMT

Hi,

On the ALV screen, just select export button and in that you will get the option to export in Pivot file.

Regards,

Pankaj

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 06:03:34 GMT

Hi Pankaj

In my ALV, am not getting the option Export as Pivot table. how to get it.

Regards

Rajaram

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 06:11:29 GMT

Hi,

Don't go through the standard ALV tool bar.

From the top menu slect List and in that you have the option 'Export' then select 'Spreadsheet' and then you will get the option to select piviot file.

regards

Pankaj

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 06:17:22 GMT

Inwhich the available formats are

MHTML format

XML Format

Internal XML Format

Internal Table

XXL Format

yar, not pivot table, what could be the reason actually.

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 06:24:05 GMT

Hi Raja,

The following explanation helps u in understanding the process of exporting the data.

Please find the following SAP Note 700206.

Symptom

Excel export gives error "List object is too large to be exported" when a large list object is exported. This message comes only on usage of function module XXL_FULL_API for Export to Excel functionality.

Other terms

Excel Export, XXL Export, i_oi_spreadsheet, Size Limit,

Reason and Prerequisites

Older technology used and old MS Office release has limitaion of exporting only 16384 lines of data. This change is valid only for the SAP R3 release higher than 4.6C and MS Office release higher than Office 97.

On The pop-up dialog "Export list object to XXL" with three options

"Excel SAP macros", "Table" and "Pivot table", this change is valid only

for "Table" and "Pivot table" option and not for "Excel SAP macros".

Choice of "Excel SAP macros" option is not linked with this change for any R3 relaese.

This correction is done in function module XXL_FULL_API and is only valid when XXL_FULL_API is called for Exporting the list to Excel.

Solution

Increased the Max Size Limit to 65536 rows and 256 columns. For Table and Pivot Table option of Excel Export. This change is available for office integration technology only and no adaption is possible to old SAP

Macros. Import the relevant ABAP patch.

NOTE: If you Export a Large list object there could be a performance problem and the same will be dirctly proportional to the amount of DATA (size of list object) Exported. The Maximum limits with XXL Export: Number of Rows - 65536. Number of Columns - 256. Size of individual cell - 255 Characters.

Reward if helpful.

Thankyou,

Regards.

Re: Data as Pivot Table

Former Member — Fri, 11 Jan 2008 07:47:02 GMT

Actually am not getting such errors yar,

But am not getting the Pivot Table option.

Pls help me on this.