How To Fix FTR_TRES098 - Sorting is not allowed for this column

SAP Error Message - Details

• Message type: E = Error

• Message class: FTR_TRES -

• Message number: 098

• Message text: Sorting is not allowed for this column

What causes this issue?

Sorting is not allowed for Planned Dividend Currency, Actual Dividend
Currency and Status columns

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?

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 FTR_TRES098 - Sorting is not allowed for this column ?

  The SAP error message FTR_TRES098: Sorting is not allowed for this column typically occurs in the context of SAP Treasury and Risk Management (TRM) when you attempt to sort a column in a report or a transaction that does not support sorting for that specific column. This can happen in various scenarios, such as when dealing with certain financial instruments, reports, or data views.
  Cause:
  
  Column Properties: The column you are trying to sort may be defined in the system as non-sortable. This is often the case for calculated fields, certain key figures, or fields that are not meant to be sorted due to their nature.
  Data Structure: The underlying data structure or the way the data is retrieved may not support sorting for that column. For example, if the data is aggregated or if it comes from a complex join, sorting may not be allowed.
  User Permissions: In some cases, user permissions or roles may restrict certain actions, including sorting on specific columns.
  
  Solution:
  
  Check Column Definition: Review the definition of the column in the report or transaction. If it is a calculated field or a field that is not meant to be sorted, you may need to adjust your approach.
  Modify Report Layout: If you are using a custom report or query, consider modifying the layout or the query to exclude the non-sortable column or to sort by a different column that is allowed.
  Use Alternative Sorting: If sorting is essential, consider exporting the data to Excel or another tool where you can perform the sorting as needed.
  Consult Documentation: Refer to SAP documentation or help resources for specific details about the report or transaction you are using to understand the limitations regarding sorting.
  Contact SAP Support: If you believe this is an error or if you need further assistance, consider reaching out to SAP support for guidance.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide updates or patches.
  User Forums: Engage with SAP community forums or user groups where similar issues may have been discussed.
  Training and Documentation: Review any training materials or documentation related to SAP Treasury and Risk Management to better understand the functionalities and limitations of the reports you are using.
  
  By following these steps, you should be able to address the error and find a suitable workaround or solution.