How To Fix FDT_CP_MSG005 - Property '&1' supports filter options 'EQ' and 'CP' only

SAP Error Message - Details

• Message type: E = Error

• Message class: FDT_CP_MSG -

• Message number: 005

• Message text: Property '&1' supports filter options 'EQ' and 'CP' only

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 FDT_CP_MSG005 - Property '&1' supports filter options 'EQ' and 'CP' only ?

  The SAP error message FDT_CP_MSG005 indicates that a property in your data model or filter configuration is being used with filter options that are not supported. Specifically, the message states that the property supports only the filter options 'EQ' (equals) and 'CP' (contains pattern).
  Cause:
  This error typically occurs when:
  
  You are trying to apply a filter on a property that does not support the filter operation you are using. For example, if you are using a filter operation like 'NE' (not equal) or 'GT' (greater than) on a property that only supports 'EQ' and 'CP'.
  The property type may not be compatible with the filter operation you are trying to use. For instance, if the property is a string type, it may not support numerical comparisons.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  Check the Property Type: Verify the type of the property you are trying to filter. Ensure that you are using the correct filter options that are supported for that property type.
  Modify the Filter Condition: Change the filter condition to use only the supported options:
  
  Use 'EQ' for equality checks.
  Use 'CP' for pattern matching (e.g., using wildcards).
  
  
  Review Documentation: Consult the SAP documentation or the data model definition to understand the supported filter options for the specific property you are working with.
  Test the Changes: After making the necessary adjustments, test the filter again to ensure that the error is resolved.
  
  Related Information:
  
  SAP Fiori Elements: If you are working with SAP Fiori applications, this error may arise in the context of OData services and their metadata definitions.
  OData Services: Understanding how OData services handle filtering can provide insights into why certain operations are not supported.
  SAP Community: You can search for similar issues in the SAP Community forums, where other users may have encountered and resolved the same error.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.