SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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.

Cause

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

Resolution

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.

Keywords

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

Product

SAP Business ByDesign all versions