SAP Knowledge Base Article - Public

2469207 - "Date Range" ad-hoc report: "Event Date" and "Last Modified On" as Filters

Symptom

For some Date Range ad-hoc reports, all the valid dates are available to be selected as filters for the fields "Event Date" and "Last Modified On". But for other Date Range ad-hoc reports dates between a certain limit is available.

Environment

Employee Central: Reporting

Reproducing the Issue

  1. Navigate to Home -> Reports -> Reporting -> Ad hoc reports
  2. Create New Report
  3. Report Type as Singel Domain Report and Report Definition Type as Job Information (Date Range)
  4. Create
  5. Fill up / select values for tabs General Info, People, Columns, Configuration
  6. Click on Filters -> Refine Criteria
  7. Select table Job Information and field Event Date
  8. Click on By My Selection
  9. Observe that dates that fall between +1/-1 years of today's date are available
    JIDR.jpg
  10. Follow the above steps for the Report Definition Type Recurring Compensation Information (Date Range) and notice that the filters does not have any limit:
    RCIDR.jpg

Resolution

There are 3 Date Range ad hoc reports available:

  1. Job Information (Date Range)
  2. Recurring Compensation Information (Date Range)
  3. Non-Recurring Compensation (Date Range)

Job Information and Recurring Compensation Information portlets are effective dated; whereas Non-Recurring Compensation portlet is non-effective dated. The Non-Recurring Compensations have issuing dates but they don't have Start Date (Event Date) and end dates like the other two portlets. Job Information (Date Range) report is driven by Job Information. Recurring Compensation Information (Date Range) and Non-Recurring Compensation (Date Range) are driven by Compensation Information.

The two fields "Event Date' and "Last Modified On" are available in the following views (tables):

  • Job Information (Date Range) - Job Information
  • Recurring Compensation Information (Date Range) - Job Information, Compensation Information, Recurring Pay Component, Target Pay Component
  • Non-Recurring Compensation (Date Range) - Job Information, Pay Component Non Recurring, Compensation Information, Recurring Pay Component, Target Pay Component

When the report is driven by Job Information and it is effective dated, then the default date range limits (+1/-1 years from current date) for filters apply. It also applies when the report is not driven by Job Informaion and it is non-effective dated.

For example, the filter date limitation is applicable for Job Information (Date Range) - Job Information (effective dated and driven by Job Information) and Non-Recurring Compensation (Date Range) - Pay Component Non Recurring (non-effective dated and not driven by Job Information). For all other views the limitation does not apply.

 

 

Keywords

View adhoc limitation filter , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC , Employee Central , Problem

Product

SAP SuccessFactors HCM Core 1702