SAP Knowledge Base Article - Public

3416385 - How To Mass Delete Using Data Workbench

Symptom

There is a business scenario to mass delete data using Data Workbench.

Environment

SAP Cloud for Customer

Resolution

  1. Go to Data Workbench.
  2. Access the Export view.
  3. Select the object for which you wish to delete records.
  4. Filter for the desire records and export them.
  5. Download the CSV file from the Monitor.
  6. Edit the CSV and add a column with header "ToBeDeleted" at the end.
  7. For all records that should be deleted, add value "TRUE" in this column.
  8. Save the file and re-upload it to the system using the Update option in the Import view.
  9. Ensure when saving the file you save it as format CSV UTF-8 (Comma delimited) (*.csv)

See Also

3308389 - Mass Deletion of KUT fields

Keywords

Mass Delete, Data Workbench, DWB, Delete, ToBeDeleted , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer core applications all versions