3779773 - Data Source Employee Times (HCMTLMU01) Shows Expired/Former Cost Center Manager

In reports based on data source HCMTLMU01, the field "Cost Center Manager" displays former cost center managers who are no longer managers of the cost center, although the Key Date is set.

SAP Business ByDesign

1. Go to Business Analytics Work center
2. Open Design Reports view
3. Open a report that is based on data source Employee Times (HCMTLMU01) and that includes the field "Cost Center Manager"
4. Maintain selection in a way to show employee times assigned to a cost center where the cost center manager was changed in the past.
5. Run the report
6. Add the following row fields to the view:
   
   • Cost Center Manager
   • Cost Center Manager - Valid To
7. Observe that "Cost Center Manager - Valid To" contains past dates and Former managers are displayed in the column "Cost Center Manager"
8. Changing the Key Date doesn't solve the issue

In data source HCMTLMU01, the "Cost Center Manager" field does not consider the current date or Key Date selected because it doesn't retrieve the data from the cost center master data.

To show current cost center managers:

1. Go to Business Analytics Work center
2. Open Design Reports view
3. Open the report
4. In addition to the desired fields, use the "Manager" field under the "Cost Center" characteristic instead of the top-level "Cost Center Manager" to display the current cost center manager.

If keeping the field "Cost Center Manager" is preferred:

1. Ensure the report enables filtering for fields "Cost Center Manager - Valid To" and "Cost Center Manager - Valid From" with relative values (variables).
2. Apply the below filters and check whether employee times get filtered out incorrectly (employee times that should be shown on the report might disappear after applying these filters):
   • Cost Center Manager - Valid From:
     • Date That Is Less Than or Equal to Today
   • Cost Center Manager - Valid To:
     • Current day and all days in the future

If there is a need for attributes of the current manager like the e-mail address, create a joined data source instead:
    • Join type: Left Outer Join
    • Data sources to join: 
        ○ Employee Times (HCMTLMU01)
        ○ Cost Center Master Data (/MOM/COSTCTR)
    • Join Condition: 
        ○ Left Data Source: Employee Times
        ○ Left Field Name: Cost Center
        ○ Right Data Source: Cost Center Master Data
        ○ Right Field Name: Cost Center
    • Time data will be queried from data source Employee Times
    • The current cost center manager and subsequent attributes like country or e-mail will be queried from data source Cost Center Master Data (/MOM/COSTCTR)
The following or similar user-related and employee-related fields can be added to the report under the "Manager" field of Cost Center Master Data data source:
    • User Valid From
    • User Valid To
    • User Locked
    • Business Partner ID
    • User ID
    • Created On
    • Created By
    • Changed On
    • Last Changed By
    • Middle Name
    • Second Last Name
    • Academic Title
    • First Name
    • Last Name
    • Fax
    • Phone
    • Postal Code
    • City
    • Technical User ID
    • State
    • Country/Region
    • House Number
    • Street
    • E-Mail
    • Alternative Employee ID
    • Mobile Phone

HCMTLMU01, cost center manager, expired validity, valid from, valid to, current manager, cost center attribute , KBA , SRD-HR-ANA , Analytics Content , Problem