We have couple of custom MDF's in Employee central, which is replicated frequently based on the last changes, using Boomi to SAP.
Scenario:- User enters data into the custom MDF, which is replicated successfully into SAP. Now user makes changes to the data and then saves. The job in Boomi picks those changes as well and replicates it to SAP. User now goes back and deletes the record which was created earlier.
Issue is will the query read the deleted record and if yes how do we identify that the record is deleted or modified. There will be disconnect in records between EC & SAP if the data is deleted in employee central and not deleted in SAP.
Many thanks in advance.