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, and click on Start Personalization Mode.
- Remove the visibility for one or more UI elements and save.
- Click on the avatar icon on the top right of the screen, and click on Stop Personalization Mode.
- Click on Export, then 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