Skip to Content
Former Member
Dec 21, 2011 at 01:56 PM

SAP’s export capability to excel


When exporting to Excel via local file -> spreadsheet with all depreciation areas selected and all columns visible, the exported data starts wrapping around to a second line making the report not really usable. We need this to change so that all columns are beside each other without wrapping, so that a complete record will fit on one row in excel.

There are two ways to export data to excel which I will list next with each of their u201Cfeaturesu201D.

Menu path system, list, save, local file, spreadsheet: (sometimes there is also an icon that will take you down this path). Output is limited to 62 columns before the data starts wrapping to a second and third row. The fields in these rows are offset from the columns above and make a spreadsheet difficult to use.

Menu path, and often an icon, export, spreadsheet, at this point many options are available as to format u2013 MHTML, XML, XXL, and a few additional variants on these. Benefits of these is that they bring all the columns on one row. The MHTML format also keeps the subtotaling and hierarchy layout. The XML format keeps the subtotaling, but not the hierarchy. The XXL is just a list and reorganizes the columns with all the data fields to the left followed by the numeric fields to the right. The problem with all of these is that they are slow to run and max out at a certain number of rows. If you exceed the row limitation the report gives an ABAP dump error.

Given that Excel 2007 and above allow for hundreds of columns and a million rows, what we are expecting from a download from SAP is all the data in the same table structure in Excel as it is in SAP u2013 basically a straight table dump from whatever report we ran, in a clean tabular format, up to Excelu2019s limitations.

Any input on this subject is greatly appreciated.