How To Fix CNV_10020306 - Target cardinality N is not allowed for intervals

CNV_10020306 - Overview

• Message type: E = Error

• Message class: CNV_10020 - Message class for package 10020

• Message number: 306

• Message text: Target cardinality N is not allowed for intervals

What causes this issue?

The system found that the source determination value &V1& has target
determinaton value &V2& as well as target determination value &V3&
assigned. This corresponds to a target cardinality of N, which is not
allowed for intervals (for technical reasons).

System Response

Creation of intervals is not possible for this path.
&NOTE&
The following example shows why a target cardinality of N is not
allowed.

How can this happen?

Purchasing organizations 0001 to 0010 are assigned to plant 0001.
Purchasing organizations 0002 to 0006 are additionally assigned to plant
0002, and purchasing organizations 0007 to 0009 are additionally
assigned to plant 0003. The interval table would then look as follows:
DTVAL_S_HIGH,,DTVAL_S_LOW,,DTVAL_T
0006 ,,0002 ,,0002
0009 ,,0007 ,,0003
0010 ,,0001 ,,0001
To find the related plants for purchasing organization 0005, the program
would have to read records 1 and 3. However another relevant record
might occur at any other place in the table, which means that the table
must be processed completely every time it is accessed, and which in
turn would result in serious performance issues. If, however, there is
exactly one target determination value, only a single access is
required.

Error message extract from SAP system. Copyright SAP SE.

CNV_10020306 - Details

• The SAP error message CNV_10020306: Target cardinality N is not allowed for intervals typically occurs during data migration or conversion processes, particularly when using SAP's Data Migration tools or during the execution of a conversion program. This error indicates that there is an issue with the cardinality settings for the target data structure, specifically when dealing with intervals.
  
  Cause:
  
  Cardinality Mismatch: The error arises when the target structure is defined to accept multiple entries (cardinality N), but the source data being processed is in the form of intervals that should only allow a single entry or a specific range.
  Data Model Configuration: The data model or mapping configuration may not be set up correctly, leading to a conflict between the expected data format and the actual data being processed.
  Incorrect Mapping: The mapping of source fields to target fields may not align correctly, especially if the source data is expected to be a single