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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.