How To Fix SADL_GW_DT_SB_UI018 - Property '&1' of entity type '&2' uses aggregation function

SADL_GW_DT_SB_UI018 - Overview

• Message type: E = Error

• Message class: SADL_GW_DT_SB_UI - Gateway Service Builder UI Integration for SADL

• Message number: 018

• Message text: Property '&1' of entity type '&2' uses aggregation function

What causes this issue?

Property "&V1&" uses aggregation function but the entity type "&V2&" has
no aggregation semantic.

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?

Add semantic "aggregation" to the entity type "&V2&".

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

SADL_GW_DT_SB_UI018 - Details

• The SAP error message SADL_GW_DT_SB_UI018 indicates that there is an issue with a property in an entity type that is using an aggregation function. This typically occurs in the context of SAP Gateway and OData services, where the system is trying to process a request that involves an aggregation function on a property that is not supported in the current context.
  
  Cause:
  The error is usually caused by one of the following reasons:
  
  Aggregation Function Misuse: The property specified in the error message is being used in a way that requires aggregation (like SUM, AVG, COUNT, etc.), but the context does not support it.
  Model Definition Issues: The entity type or the property may not be correctly defined in the data model, leading to confusion in how the data should be aggregated.
  Incompatible Query: The OData query being executed may be trying to retrieve data in a way that is incompatible with the underlying data