SAP Knowledge Base Article - Public

1603022 - Missing Value Help for Time Types in Excel Upload for Time Recordings


When you use the Excel add-in to upload times for employees, the value help for the "Time Types" column in the Excel template doesn't display any data.


SAP Business ByDesign

Reproducing the Issue

  1. Go to Time Administration work center.
  2. Select Time Recording view and Time Sheet sub view.
  3. Highlight an employee and click Action button and choose Upload Times from Microsoft Excel option.
  4. In the Excel, highlight a cell of Time Types column and select look up value. The list is empty.


The value help for the time type is both time and country-specific.


You should set the country first (e.g., DE for Germany) in the header of Excel. Once the country is set, the value help should provide appropriate time types for the specified country.


Value Help, Excel, Time, Time Type, Time Administration , KBA , SRD-HR-TLM , Time and Labour Management , How To


SAP Business ByDesign all versions