How To Fix MO412 - LIKE with ESCAPE in pooled table

MO412 - Overview

• Message type: E = Error

• Message class: MO - Modeling and Prototyping

• Message number: 412

• Message text: LIKE with ESCAPE in pooled table

What causes this issue?

An Open SQL statement that contains a WHERE clause is to be executed.
It contains a LIKE condition with the addition ESCAPE. The addition
ESCAPE must not be used for pool tables.
The WHERE clause contains an IN-itab condition (SELECT options) that
includes LIKE conditions (CP or NP).
If the search string for this type of LIKE condition contains one of
the characters '%' or '_', an escape character is added by the runtime
environment. This causes the current runtime error with pool tables.
This error was caught.

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

System Response

Processing had to be terminated.

How to fix this error?

Do not use in your selection any combination of '*+' and '_%'.

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 MO412 - LIKE with ESCAPE in pooled table ?

  The SAP error message MO412 typically occurs when there is an issue with the use of the LIKE operator in a query involving a pooled table, particularly when using the ESCAPE clause. This error can arise in various scenarios, such as when you are trying to filter records based on a pattern match but the syntax or the context is not correctly set up.
  Cause of the Error
  
  
  Pooled Tables: Pooled tables in SAP are special types of database tables that are stored in a single table in the database. They are used to optimize storage and performance. However, they have certain limitations, especially when it comes to complex SQL operations.
  
  
  LIKE Operator: The LIKE operator is used for pattern matching in SQL. When using it with pooled tables, there may be restrictions on how it can be applied, especially with the ESCAPE clause.
  
  
  Incorrect Syntax: The error can also occur due to incorrect