How To Fix R1758 - Maximum no. of relationships (&) in this relationship set exceeded

SAP Error Message - Details

• Message type: E = Error

• Message class: R1 - Business Partner Messages from S_BUPA_GENERAL

• Message number: 758

• Message text: Maximum no. of relationships (&) in this relationship set exceeded

What causes this issue?

The BP relationship category determined the maximum number of BP
relationships that may belong to the same BP relationship set at the
same time.
You tried to add another BP relationship to the BP relationship set. An
event within the validity period of the relationship to be created
already has more than the maximum number of relationships in one set.

System Response

Error message
You cannot create the BP relationship with this validity period.

How to fix this error?

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R1758 - Maximum no. of relationships (&) in this relationship set exceeded ?

  The SAP error message R1758, which states "Maximum no. of relationships (&) in this relationship set exceeded," typically occurs in the context of SAP's Master Data Management (MDM) or when dealing with Business Partner (BP) relationships. This error indicates that the number of relationships defined for a particular relationship set has exceeded the predefined limit set in the system.
  Cause:
  
  Exceeding Limits: Each relationship set in SAP has a maximum number of relationships that can be defined. When you try to create or modify a relationship that exceeds this limit, the system throws this error.
  Configuration Settings: The limit is often defined in the configuration settings of the SAP system, and it may vary based on the specific implementation or version of SAP you are using.
  Data Model Design: Poorly designed data models or excessive relationships can lead to this error, especially if there are many-to-many relationships that are not managed properly.
  
  Solution:
  
  Review Relationships: Check the existing relationships in the relationship set to see if there are any that can be deleted or consolidated. This may involve analyzing the business requirements to determine if all relationships are necessary.
  Increase the Limit: If it is appropriate for your business case, you can consider increasing the maximum number of relationships allowed in the configuration settings. This typically requires access to the system configuration and may involve working with your SAP Basis or technical team.
  Optimize Data Model: Review and optimize your data model to ensure that relationships are necessary and that they are structured efficiently. This may involve redesigning how entities are related to each other.
  Consult Documentation: Refer to SAP documentation or notes related to your specific version of SAP to understand the default limits and how to adjust them if necessary.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions related to this error message.
  Transaction Codes: Use transaction codes like BP (Business Partner) or SWETYPV (for workflow types) to manage and review relationships.
  Performance Considerations: Be aware that increasing the number of relationships can have performance implications, so it’s essential to balance the need for more relationships with system performance.
  
  If the issue persists after trying the above solutions, it may be beneficial to engage with SAP support or a consultant who specializes in SAP data management for further assistance.