How to use FTWH - Data view queries

SAP Transaction Code - Details

• Transaction Code: FTWH

  Description: Data view queries

  Release: S/4HANA and ECC 6

  Menu Path:

  • Accounting > Financial Accounting > General Ledger > Periodic Processing > Data Retention Tool > Information system > Data extract views

• • Program: RTXWQU03

    Screen: 1000

    Authorization Object:

  • Development Package: FTW1

    Package Description: Data Retention Tool

    Parent Package: APPL

  • Module/Component: CA-GTF-DRT

    Description: DART (Data Retention Tool)

Smart SAP Assistant

• SAP Tcode: FTWH - Data view queries

  
  Overview: 
  FTWH is an SAP transaction code used to create and manage data view queries. It is part of the SAP Business Warehouse (BW) system, which is a data warehousing solution used to store and analyze large amounts of data. 
  
  Functionality: 
  FTWH allows users to create and manage data view queries in the BW system. This includes creating new queries, editing existing ones, and deleting queries that are no longer needed. The queries can be used to extract data from the BW system and analyze it in various ways. 
  
  Step-by-step How to Use: 
  1. Log into the SAP system and enter transaction code FTWH. 
  2. Select the “Create” option to create a new query. 
  3. Enter the query name and description, then select the data source from which you want to extract data. 
  4. Select the fields you want to include in the query, then click “Save” to save your query. 
  5. To edit an existing query, select the “Edit” option and make any necessary changes. 
  6. To delete a query, select the “Delete” option and confirm your selection. 
  
  Other Recommendations: 
  It is recommended that users familiarize themselves with the BW system before using FTWH to create or manage queries. Additionally, users should ensure that they have the necessary permissions to access and modify queries in the BW system before attempting to do so with FTWH.