SAP Knowledge Base Article - Public

2218484 - Recorded Time Not Shown In Report

Symptom

You are using a report based on data source Employee Recorded Times (technical ID: HCMTLMB07).

You may notice that for some employees the key figure Recorded Time shows incomplete or missing values.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Run a report based on data source Employee Recorded Times
  2. Display the characteristic Employee and the key figure Recorded Time
  3. Recorded times ares not visible in the data source, respectively the report.

Cause

This key figure only shows duration-based time recordings.

  1. Go to the Time Administration work center
  2. Go to the Time Recording, Time Sheet view
  3. Find an employee for whom time records are missing
  4. Press the Open Time Sheet button
  5. Go to the Review and Correct tab
  6. Select a date row with a time recording that is missing in the report
  7. Check if the field Hours is populated

If the hours column is not filled, then the key figure Recorded Time does not show any values in the report.

Resolution

Currently the report Recorded Employee Times based on the data source HCMTLMB07 shows only duration-based time recordings and doesn’t show time recordings based on Start and End time.

Make sure to maintain values in the Duration field when completing your time recording. Note that the Quantity field is filled automatically, if you enter a start and end time, but for duration-based time recording you need to fill in the duration field Hours.

Alternatively you can retrieve time recordings without the hours in your report by displaying the characteristics Start Time and End Time in the report.

Or you can create a new report based on data source: HCMTLMU01 (Employee Times).

Note:

We have explored the technical feasibility for this requirement, but changing the design would mean severe impact on the performance of the reports, hence we cannot address this requirement currently. We would explore the possibilities of this requirement in the future releases.

Additional Characteristics of this report:

  1. For Vacation time type also the key figure Recorded Time does not show any values. This means even if you fill the hours field for the time type vacation like Absent, leave, etc, the key figure Recorded Time does not show any value. This report is not designed to show the recorded hours for Vacation time type.
  2. If you have requirement to compare the status of the Time Recording between the report and the Time File of the employee then compare the 'Status' field in this report to 'Approval Status' field in the Time File. Status field is actually a consolidated status derived from Life Cycle Status and Approval Status.
  3. The report shows duration based times, even if they are canceled. To distinguish between active and canceled time recordings, you may add the Status field to the report.

Keywords

recorded employee times, HCMTLMB07, HCMTLMB07_Q0001, duration, working hours, erfasste mitarbeiterzeiten, missing times, reporting , KBA , hcmtlmb07 , recorded employee times, , missing times, reporting , hcmtlmb07_q0001 , SRD-HR-ANA , Analytics Content , How To

Product

SAP Business ByDesign all versions