SAP Knowledge Base Article - Public

2586888 - Not Possible to Limit the Excel Export of Activity Report to Visible Columns

Symptom

In the Home Work Center, Self Services Overview you select Edit Time Sheet and open the Activity Report. You remove the visibility of one or more elements via Personalization. Now you want to export your selection to Excel. But although you select the export of visible columns only, the newly created excel includes all elements, even those which are invisible in the UI.

Reproducing the Issue

  1. Go to the Home work center.
  2. Select Self Services Overview.
  3. Edit Time Sheet.
  4. View Activity Report.
  5. Start Personalization Mode.
  6. Remove the visibility for one or more UI elements and save.
  7. Stop Personalization Mode.
  8. Now the columns for the deselected elements are not visible anymore.
  9. Select Export to Microsoft Excel.
  10. Select Export Column Visible.
  11. Start the download.
  12. Open the created excel file.

Result: The file includes all UI elements, not only those which are visible in the UI.

Cause

Due to technical limitation, the excel export includes all columns of the template and cannot be limited to visible elements only.

Resolution

If you need to export visible columns only, you can design an alternative standard template and upload it into the system.

Keywords

Tätigkeitsbericht;  Spalte exportieren; alle; sichtbare; , KBA , SRD-HR-TLM , Time and Labour Management , Problem

Product

SAP Business ByDesign all versions