How To Fix RSAU021 - &1 records added to fact table &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RSAU - Update rules

• Message number: 021

• Message text: &1 records added to fact table &2

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 RSAU021 - &1 records added to fact table &2 ?

  The SAP error message RSAU021 indicates that a certain number of records (denoted by &1) have been added to a fact table (denoted by &2) during the data extraction or loading process in SAP BW (Business Warehouse). This message is typically informational rather than an error, but it can indicate that there may be issues with data consistency or integrity if the number of records added is unexpected.
  Cause:
  
  Data Load Process: The message is generated during the data load process when records are being added to a fact table. It can occur during the extraction of data from a source system or during the loading of data into the BW system.
  Data Volume: A high volume of records being added may indicate that the data extraction process is functioning correctly, but it may also raise concerns if the volume is significantly higher than expected.
  Data Quality Issues: If the number of records added is unexpectedly high, it may suggest issues with data quality or duplication in the source system.
  
  Solution:
  
  Review Data Load Process: Check the data load process to ensure that it is functioning as expected. Review the extraction and transformation rules to confirm that they are correctly defined.
  Check for Duplicates: Investigate the source data for potential duplicates or inconsistencies that may lead to an unexpected increase in records.
  Monitor Data Volume: If the increase in records is expected (e.g., due to a new data source or a change in business processes), ensure that the data model can handle the increased volume.
  Data Quality Checks: Implement data quality checks to ensure that the data being loaded into the fact table meets the required standards.
  Consult Documentation: Refer to SAP documentation or notes related to the specific data source or extraction process for any known issues or recommendations.
  
  Related Information:
  
  Transaction Codes: You may want to use transaction codes like RSA1 (Data Warehousing Workbench) to monitor and manage data loads.
  Data Flow Monitoring: Use the Data Flow Monitor in SAP BW to track the status of data loads and identify any issues.
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to the RSAU021 message or the data load process.
  Performance Tuning: If you are experiencing performance issues due to high data volume, consider performance tuning options for your BW system.
  
  If the message is causing operational issues or if you need further assistance, consider reaching out to your SAP support team or consulting with an SAP BW expert.