How To Fix /SCMTMS/FAG_MSG891 - Cannot upload Microsoft Excel file; invalid values specified in file

SAP Error Message - Details

• Message type: E = Error

• Message class: /SCMTMS/FAG_MSG -

• Message number: 891

• Message text: Cannot upload Microsoft Excel file; invalid values specified in 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 /SCMTMS/FAG_MSG891 - Cannot upload Microsoft Excel file; invalid values specified in file ?

  The SAP error message /SCMTMS/FAG_MSG891 indicates that there is an issue with uploading a Microsoft Excel file into the SAP system, specifically due to invalid values specified in the file. This error typically occurs in the context of SAP Transportation Management (TM) when trying to import data from an Excel file.
  Causes:
  
  Invalid Data Format: The data in the Excel file may not conform to the expected format. This could include incorrect data types (e.g., text in a numeric field), missing mandatory fields, or incorrect date formats.
  Incorrect Column Headers: The column headers in the Excel file may not match the expected headers in SAP. This can lead to the system being unable to map the data correctly.
  Special Characters: The presence of special characters or unsupported symbols in the data can cause the upload to fail.
  Empty Rows or Columns: The presence of empty rows or columns in the Excel file can also lead to issues during the upload process.
  Excel File Version: The version of the Excel file may not be compatible with the SAP system. For example, using a newer version of Excel that SAP does not support.
  
  Solutions:
  
  Check Data Format: Review the data in the Excel file to ensure that it matches the expected format. Make sure that numeric fields contain only numbers, dates are in the correct format, and mandatory fields are filled.
  Verify Column Headers: Ensure that the column headers in the Excel file match the expected headers in SAP. You may need to refer to the SAP documentation or the template provided for the upload.
  Remove Special Characters: Check for and remove any special characters or unsupported symbols from the data.
  Eliminate Empty Rows/Columns: Remove any empty rows or columns from the Excel file before attempting to upload it again.
  Use Compatible Excel Version: Save the Excel file in a compatible format (e.g., .xls or .xlsx) that is supported by your version of SAP.
  Use SAP Templates: If available, use the official SAP templates for data upload, as these are designed to meet the system's requirements.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes or Knowledge Base Articles that may provide additional guidance or updates related to this error.
  Transaction Codes: Familiarize yourself with the transaction codes related to data uploads in SAP TM, such as /SCMTMS/UPLOAD or others specific to your version.
  Testing: After making corrections, test the upload with a small sample of data to ensure that the issue has been resolved before attempting to upload larger datasets.
  
  If the problem persists after following these steps, it may be beneficial to consult with your SAP support team or refer to SAP community forums for further assistance.