How To Fix RSMDS020 - Pattern '&1' is not permitted in the selection condition

SAP Error Message - Details

• Message type: E = Error

• Message class: RSMDS -

• Message number: 020

• Message text: Pattern '&1' is not permitted in the selection condition

What causes this issue?

A selection condition from which a set object is to be generated
contains pattern '&v1&'. This is not permitted when generating a set
object.
Only patterns that have a '&V2&' at the end of the character string as
the only wildcard character are permitted. Character '&v3&' is not
generally permitted as a wildcard.

System Response

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

How to fix this error?

If you want to use the characters '&v2&' and '&v3&', not as wildcard
characters but as normal characters, you have to mask them with the
escape character '&v4&'.
If you have used the pattern in an inclusive selection row, you should
replace the first wildcard character in the pattern with the character '
&v2&' and delete all following characters.
If you have used the pattern in an exclusive selection row, you should
completely delete this row.
In both cases, this enhances the whole selection condition.

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 RSMDS020 - Pattern '&1' is not permitted in the selection condition ?

  The SAP error message RSMDS020 indicates that there is an issue with the selection condition in a DataSource or InfoPackage, specifically that the pattern specified (represented by &1) is not permitted. This error typically arises when the selection criteria defined for data extraction do not conform to the expected format or rules.
  Cause:
  
  Invalid Pattern: The pattern specified in the selection condition may contain invalid characters or formats that are not recognized by SAP.
  Incorrect Field Type: The field being used in the selection condition may not support the type of pattern or operation being applied.
  DataSource Configuration: The DataSource may not be configured correctly to handle the specified selection criteria.
  Missing Authorization: Sometimes, the user may not have the necessary authorizations to access certain data or fields, leading to this error.
  
  Solution:
  
  Check the Pattern: Review the selection condition and ensure that the pattern is valid. Remove any invalid characters or adjust the format to match the expected input.
  Field Compatibility: Verify that the field you are using in the selection condition is compatible with the type of operation you are trying to perform. For example, if you are using a numeric field, ensure that you are not trying to apply a string pattern.
  Review DataSource Settings: Check the configuration of the DataSource or InfoPackage to ensure that it is set up correctly to handle the selection conditions you are applying.
  Authorization Check: Ensure that the user executing the operation has the necessary authorizations to access the data and fields involved in the selection condition.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on valid patterns and selection conditions for the DataSource you are working with.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Transaction Codes: Use transaction codes like RSA1 (Data Warehousing Workbench) or RSO2 (Maintain DataSource) to review and modify DataSource settings.
  Debugging: If the issue persists, consider debugging the process to identify the exact point of failure and gather more context about the error.
  
  By following these steps, you should be able to resolve the RSMDS020 error and successfully execute your data extraction process.