SAP Knowledge Base Article - Public

2495006 - Cannot Update Business Partner Relationships with Data Workbench

Symptom

You have created a custom OData Service for Business Partner Relationships which is Data Workbench-enabled however, when you try to modify relationships using Update mode, the records are not changed even when the task was Successful.

Environment

SAP Cloud for Customer 2005 and higher.

Reproducing the Issue

  1. Go to Data Workbench Workcenter.
  2. Go to Export View.
  3. Select your Custom Business Partner Relationship object.
  4. Select relevant data and click Next, then click Export Data.
  5. Modify the records in your CSV file and save.
  6. Now, in the Update View, select the object again and Upload your file.
  7. Observe that the task has status Successful, but the records were not updated.

Cause

This is the standard system behavior. Currently, it's not possible to update Business Partners Relationships using the Data Workbench tool.

Resolution

As a workaround, you can do the following:

  1. Go to Export in Data Workbench Workcenter, select the business object "BusinessPartnerRelationships", select the filter criteria "ID" (if needed) and click Next and "Export"
  2. Download the above exported file from Monitor
  3. Edit the downloaded file, Add "ToBeDeleted" as the last column to the file
  4. For the records to be deleted, set the value as "true" in "ToBeDeleted" column. Save the above changes in the file
  5. Go to Data Workbench View and click on Update view, Select the object and click on Next
  6. Upload the file from 3rd step and click on Next
  7. Click on Import
  8. After this, import a file with the new Business Partner Relationships.

See Also

2385156 - Removing Relationship Assignment from Accounts using Data Workbench

Keywords

Update, Business Partner Relationships, Data Workbench. , KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions