How To Fix FTI047 - Key figure &1 is not checked for hiding records with a balance of zero

SAP Error Message - Details

• Message type: E = Error

• Message class: FTI - Treasury Information System

• Message number: 047

• Message text: Key figure &1 is not checked for hiding records with a balance of zero

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message FTI047 - Key figure &1 is not checked for hiding records with a balance of zero ?

  The SAP error message FTI047 indicates that a specific key figure is not configured to hide records that have a balance of zero in the context of Financial Transaction Management (FTI). This can occur in various scenarios, particularly when working with financial reports or data analysis where zero balances may clutter the output.
  Cause:
  The error arises when the system attempts to process a key figure that has not been set up to filter out or hide records with a zero balance. This can happen due to:
  
  Configuration Settings: The key figure in question may not have the appropriate settings in the data model or reporting structure to exclude zero balances.
  Data Model Design: The design of the data model may not include logic to handle zero balances for specific key figures.
  User Settings: User-specific settings or preferences may not be configured to hide zero balances.
  
  Solution:
  To resolve the FTI047 error, you can take the following steps:
  
  
  Check Key Figure Configuration:
  
  Navigate to the configuration settings for the key figure in question.
  Ensure that the option to hide records with a balance of zero is enabled. This may involve adjusting settings in the data model or report configuration.
  
  
  
  Modify Data Model:
  
  If you have access to the data model, consider adding logic to filter out zero balances for the specific key figure.
  This may involve creating a new calculated key figure that only includes non-zero balances.
  
  
  
  Review User Preferences:
  
  Check if there are user-specific settings that need to be adjusted to hide zero balances.
  This can often be found in the user profile or report settings.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for specific instructions on configuring key figures and handling zero balances.
  
  
  
  Testing:
  
  After making changes, test the report or transaction again to ensure that the error is resolved and that zero balances are being hidden as expected.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or patches related to this error.
  Transaction Codes: Familiarize yourself with transaction codes related to Financial Transaction Management, such as FTI1, FTI2, etc., for further configuration options.
  User Forums: Engage with SAP community forums or user groups for shared experiences and solutions from other users who may have encountered the same issue.
  
  By following these steps, you should be able to address the FTI047 error and configure your key figures to handle zero balances appropriately.