How To Fix SDDL_PARSER_MSG035 - The column & requires a numeric comparison value

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 035

• Message text: The column & requires a numeric comparison value

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 SDDL_PARSER_MSG035 - The column & requires a numeric comparison value ?

  The SAP error message SDDL_PARSER_MSG035 indicates that there is an issue with a comparison operation in a query or a condition where a numeric value is expected, but the provided value is not numeric. This error typically arises in the context of SAP's Security Data Definition Language (SDDL) or when working with authorization objects and conditions.
  Cause:
  The error occurs when:
  
  A column that is expected to hold numeric data is being compared to a non-numeric value (e.g., a string or a character).
  The syntax of the query or condition is incorrect, leading to a mismatch in data types.
  There may be a configuration issue where the expected data type for a column is not aligned with the actual data type being used in the comparison.
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Check the Query/Condition:
  
  Review the query or condition that is causing the error. Ensure that all comparisons involving numeric columns are using numeric values.
  For example, if you have a condition like column_name = 'some_string', change it to use a numeric value, such as column_name = 123.
  
  
  
  Data Type Verification:
  
  Verify the data types of the columns involved in the comparison. Ensure that the column you are comparing is indeed defined as a numeric type in the database schema.
  If you are using a variable or parameter in the comparison, ensure that it is being passed as a numeric type.
  
  
  
  Debugging:
  
  If you are unsure where the error is occurring, consider enabling debugging or logging to capture the exact query or condition that is being executed when the error occurs.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources related to SDDL and the specific context in which you are working. This can provide insights into the expected formats and types.
  
  
  
  Testing:
  
  After making changes, test the query or condition again to ensure that the error is resolved.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional context.
  SAP Community: Engage with the SAP Community forums to see if others have encountered similar issues and what solutions they found effective.
  Authorization Objects: If this error is related to authorization checks, ensure that the authorization objects are correctly defined and that the values being compared are appropriate for the context.
  
  By following these steps, you should be able to identify and resolve the issue causing the SDDL_PARSER_MSG035 error in your SAP environment.