SAP Knowledge Base Article - Public

2656423 - Territory Derivation Does Not Work for Territory Rules With Exclude Operator


You created an Excel spreadsheet for territory rules and uploaded it to Cloud for Customer, but the territories are not derived as defined in the rules.


SAP Hybris Cloud for Customer

Reproducing the Issue

Pre-requisite: You created an Excel spreadsheet for territory rules including exclusion conditions.

  1. Go to the Administrator work center.
  2. Go to the Sales and Campaign Settings view.
  3. Open Define Rules for Territory Realignment.
  4. Go to Upload.
  5. Select your previously created spreadsheet.
  6. Activate the rules.

Result: The territory rules do not work and territories are not derived.


You created an Excel spreadsheet with exclusion conditions as follows:

Exclude [ZABC ; ZDEF ; ZGHI ; ZJKL ; ZMNO]


In order for the 'Exclude' operator to work correctly, it needs a preceding inclusion operator.

In the Excel spreadsheet, an exclusion list has to be defined as follows:

<> A001; exclude B002; exclude C003; exclude Z004

(A, B and C stand for standard values; Z stands for custom values).

No brackets should be maintained in the spreadsheet.

Please note, that multiple exclusion parameters currently only work, when uploaded via Excel.

In the UI, the exclusion operator is currently displayed as inclusion operator.

In the coming releases, it is planned to enhance the value handling related to the 'Exclude' operator.


territory rules, rule download, rule upload, exclusion condition, rule condition, include, exlude, rule operator , KBA , LOD-CRM-TM , Territory Management , Problem


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