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.
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:
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.