01-11-2008 5:49 AM
Hi Exports
How to export the data in ALV as Pivot Table.
Pls help me on this.
Thanks in advance.
Regards
Rajaram
01-11-2008 5:53 AM
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
01-11-2008 5:53 AM
Hi,
On the ALV screen, just select export button and in that you will get the option to export in Pivot file.
Regards,
Pankaj
01-11-2008 6:03 AM
Hi Pankaj
In my ALV, am not getting the option Export as Pivot table. how to get it.
Regards
Rajaram
01-11-2008 6:11 AM
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
01-11-2008 6:17 AM
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.
01-11-2008 6:24 AM
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.
01-11-2008 7:47 AM
Actually am not getting such errors yar,
But am not getting the Pivot Table option.
Pls help me on this.