Report

This page shows how to use the Report extraction type.
The Report extraction type can be used to extract data from most standard and custom ABAP reports and SAP transactions. A report extraction is possible if the report returns a table-like structure in SAP.

About Reports

ABAP report programs extract and present huge amounts of data for SAP business applications. SAP offers predefined standard reports that cover the basic needs of customers. They can be executed via transaction codes.

Custom Reports

The extraction of custom reports (Z reports) is possible if the report returns a table-like structure in SAP. Issues specific to Z reports are not included in the scope of support provided by Theobald Software.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.
• The custom function module Z_XTRACT_IS_REMOTE_REPORT is installed in your SAP system, see Function Module for Reports. As of Z_XTRACT_IS_REMOTE_REPORT version 1.2 access to reports must be explicitly granted, see Knowledge BAse Article: Authorize Access to Specific Reports.
• The report must return a table-like structure in SAP.

General Workflow

The following graphic shows the general workflow of using the Report extraction type:

Create a Report Extraction

1. In the main window of the Designer, click [New] to create a new extraction. The window "Create Extraction" opens.
   
2. Select an SAP Connection from the drop-down menu in Source and enter a unique name for your extraction.
3. Select the extraction type Report and click [OK]. The main window of the extraction type opens automatically.

The majority of the functions of the extraction type can be accessed in the main window.

Look up a Report or Transaction

1. In the main window of the extraction type, click [ ]. The window “Report Lookup” opens.
   

2. In the field Report Name, enter the name of a report to extract . Use wildcards (), if needed. Alternatively, select TCODE* to look up SAP Transaction codes.
   
   

   Tip

   In some cases reports cannot be determined based on the TCODE. You can check the report name of a TCODE using the SAP GUI menu System > Status....

3. Click [ ] . Search results are displayed.

4. Select a report and click [OK] to confirm.

The application now returns to the main window of the extraction type.

Define the Report Extraction Type

The Report extraction type offers the following options for report extractions:

1. If the report has variants, select a variant from the drop-down-list Variant. For more information, see Choose a Variant.
   
2. Optional: In the section Selection Screen, edit a selection criterion you want to change or dynamize . For more information, see Edit Selections.
   
3. Click [Load live preview] to display a live preview of the first 100 records.
4. Optional: If your report has varying column widths, activate Dynamic column widths and offsets. The column widths and offsets are then adjusted dynamically at report runtime.
5. Click [Automatically detect columns] to execute the report based on the selected variant or selections and detect columns automatically.
   
6. Check if the automatically detected columns are accurate.
   When automatic column detection is not possible, the column names, widths and offsets must be set manually, see Define Columns manually.
7. Optional: Define row settings to remove or parse certain rows, see Define Rows.
8. Check the Extraction Settings and the General Settings before running the extraction.
9. Click [OK] to save the extraction type.

You can now run the extraction, see Execute and Automate Extractions.

Example Extraction

The depicted example shows how to set up a simple report extraction:

1. Look up report RLT10010 (Evaluation of Movements per Storage Type).
2. Select variant VAR01.
3. Load a live preview.
4. Automatically detect columns.
5. Remove the header (skip the first 8 rows).

Related Links

• SAP Wiki: Types of ABAP Reports
• Knowledge Base Article: Authorize Access to Specific Reports