How To Fix RSDMDM018 - Only key restrictions are being evaluated

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDMDM - RSDMDM

• Message number: 018

• Message text: Only key restrictions are being evaluated

What causes this issue?

If values without master data are displayed, only key restrictions will
be evaluated.

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 execute a selection on attributes or texts, you will need
to hide values without master data again.

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 RSDMDM018 - Only key restrictions are being evaluated ?

  The SAP error message RSDMDM018, which states "Only key restrictions are being evaluated," typically occurs in the context of SAP BW (Business Warehouse) when working with queries or data models. This message indicates that the system is only considering key fields for filtering or evaluation, and other non-key fields are not being processed in the same way.
  Cause:
  
  Key Restrictions: The error usually arises when a query or data model is set up to evaluate only key fields, which are essential for identifying records in the database. Non-key fields may not be included in the evaluation due to the way the query is structured or the settings in the InfoProvider.
  Query Design: If the query is designed to filter or restrict data based solely on key fields, any additional filters or conditions applied to non-key fields will not be considered.
  Data Model Configuration: The configuration of the InfoObject or InfoProvider may restrict the evaluation of non-key fields.
  
  Solution:
  
  Review Query Design: Check the query design in the BEx Query Designer. Ensure that the non-key fields you want to evaluate are included in the query and that they are set up correctly.
  Adjust Filters: If you are applying filters on non-key fields, make sure that these fields are part of the query and that they are not being ignored due to the key restriction settings.
  Modify InfoProvider Settings: If applicable, review the settings of the InfoProvider (e.g., InfoCube, DSO) to ensure that non-key fields are configured to be evaluated.
  Check Aggregation Levels: Ensure that the aggregation levels in the query are set correctly to include the necessary fields for evaluation.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidance on handling key restrictions in your version of SAP BW.
  
  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 other users have encountered similar issues and what solutions they have found.
  Training and Documentation: Consider reviewing training materials or documentation related to query design and InfoProvider configuration in SAP BW.
  
  By following these steps, you should be able to resolve the RSDMDM018 error and ensure that your queries evaluate both key and non-key fields as intended.