Symptom
How to update Employee Data using Data Workbench tool?
Resolution
You can use the ODATA-based service via the Data Workbench (DWB):
- Go to DataWorkbench work center
- Go to EXPORT view
- Look for "Employee" (= Service EMPLOYEE_AND_USER, EntityType "Employee")
- Filter for relevant Employees to be changed (e.g. via SecondLastName notEQ "")
- Export the data and find CSV-file for download in MONITOR tab
- Change the CSV-File for subsequent UPDATE (delete all not relevant columns except the technical ones "ObjectID", "ParentObjectID", "HeaderObjectID" and the columns that are intended for UPDATE)
- To clear "SecondLastName" just clear the content in the respective rows (= overwrite with INITIAL), SAVE your changes
- Back in DataWorkbench work center, chose UPDATE, again "Employee" and select the updated file with the initial SecondLastNames
- Check the results from that UPDATE again in MONITOR (and check for SUCCESS)
Keywords
KBA , LOD-CRM-INT-DWB , Data Workbench , How To
Product
SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions