How To Fix MM_PUR_SES_UPL034 - Only values TRUE/FALSE/blank allowed in cell &1&2 of sheet &3

SAP Error Message - Details

• Message type: E = Error

• Message class: MM_PUR_SES_UPL - SES Upload via Excel

• Message number: 034

• Message text: Only values TRUE/FALSE/blank allowed in cell &1&2 of sheet &3

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 MM_PUR_SES_UPL034 - Only values TRUE/FALSE/blank allowed in cell &1&2 of sheet &3 ?

  The SAP error message MM_PUR_SES_UPL034 indicates that there is an issue with the values being entered in a specific cell of a spreadsheet during a data upload process. This error typically occurs when the system expects a boolean value (TRUE, FALSE, or blank) in a particular cell, but the value provided does not meet these criteria.
  Cause:
  
  
  Invalid Input: The cell in question contains a value that is not TRUE, FALSE, or blank. This could be due to:
  
  Typographical errors (e.g., "True", "False" with different casing).
  Numeric values (e.g., 1, 0).
  Other text values that do not conform to the expected input.
  
  
  
  Data Formatting Issues: The data might be formatted incorrectly in the spreadsheet, leading to the system not recognizing the input as a valid boolean value.
  
  
  Solution:
  
  
  Check the Input Values: Review the values in the specified cell (indicated by &1&2 of sheet &3 in the error message) and ensure they are either TRUE, FALSE, or left blank. Correct any invalid entries.
  
  
  Data Formatting: Ensure that the cells are formatted correctly. If you are using Excel, you can:
  
  Set the cell format to "Text" to avoid any automatic conversion.
  Manually enter TRUE or FALSE without quotes.
  
  
  
  Use Consistent Case: Ensure that the boolean values are entered in a consistent case (usually uppercase is preferred).
  
  
  Blank Values: If the cell is optional, you can leave it blank if no value is needed.
  
  
  Re-upload the Data: After making the necessary corrections, attempt to re-upload the spreadsheet to SAP.
  
  
  Related Information:
  
  SAP Documentation: Refer to the SAP Help Portal or specific documentation related to the module you are working with for more details on data upload requirements.
  Data Upload Tools: If you are using tools like LSMW (Legacy System Migration Workbench) or BAPIs for data uploads, ensure that you are following the correct data structure and formats as specified in the documentation.
  Testing: Before performing a large upload, consider testing with a small dataset to ensure that the format and values are accepted by the system.
  
  By following these steps, you should be able to resolve the MM_PUR_SES_UPL034 error and successfully upload your data into SAP.