SAP Knowledge Base Article - Public

2595652 - How to Update Employee Data Using Data Workbench?

Symptom

How to update Employee Data using Data Workbench tool?

Resolution

You can use the ODATA-based service via the Data Workbench (DWB):

  1. Go to DataWorkbench work center
  2. Go to EXPORT view
  3. Look for "Employee" (= Service EMPLOYEE_AND_USER, EntityType "Employee")
  4. Filter for relevant Employees to be changed (e.g. via SecondLastName notEQ "")
  5. Export the data and find CSV-file for download in MONITOR tab
  6. 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)
  7. To clear "SecondLastName" just clear the content in the respective rows (= overwrite with INITIAL), SAVE your changes
  8. Back in DataWorkbench work center, chose UPDATE, again "Employee" and select the updated file with the initial SecondLastNames
  9. 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 all versions