How to use FTWP - Settings for data extraction


SAP Transaction Code - Details

  • Transaction Code: FTWP

    Description: Settings for data extraction

    Release: S/4HANA and ECC 6

    Menu Path:

    • Accounting > Financial Accounting > General Ledger > Periodic Processing > Data Retention Tool > Configuration > Data extracts
  • Show technical details Hide technical details
    • Program: SAPMTXWC

      Screen: 101

      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: FTWP - Settings for data extraction
    
    Overview:
    The SAP transaction code FTWP is used to set up data extraction for the Financial Accounting (FI) module. It allows users to define the data that should be extracted from the FI module and how it should be formatted. This data can then be used for reporting and analysis purposes. 
    
    Functionality: 
    FTWP enables users to define the data that should be extracted from the FI module, as well as the format in which it should be presented. This includes defining the fields that should be included in the extraction, as well as any filters or sorting criteria that should be applied. The extracted data can then be used for reporting and analysis purposes. 
    
    Step-by-step How to Use: 
    1. Access the FTWP transaction code by entering “FTWP” into the command field in SAP. 
    2. Select “Create” to create a new extraction definition. 
    3. Enter a name for the extraction definition and select “Continue”. 
    4. Select the fields that should be included in the extraction and any filters or sorting criteria that should be applied. 
    5. Select “Save” to save the extraction definition. 
    6. Select “Execute” to run the extraction and generate the output file. 
    
    Other Recommendations: 
    It is recommended that users test their extraction definitions before running them in production, to ensure that they are extracting the desired data in the desired format. Additionally, users should ensure that they have appropriate access rights to run FTWP transactions, as this will affect their ability to create and execute extractions.
    • 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:
  • FTWN - Display view query log...

  • FTWM - Rebuild data extract...

  • FTWQ - Configure data file data segments...

  • FTWQMD - Number range maintenance: TXW_SN_MD...


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant