How To Fix FTI_LDB_MESSAGE160 - Query contains the field RATING or SOL_INS

FTI_LDB_MESSAGE160 - Overview

• Message type: E = Error

• Message class: FTI_LDB_MESSAGE - Messages for TR OLTP Reporting Using Logical Databases

• Message number: 160

• Message text: Query contains the field RATING or SOL_INS

What causes this issue?

When you defined the query, you used the fields RATING or SOL_INS. These
business partner attributes are obsolete as of NW 710. Check whether you
can already change to the new valuation. If this is the case, use the
GRADE field instead of the RATING field.

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.

FTI_LDB_MESSAGE160 - Details

• The SAP error message FTI_LDB_MESSAGE160 typically indicates that there is an issue with a query that includes the fields RATING or SOL_INS. This error is often encountered in the context of SAP's Financial Transaction Management (FTI) or similar modules where these fields are relevant.
  
  Cause:
  
  Field Restrictions: The fields RATING and SOL_INS may have specific restrictions or conditions under which they can be used in queries. If these fields are not allowed in the context of the query you are trying to execute, the system will throw this error.
  Data Model Issues: The underlying data model may not support the inclusion of these fields in the specific query you are attempting to run.
  
  Configuration Issues: There may be configuration settings in the SAP system that restrict the use of these fields in certain queries or reports.
  
  
  Solution:
  
  Review Query Structure: Check the structure of your query to ensure that it is correctly set up and that