EDIT HIRE RECORD BY IMPORT

[user116]

Hello experts,

please is there a way to edit new hires records by import?

[zengshaofeng · Accepted solution]

Dear Customer,

Thank you for the information in detail.

I understand you would like to edit hire record via incremental load import. But It is not possible to do that as error message "There is already a hire record for user tsmith. You cannot create another hire record if one already exists.," will pop up. I hope this explanation helps.

Best regards,

Hannah

[JaninaHornig · Accepted solution]

Hi Hannah and everyone,
It is actually possible to edit a specific record via incremental import. In your import template csv file, you need to identify the record by providing the effective start date and sequence number, as well as the userId. This will result in an update of the record with this business key instead of creating a new record.
Best, Janina

[zengshaofeng · Accepted solution]

Dear Customer, based on the advise provided by JaninaHornig, I tested in sap demo system and confirmed that it is possible to edit hire record via imcremental load import. But please make sure in imported file, seq-number is set as 1, then it is able to import. If seq-number is empty, then error will reports.

[user116 · Accepted solution]

Hello, does this means i can upload a file with the sequence number, the new hire event reason, one field updated and effective start date, and it's going to be updated, because an error message says that mandatory fields are missing