Symptom
You are exporting the Activity Report from the Self-Service time sheet to Excel. However even when exporting only the visible columns, the exported file contains other columns that were hidden.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Home work center.
- Enter the Self Services Overview view.
- Click on Edit Time Sheet.
- Click on the button View Activity Report.
- Click on the avatar icon on the top right of the screen.
- Click on Start Personalization Mode.
- On the right panel, select the Time Confirmations table to edit it.
- Uncheck one or more columns from the list. This will make the columns to be hidden from the table.
- On the right panel, click on the Save button.
- Click on the avatar icon on the top right of the screen.
- Click on Stop Personalization Mode.
- On the Activity Report screen, click on Export.
- Click on To Microsoft Excel.
- On the Export Column dropdown list, select Visible.
- Click on Download.
- After the download is completed, open the created Excel file.
Here you can see that the file includes all UI elements, not only the ones which are visible in the UI.
Cause
Due to technical limitation, the standard activity report Excel export includes all columns of the template and cannot be limited to visible elements only.
Resolution
The system works as expected.
Keywords
ESS, TimeSheet, Time Entry , KBA , SRD-HR-TLM , Time and Labour Management , How To
Product
SAP Business ByDesign all versions