Extraction Settings
This page contains an overview of the extraction settings in the Report extraction type.
To open the extraction settings, click Extraction Settings in the main window of the extraction type.
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 extraction type. 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 Report extraction type 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 extraction type scans the report output for this pattern and uses the complete line this pattern occurs in as the report header.
This setting is usually not required if the report's columns can be detected automatically and Dynamic column widths and offsets is active in the main window of the extraction type.
Row skip pattern
Enter a search pattern. All report rows that contain the pattern are removed from the result set. Rows are removed after the report data was extracted from SAP. Regular expressions is supported. Multiple row skip patterns can be entered separated by the pipe symbol '|'.
Example: 2020|2021|-|Sum removes all rows containing the pattern '2020', '2021', '-' and 'Sum'.
The skip row setting can be used for skipping header rows that are repeated in the output body of reports. For more information, see Knowledge Base Article: Skip Rows in Reports.
Note
This setting is usually not required if the report columns can be detected automatically and Dynamic column widths and offsets is checked in the Report window.
Function Module
The Report component requires installation of the custom function module Z_XTRACT_IS_REMOTE_REPORT in your SAP system, see Install Report Custom Function 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.
Related Links
- Regular Expressions in the Microsoft Online Help
- Knowledge Base Article: Skip Rows in Reports
- Install Report Custom Function Module