How to use DELETE_FACTS - Delete from the fact table


SAP Transaction Code - Details

  • Transaction Code: DELETE_FACTS

    Description: Delete from the fact table

    Release: S/4HANA and ECC 6

  • Show technical details Hide technical details
    • Program: RSDRD_DELETE_FACTS

      Screen: 1000

      Authorization Object:

    • Development Package: RSDRD

      Package Description:

      Parent Package:

    • Module/Component:

      Description:


Smart SAP Assistant

  • SAP Tcode: DELETE_FACTS - Delete from the fact table
    
    Overview:
    DELETE_FACTS is a SAP transaction code used to delete records from the fact table in a data warehouse. It is used to remove outdated or incorrect data from the fact table, which is the main table in a data warehouse that stores the most important information. 
    
    Functionality:
    DELETE_FACTS allows users to delete records from the fact table in a data warehouse. It can be used to remove outdated or incorrect data from the fact table, which is the main table in a data warehouse that stores the most important information. The transaction code also allows users to delete records from other related tables, such as dimension tables, if necessary. 
    
    Step-by-step How to Use:
    1. Log into your SAP system and navigate to the DELETE_FACTS transaction code. 
    2. Select the fact table you want to delete records from. 
    3. Select the records you want to delete and confirm your selection. 
    4. Confirm that you want to delete the selected records and click “OK”. 
    5. The selected records will be deleted from the fact table and any related tables. 
    
    Other Recommendations:
    It is important to use caution when using DELETE_FACTS as it can permanently delete data from your system. Before deleting any records, it is recommended that you back up your data in case you need to restore it later. Additionally, it is recommended that you consult with an experienced SAP user before using this transaction code as it can have serious consequences if used incorrectly.
    • Do you have any question about this t-code?


      Upgrade now to chat with this t-code.

Related SAP Transaction Codes

Click the links below to see the following related SAP tcodes:

Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker