How To Fix /SCWM/MIGRATION136 - Decimal notation in system does not match decimal notation in CSV file

SAP Error Message - Details

• Message type: E = Error

• Message class: /SCWM/MIGRATION -

• Message number: 136

• Message text: Decimal notation in system does not match decimal notation in CSV file

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message /SCWM/MIGRATION136 - Decimal notation in system does not match decimal notation in CSV file ?

  The SAP error message /SCWM/MIGRATION136 indicates that there is a mismatch between the decimal notation used in the SAP system and the decimal notation used in the CSV file being processed. This typically occurs during data migration or import processes where numerical values are involved.
  Cause:
  
  Decimal Notation Mismatch: The SAP system may be configured to use a specific decimal notation (e.g., period . for decimal and comma , for thousands), while the CSV file may use a different notation (e.g., comma , for decimal and period . for thousands).
  Regional Settings: The regional settings of the SAP system may differ from those used in the CSV file, leading to this discrepancy.
  File Format Issues: The CSV file may not be formatted correctly, or it may contain unexpected characters or delimiters.
  
  Solution:
  
  
  Check Decimal Notation Settings:
  
  Verify the decimal notation settings in the SAP system. You can check this in the user profile settings or system settings.
  Ensure that the decimal notation in the CSV file matches the settings in the SAP system.
  
  
  
  Modify the CSV File:
  
  Open the CSV file in a text editor or spreadsheet application (like Excel).
  Replace the decimal notation in the CSV file to match the SAP system's configuration. For example, if SAP uses a period for decimals, ensure that all decimal values in the CSV file also use a period.
  
  
  
  Use Data Transformation Tools:
  
  If you are dealing with large datasets, consider using data transformation tools or scripts to automate the conversion of decimal notations in the CSV file.
  
  
  
  Test with Sample Data:
  
  Before processing the entire CSV file, test the import with a small sample of data to ensure that the issue is resolved.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or migration guides specific to your version of SAP and the data migration process you are using for any additional configuration settings or requirements.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance on handling decimal notation issues.
  User Settings: Users can set their own decimal notation preferences in their SAP user profile, which may affect how data is interpreted during import.
  Data Migration Tools: If you are using specific SAP tools for data migration (like LSMW, SAP Data Services, etc.), consult the documentation for those tools for any specific settings related to decimal notation.
  
  By ensuring that the decimal notation in the CSV file matches that of the SAP system, you should be able to resolve the error and successfully complete the data import or migration process.