SAP Knowledge Base Article - Public

1694126 - Project Task Column Is Missing in the Exported Activity Report

Symptom

You have a requirement to view all your time recordings on the tasks of specific project. When you export those recordings into Excel, you may observe that the Project Task is missing in exported Excel.

Reproducing the Issue

  1. Go to the Home work center.
  2. Select the Self-Services Overview view.
  3. Select the Edit Time Sheet link.
  4. Select the View Activity Report button.
  5. In the popup screen, select a Project.
  6. Select the Export button and choose the To Microsoft Excel.

In the Excel, the Project Task column is missing.

Cause

The Project Task column is available in the Excel but as a hidden column so it is not shown explicitly.

Resolution

Open the exported Excel:

  1. Select both the columns (header level) six and seven using Ctrl key in the keyboard.
  2. Right click on the header level (upon selection).
  3. Select the Unhide option.

Now the Project Task column should appear.

Keywords

KBA , project task , time recordings , SRD-HR-TLM , Time and Labour Management , How To

Product

SAP Business ByDesign all versions