2939521 - Migrating Material BOM "An exception with the type CX_SY_CONVERSION_OVERFLOW was raised"

 Migrating Material BOM the following message is shown:

An exception with the type CX_SY_CONVERSION_OVERFLOW was raised, but was not handled locally or declared in a RAISING clause.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP S/4HANA Cloud Public Edition
  • "Migrate Your Data – Migration Cockpit" app
  • Migrate Data Using Staging Tables
• SAP S/4HANA
  • Transaction "LTMC"
    • Transferring Data Using Files
    • Transferring Data Using Staging Tables
  • "Migrate Your Data – Migration Cockpit" app
    • Migrate Data Using Staging Tables

Decimal notation of the value for those fields like “component quantity” and “Component Scrap in Percent” in the migration template is not the same of definition in the user setting of the customer.

When filling the fields that are in date format or numbers with decimals, make sure that your user settings are the same to the format used in the template.

Accordingly with the following information from Material BOM documentation.

Quantity Fields on Header and Item Level

If your quantity contains decimals, do not copy and paste values from another Excel file into these fields, because Excel will corrupt the data type of these fields. This in turn would cause the wrong numbers to be migrated to the system. Even the Copy value only functionality in Excel will corrupt the data type.

There are three possible options to fill the quantity fields:

1. Enter the data manually into the downloaded migration template.

2. Enter the values into a text file (for example, use the Notepad app). Copy the values from there, and use Paste special to paste the values into the column of the migration template as Text or Unicode Text.

3. Format all cells in the source Excel file as Text and use Copy values only to copy the values into the migration template.

Before uploading the XML file to the Migration Cockpit, check that the data type of these fields was not changed from String to Number.

How to check your user settings:

Go to Maintain Business User app and check Regional settings format.

Fill the template accordingly with the definition in the user settings.

https://help.sap.com/viewer/cc9ecc5f5f6b400a98d10e930324f7ad/latest/en-US/3cea17fe7e954cb1aa5ae9e85740b1b4.html

2470789-SAP S/4HANA Migration Cockpit (Cloud) - Sample data migration templates

2692715 - Migration Cockpit: How to correctly fill data into XML template

CX_SY_CONVERSION_OVERFLOW, RAISING, An exception, BOM, Bill of Material , KBA , CA-GTF-MIG , SAP S/4HANA Data Migration Cockpit Content , Problem