SAP Knowledge Base Article - Public

2466149 - How to Update the Account Hierarchy using Data Workbench

Symptom

In the Data Workbench work center, you want to change the existing assignment of Account ID and Parent Account ID for the Account Hierarchy object. But in the Update view, the Account Hierarchy Object is not available for selection.

Reproducing the Issue

  1. Go to Data Workbench work center.
  2. Go to the Upsert view.
  3. Search for Account Hierarchy Object.

The Account Hierarchy object is not available. It is therefore not possible to update it.

Cause

The Import functionality allows creation and modification of Account Hierarchies.

Resolution

  1. Go to Data Workbench work center.
  2. Go to Import view.
  3. Search for Account Hierarchy Object.
  4. Mark the row of this object.
  5. Choose Download Metadata.
  6. Open the AccountHierarchy file and enter values for AccountID and ParentAccountID.
  7. Upload and Import the file.

As you can see in the Customers work center, Account Hierarchy view, the assignment has been changed accordingly.

Note: A deletion of an Account Hierarchy assignment is only possible manually.

Keywords

KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins 1802 ; SAP Cloud for Customer add-ins 1805 ; SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Hybris Cloud for Customer add-ins 1702 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1708 ; SAP Hybris Cloud for Customer add-ins 1711