SAP Knowledge Base Article - Public

3016328 - Numbering sequence is not the same as the sequence in migration template

Symptom

You are working with migration objects that creates instances using internal numbering, such as Customer and Product, in migration cockpit. You found internal numbering sequence is not the same as the sequence in your uploaded migration template.

For example, the records entered in the template in the following sequence.

  • 3
  • 1
  • 2
  • 11
  • 20

After uploading the template into the staging table, the sequence is in a sorted way as below.

  • 1
  • 11
  • 2
  • 20
  • 3

Environment

  • SAP S/4HANA Cloud
  • SAP S/4HANA

Cause

The sequence will be sorted after uploading data in staging table. This is neither controlled by migration content nor migration tool. SAP tables will sort the source IDs by ascending. As staging tables are transparent SAP tables, the staging tables for data migration are sorted in the same way.

The creation of internal numbering is also influenced by the configured number range configuration and the internal number range buffers (for details see for example KBA 1817764). Dependent on the number of jobs defined for the migration object during the migration within Migration Cockpit's Job Management the jobs can run in parallel on different application servers and then different number range buffers are consumed.

Resolution

If you would like to influence the new numbering by the source records sequence in your template, you have to ensure that the sequence will not be changed after loading into staging table.

For example, the following source ID will be sorted again because the sequence in staging table will be different.

  • 2
  • 1
  • 4
  • 3

While the following source ID won't be sorted again.

  • A001-2
  • A002-1
  • A003-4
  • A004-3

Keywords

migration, sequence, internal numbering, sort, sequential, data migration, PM - General maintenance task list, number range buffer , KBA , CA-GTF-MIG , SAP S/4HANA Data Migration Cockpit Content , CA-LT-MC , S/4HANA Migration Cockpit , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions