How To Fix SRF_AUTHORING241 - Sort order for query &1 does not contain all relevant key fields

SAP Error Message - Details

• Message type: E = Error

• Message class: SRF_AUTHORING - Message class for SRF Authoring

• Message number: 241

• Message text: Sort order for query &1 does not contain all relevant key fields

What causes this issue?

You defined a sort order which does not include all key fields that may
have different values in the result set. Key fields that are uniquely
defined by means of a filter condition need not be part of the sort
order and are already considered by this check.
Sort order should be defined either for the primary key or for one of
the secondary keys (which are created by means of unique table indexes).
Missing fields from primary key or secondary keys (list may be
truncated):
&V3&&V4&

System Response

The system adds the missing fields from the primary key with ascending
sort order to the end such that all rows are returned in a defined
order.

How to fix this error?

Enhance the sort order.
This message might also appear because the underlying query source &V2&
does not describe key fields properly. In this case you should update
that query source if possible.

Procedure for System Administrators

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.