10-08-2013 6:05 AM
Hi all,
I am facing problem while exporting ALV output in excel sheet,,,,,,i have around 300 above record but when i do export->local file->spreadsheet->.xls
then i am getting near about 100 records only.....please let me know if there is any restriction that i have to remove for the same
Regards,
Deepak kansal.
10-08-2013 6:54 AM
No, alv can export upto 65536 rows and 256 columns.
Check SAP Note 700206.:
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.
This problem can occur, if you certain fields have any special character. Check the description and other character fields for any special characters in the output table.
10-08-2013 7:07 AM
10-08-2013 7:21 AM
Hi Deepak,
Check this 1854956 - Common issue with Export to excel
As per your Case # 11. Export to Excel generate a very big file
Regard's
Smruti
10-08-2013 7:34 AM
If you do not specify either the version of SAP or the version of Excel, I am afraid I can supply only very general information.
As Susmitha suggested, look for OSS notes relative to your version. Start with Note 1517329 - ALV Spreadsheet Export: Format Overview and its attachments Overview_Export_Formats.pdf and Compatibility_Format_vs_Appl.pdf, or Note 1178857 - Additional information: Export to Excel functions.
Look also for SAP Knowledge Base Article like 1854956 - Common issue with Export to excel mentioned by Smruti.
Also insure you already executed every basic control of your ALV like the Consistency Check.
Regards,
Raymond