SAP Knowledge Base Article - Public

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


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.


This is the system's expected behavior.


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.


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


SAP Cloud for Customer add-ins all versions