Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Skip to end of metadata
Go to start of metadata

In a InfoProvider CDS view, each key figure should be defined with @DefaultAggregation: #SUM, #MIN or #MAX, or @Aggregation.default: #NOP,  #SUM, #MIN or #MAX (the new annotation as of Note 2381161).

Otherwise it is treated as characteristic. When the data type is not supported for a characteristic, the field is ignored and not  included in the InfoProvider metadata before Note 2771186 and 2778887. After this note, the field gets a default NO2 aggregation and becomes a NO2 key figure.

To correct error RSODP 103: Field xxx ignored: Data type xxx not allowed for characteristic

1. check whether the fields should use: @Aggregation.default: #MIN , #MAX or #SUM. And add such annotation according to the business logic

2. If it can't use #MIN, #MAX or #SUM, apply 2771186 and 2778887,  remove the annotation at all. This means  @Aggregation.default:: #NOP by default.

 

Example 1:

Below is an example CDS that define a key figure with case statement:

In this CDS, key figure AAFlightPrice doesn't have default aggregation setting.

When activate the CDS, system gives error: Field AAFLIGHTPRICE ignored: Data type CURR not allowed for characteristic 

In transaction RSRTS_ODP_DIS, display ODP ZGL_SFLIGHTV, field AAFlightPrice is not included: (before Note 2771186)

This means field AAFlightPrice can't be used in the CDS query defined on this InfoProvider.

Please note: With annotation @Analytics.hidden: true, a field can be explicitly set into section 'Not Included'.

If a CDS query is define as below:

When check syntax or activate, errors are displayed as above:
Could not resolve field yyy (ODP zzz) RSRTS_CDS028
Error while processing select entry number xx (at Line xx Column xx)

To solve the error, change the InfoProvider CDS and add @DefaultAggregation for field AAFlightPrice:

 

Example 2:

Here is an example of key figure with default aggregation NO2. Please note it is not recommended to explicit set default aggregation to #NOP, instead please remove the annotation if you don't want to use default aggregation #SUM, #MIN or #MAX. This example is just to explain the meaning of #NOP.

Define a simple CDS quey like this:

Run it in RSRT, key figure FirstClassSeats gets 'NOP' because there are more than one values to be aggregated.

Drill down connid, key figure FirstClassSeats gets a value since there is only one value to be aggregated.

 

 

 

  • No labels