SAP Knowledge Base Article - Public

2462811 - Report on latest changes only done on any given day for (Global) Job Information data - Last Transaction / Last Trans Seq

Symptom

  • Date Range reports in Advanced Reporting, will fetch all the records during the chosen period.
  • This article explains how to include only the last change (last transaction) done for the day, in the employees' records.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas: Advanced reporting

Reproducing the Issue

One or more users have multiple Job Transactions on the same day and a result, the report fetches multiple entries with the same effective start date(s):

multiTransactions.png

Resolution

The ‘Last Trans Seq’ field under Global Job Information holds the value ‘True’ for the last change done for the day and  ‘False’ for the remaining transactions.
Applying a filter for this field will meet the requirement.

REALMS_field.jpg

Keywords

REALMS, Advanced, Reporting, Canvas, Report,  Last, Transaction, Latest, Change, Date, Range, Analytics, Global, Job, Information, Last Trans Seq, Employment, , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Suite all versions