When you execute a query using queryMode=snapshot to retrieve only the current record for the given snapshot_date value, but the response returns
Complete picture of all the Employee's data as it was on the snapshot date including all changes, corrections, and deletions.
Query : where snapshot_date = to_datetime('2021-07-28T00:00:00')
<queryString>SELECT person, personal_information, employment_information, job_information FROM CompoundEmployee WHERE snapshot_date = to_datetime('YYYY-mm-DDTHH:MM:SSZ') AND person_id_external = (*)</queryString>
You receive in the response historic records for in job_information as example even if the lastmodifiedOn value for these records are before the snapshot_date = to_datetime value in your query
- Query above is using queryMode=snapshot with value snapshot_date = to_datetime('2021-07-28T00:00:00Z'), however records returned are those whose lastModifiedOn is before the snapshot_date value.
"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 HXM Suite
SAP SuccessFactors Employee Central
- Employee Central Compound Employee API
queryMode=snapshot, snapshost_date=to_datetime, effective_end_date, compoundEmployee API, effective-dated information for compoundEmployee API, effective_end_date filter , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.