Transfer to Excel not possible -- too much data
Message no. KH429
Dignosis
You have transferred so much data that Excel cannot display it all. You either transferred too many rows or too many columns.
Procedure
Reduce the number of rows or columns in the report. One way to do this is to deactivate certain rows or columns temporarily.
You do not have to delete the rows or columns, since the system only transfers the active ones to Excel.
You can, however, also makes changes in the form as well.
You can use 256 as a rough guideline for the number of columns and 16000 for the number of rows.
This figures only roughly describe the size, however, since administrative information is stored as well.
Note
You can refer to SAP Note 2652907 – Error message KH428 / KH429 while exporting report to excel. The solution stated as below,
Possible workarounds,
- Create a new from and report with less elements (columns and rows) or
- Reduce the elements of the original form or
- Change the selection elements (rows, columns) for drilldown display in the form definition. That will influence as the drilldown display in the classical output as the XXL output or
- Use Menu ‘Edit’ > ‘Column(s)’ > ‘On/Off’ switch off the not needed columns in classical output. After this save the report definition ‘Report’ >’Save Definition. Then export to excel.
