SAP Knowledge Base Article - Public

2328545 - Territory Uploaded via Excel Does Not Have the Maintained ID

Symptom

You have uploaded Territories via Excel and they don't have the ID maintained on the template.

Reproducing the Issue

  1. Go to Sales work center;
  2. Go to Territories view;
  3. Download the template;
  4. Fill in the data including ID;
  5. Upload;
  6. You can see the territories in the system, but the IDs are not the ones selected.

Cause

This is the system's expected behavior.

Resolution

The ID field in the Excel template is meant to maintain Parent Territory relationship for the territories. The IDs in the system, on the other hand, are always generated automatically and in sequence to avoid inconsistencies — this can also be observed when creating territories by other means, such as directly in the UI or through Data Workbench.

Keywords

Territory ID, Upload, Not Maintained , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Cloud for Customer add-ins all versions