SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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.

Cause

You created an Excel spreadsheet with exclusion conditions as follows:

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

Resolution

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:

starts with A; starts with B ; starts with C ; starts with Z ; exclude A001; exclude B002; exclude C003; exclude Z004

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

The exclusion operators can be adjusted to the business needs, as long as they are preceded by the inclusion operators.

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.

Keywords

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

Product

SAP Cloud for Customer add-ins all versions