An extraction has two types of settings: the Extraction Settings include settings that affect only the respective extraction type, while General Settings are the same for all extraction types.

To access the extraction settings, click [Extraction Settings] in the main window of the Xtract Report component. The window “Extraction Settings” opens. Table Extractor

Batch Processing #

Use Background Mode
If you choose this option, the ABAP report is executed as a batch job in SAP. A spool is generated in SAP (transaction SP01) which is later fetched by the report component. Use this option for long running reports in SAP that would run into an RFC timeout when called in dialog mode. Some reports that throw an error message when running in dialog mode can be extracted when run in background mode.

Background Job Timeout
Enter a time period (in seconds). The Xtract Report component polls the status of the batch job in SAP for the specified time period. If the SAP batch job is not finished by the specified time period, the extraction aborts.

Background Job Name
The name of the background job under which the report is run in SAP.

Spool Destination
Enter the name of the spool destination (printer).

Automatic Detection #

Header pattern
Enter a search pattern (e.g., Created on) to detect the table header. The report component scans the report’s output for this pattern and uses the complete line this pattern occurs in as report header.

This setting is usually not required if the report’s columns can be detected automatically and Dynamic column widths and offsets is checked in the Report window.

Row skip pattern
The row skip pattern acts like a “reverse” WHERE clause: All report rows that contain the pattern are removed from the result set. Rows are being removed after the report data was extracted from SAP.
Entry of regular expressions is supported. Multiple row skip patterns can be entered separated by the pipe symbol ‘|’ e.g., 2020|2021|-|Sum. This would remove all rows containing the pattern ‘2020’, ‘2021’, ‘-‘ and ‘Sum’.
This setting can be used for skipping header rows that are repeated in the output body of reports.

This setting is usually not required if the report’s columns can be detected automatically and Dynamic column widths and offsets is checked in the Report window.

Function Module #

Custom Function
The Report component requires installation of the custom function module Z_XTRACT_IS_REMOTE_REPORT in your SAP system, see Install Report Custom Fuction Module. If you manually created the function module in your SAP system and gave it a different name, enter that name in this field. The default is Z_XTRACT_IS_REMOTE_REPORT.