How To Fix VCH_L2A_CHECKS105 - Built-in functions SUM_PART and COUNT_PARTS are not supported

SAP Error Message - Details

• Message type: E = Error

• Message class: VCH_L2A_CHECKS - VCH Transition AVC Check Messages

• Message number: 105

• Message text: Built-in functions SUM_PART and COUNT_PARTS are not supported

What causes this issue?

Built-in functions $SUM_PARTS and $COUNT_PARTS are not supported in
Advanced Variant Configuration.

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

System Response

How to fix this error?

Use the BAdI VCH_HL_POST_VALIDATE_ASSIGN for aggregation across several
configurable products in the model.

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 VCH_L2A_CHECKS105 - Built-in functions SUM_PART and COUNT_PARTS are not supported ?

  The SAP error message VCH_L2A_CHECKS105 indicates that the built-in functions SUM_PART and COUNT_PARTS are not supported in the context where they are being used. This error typically arises in the context of SAP Analytics Cloud (SAC) or SAP BW (Business Warehouse) when trying to perform calculations or aggregations that are not allowed or not supported by the underlying data model or query.
  Cause:
  
  Unsupported Functions: The functions SUM_PART and COUNT_PARTS may not be supported in the specific version of SAP you are using or in the context of the data model.
  Data Model Limitations: The data model may not support certain aggregations or calculations due to its structure or configuration.
  Incorrect Context: The functions might be used in a context where they are not applicable, such as in a calculated measure or in a query that does not allow these functions.
  
  Solution:
  
  Check Documentation: Review the official SAP documentation for the specific version you are using to confirm whether these functions are supported and in what contexts.
  Use Alternative Functions: If SUM_PART and COUNT_PARTS are not supported, consider using alternative aggregation functions that are supported in your environment, such as SUM or COUNT.
  Modify Data Model: If possible, adjust the data model to allow for the required calculations. This may involve changing the structure of the data or the way measures are defined.
  Consult SAP Support: If you are unable to resolve the issue, consider reaching out to SAP support for assistance. They may provide insights specific to your version and configuration.
  
  Related Information:
  
  SAP Notes and Knowledge Base Articles: Check for any relevant SAP Notes or KBA (Knowledge Base Articles) that address this specific error message or the functions in question.
  Community Forums: Engage with the SAP Community or forums where other users may have encountered similar issues and can share their solutions.
  Version Compatibility: Ensure that your SAP system is up to date, as newer versions may have added support for additional functions or improved existing functionalities.
  
  By following these steps, you should be able to identify the cause of the error and implement a suitable solution.