SAP Knowledge Base Article - Public

2584176 - Error Message: “Territory ID XXXXX doesn't exist” While Updating the Sales Territory Account Using Data Workbench

Symptom

Your requirement is to add Sales Territories for existing Accounts using Data Workbench. For the object Sales Territory Account, upon uploading the file in the Update view, system throws the Processing error:

Territory ID XXXXX doesn't exist

Reproducing the Issue

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to Import tab
  4. In the search field, select the object Sales Territory Account
  5. Select Download Metadata
  6. Fill data in the fields CustomerID and TerritoryId
  7. Save the file

 

To upload the file:

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to the Update tab
  4. Select the object Sales Territory Account
  5. Select Next and Browse for the file
  6. Select Upload
  7. Choose Next
  8. Select Update
  9. In the Monitor tab, check for the respective Task ID
  10. The records in the file have the Processing Error

Resolution

This feature is not supported, there is a Workaround which allows to Import the new Sales Territory data for the Accounts.

You may follow the below steps:

  1. Export the Sales Territories using Data workbench and Download the exported file
  2. Export Sales Territory Account (just to use it as template) and Download the exported file
  3. For the file downloaded in the step-2, Delete columns HeaderObjectID and CustomerUUID
  4. For the ObjectID column, do not fill any data, leave it empty
  5. Get ObjectID for Sales Territory from Sales Territory file (which was exported file in step-1) and copy to ParentObjectID field
  6. Fill the data for CustomerID and TerritoryId
  7. Go to Update view in Data Workbench and use the above file to Upload

This successfully creates records of Sales Territory Account

Keywords

Sales Territory Account, Sales Territories , KBA , territory id doesn't exist , territory id does not exist , territory id , sales territory account , sales territories , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer add-ins 1802 ; SAP Cloud for Customer add-ins 1805 ; SAP Cloud for Customer add-ins 1808 ; SAP Hybris Cloud for Customer add-ins 1711