2751195 - Is it possible to report on "Position Creation Date" in Advanced Reporting?

• How to report on "Position Creation Date"?
• "Position Creation Date" field is not defined in the "Position" MDF Object. Is there any possible way to report on Position Creation Date in Advanced Reporting?
• "Position Start Date" field is available in "Position" table in Advanced Reporting but "Position Creation Date" is not available in "Position" table in Advanced Reporting.

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

SAP SuccessFactors HCM Suite

Currently the "Position Creation Date" is not explicitly stored somewhere and not available for Reporting purpose in Advanced Reporting.

Possible Workaround:

"Creation Date of the Position" is the effective start date of the oldest position history time slice (while the field "Created Date" in each time slice only stores the date when the respective time slice was created).

This means, the only way to provide this date in reporting is to consider all time slices and then to select the oldest effective start date.

Unfortunately we don't have optimal methods to derive this oldest effective start date; however, there is a workaround:

Go To Advanced Reporting > Employment
Take the "Global Job Information" as driving table
Join the position table twice

1st Position table join with date option = Current Date (this table is dedicated for deriving current position attributes)

2nd Position table join with date option = Show All

Create a Pivot table and take all position attributes from the 1st position object that you would like to see in the report as "Rows" in Pivot. 
Use the field "effective start date" of the 2nd position join as measure with Pivot Function = "Minimum" (this means the "effective start date" is the "Creation Date of the Position"

Limitation: You will not get vacant positions in this report but only positions with an incumbent.

ECT-85554 (Internal to SAP Only)

Position, Creation, Date, Report, Advanced Reporting, Realms, center, canvas , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem