How to use FTWN - Display view query log

SAP Transaction Code - Details

• Transaction Code: FTWN

  Description: Display view query log

  Release: S/4HANA and ECC 6

  Menu Path:

  • Accounting > Financial Accounting > General Ledger > Periodic Processing > Data Retention Tool > Extras > Display view log

• • Program: RTXWVWL2

    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: FTWN - Display view query log

  
  Overview:
  The SAP transaction code FTWN is used to display the view query log in the SAP system. This log contains information about the queries that have been executed in the system, including the query name, date and time of execution, and the user who executed it. 
  
  Functionality: 
  The FTWN transaction code allows users to view the query log in order to monitor and analyze query performance. This can be useful for troubleshooting and optimizing queries, as well as for auditing purposes. The log can also be used to identify any potential security risks or unauthorized access to data. 
  
  Step-by-step How to Use: 
  1. Enter the transaction code FTWN into the command field of the SAP system. 
  2. The query log will be displayed in a table format. 
  3. Use the filters at the top of the table to narrow down your search results. 
  4. Select a query from the list to view more detailed information about it, such as its execution time and user who executed it. 
  5. To export the query log, select “Export” from the menu bar at the top of the screen. 
  
  Other Recommendations: 
  It is recommended that users regularly review their query logs in order to ensure that queries are running efficiently and securely. Additionally, users should be aware of any potential security risks associated with unauthorized access to data, and take steps to mitigate these risks if necessary.