How To Fix DMC_GENERAL454 - A value for the logical operator 'LIKE' must contain a wild card '%'

DMC_GENERAL454 - Overview

• Message type: E = Error

• Message class: DMC_GENERAL - MWB: General Messages

• Message number: 454

• Message text: A value for the logical operator 'LIKE' must contain a wild card '%'

What causes this issue?

It is possible to specify a selection condition using a wildcard
character, for example if the field NAME should contain a value starting
with ?AA?, you can specify a condition such as <ZK>NAME LIKE ?AA%?</>
When you use the logical operator ?LIKE?, the value after the ?LIKE?
operator must contain the wild card character ?%?.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DMC_GENERAL454 - A value for the logical operator 'LIKE' must contain a wild card '%' ?

  The SAP error message DMC_GENERAL454 indicates that there is an issue with a query or filter condition that uses the logical operator LIKE. Specifically, the error states that a value for the LIKE operator must include a wildcard character %. This is a common requirement in SQL-like queries where the LIKE operator is used to perform pattern matching.
  
  Cause:
  The error occurs when you attempt to use the LIKE operator in a query without including the necessary wildcard character %. The LIKE operator is used to search for a specified pattern in a column, and the % wildcard represents zero or more characters. For example:
  
  LIKE 'ABC%' would match any string that starts with "ABC".
  LIKE '%XYZ' would match any string that ends with "XYZ".
  LIKE '%ABC%' would match any string that contains "ABC".
  
  If you use LIKE without %, such as LIKE 'ABC', it will not be treated as a pattern match, leading to the