SAP Knowledge Base Article - Public

2653383 - Activity Report is not Sorted Correctly After Export Excel


In the Export of the Activity Reprot, you notice that some columns ( Example: `Date`) is not beeing sorted as it is in Activity Report View in the Home Work Center.


SAP Business By Design

Reproducing the Issue

1.WoC: Home View: Self-Services.
2. Sub View: Self-Services Overview.
3. Click on link ‘Edit Time Sheet’.
4.View Activity Report.
5. Select the Project.
6. Click Go.
7. Click Export: ‘To Microsoft Excel’.
8. The Column ‘Date’ of the Excel Report is not sorted by correct date order.


Sort sequence applied in the UI is not considered in the exported spreadsheet. In excel export, data appears in the Excel in the same order in which the data is returned from the Backend.


This is an Expected system behaviour.


Activity Report, Excel Report, Project, Sorting, Sequence, Reihenfolge, Excel Bericht, Tätigkeitsmeldung , KBA , PT-EV-FO , Time Statement Form , Problem


SAP Business ByDesign all versions