Report Services

This page shows how to use the Report service type.
The Report service type can be used to extracts data from ABAP reports and SAP transactions.

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.

Tip

Use transaction code SAP1 to get a list of all reports for all modules.

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.

Workflow

Workflow for setting up a new Report service:

In SAP, format the layout / output of the report to return a table-like structure.
Optional: Save the layout as a variant.
In Xtract Universal.iQ, create a new Report service.
Look up the Report.
Load a Variant or enter selections manually.
Detect the report columns automatically.

Prerequisites

The custom function module Z_XTRACT_IS_REMOTE_REPORT is installed in your SAP system, see Function Module for Reports.
The report must return a table-like structure in SAP.
Grant access to reports, see Knowledge Base Article: Authorize Access to Specific Reports.
A connection to the SAP source system is set up in Xtract Universal.iQ, see Create an SAP Connection.
The SAP user in the SAP connection has sufficient user rights, see SAP Authority Objects.

Warning

Missing Authorization.
To use the Report service type, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects: Report accordingly.

Create a Report Service

To create a new Report web service in Xtract Universal.iQ:

Open the Services menu.
Click [Add Service].
Enter a unique name and a description.
Optional: Activate the checkbox Enable MCP Access and add an MCP description to expose the service via the Xtract Universal.iQ MCP Server.
Select an existing SAP connection from the Connection dropdown. If no connection is available, create a connection, see Connect to SAP.
Select Report from the Type dropdown.
Select a target environment from the Destination dropdown. By default, Xtract Universal.iQ services return SAP data in HTTP response of the service (HTTP destination).
Click [Save].

The service is now listed in the Services menu.

Next, select the SAP object you want to extract.

Look Up a Report

To select an ABAP Report from your SAP source system:

Create a new service of service type Report or edit an existing service.
In the Review section of the service, click [Select Report]. The "Search SAP Reports" menu opens.
In the Search SAP Reports menu, enter the name or TCODE of a report. Use wildcards ( * ) if needed.
Click [Search] to look up the name of a report or click [By TCODE] to look up the TCODE and display the search results.
Select a Report from the list of search results. The "Search SAP Report" menu closes.

Xtract Universal.iQ loads and displays the metadata of the Report in the service.

Next, configure the remaining service settings.

Configure the Report Service

After creating the service, configure the service using the following workflow:

If the report has variants, select a variant in the Advanced Settings.
Optional: In the subsection Selection Parameters, enter values for selection criteria you want to change or dynamize.
Click [Detect Columns] to execute the report based on the selected variant or selections and detect columns automatically. The detected columns are displayed in the subsection Output columns. This step is mandatory for using the service.
Run the Service in Xtract Universal.iQ to check the results.

For more information, see Report Settings.

Run and Automate the Service

Last update: July 8, 2026