Integrate Reports

This page shows how to use the Report integration type.
The Report integration 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.

General Workflow

The following graphic shows the general workflow of setting up report services with yunIO:

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.

Look Up a Report

1. Create a new service of integration type Report.
2. In the Search SAP Reports menu, enter the name or TCODE of a report . The use of wildcards ( * ) is only supported for report names.
   
3. Click [Search] to look up the name of a report or click [By TCODE] to look up the TCODE.
4. Select a source file from the list of available search results .

The settings of the Report integration type open.

Define the Report Service

The following options are available to filter data, detect columns, etc:

1. If the report has variants, select a variant in the subsection Advanced Settings.
   
2. Optional: In the subsection Selection Parameters, enter values for selection criteria you want to change or dynamize.
3. 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.
4. Click [Run] to check the results, see Running Services in yunIO.

For more information on Report settings, see Settings.

Sample

Follow the steps below to create a simple service that extracts the SAP ABAP report RLT10010 (Evaluation of Movements per Storage Type).

1. Create a new service of integration type Report.
2. Look up the report RLT10010.
3. Select a variant or enter selection parameters. The given example uses a variant VAR01.
   
4. Run the report in SAP to determine the number of rows to skip. Set Skip rows from top to 8 to skip the header of the report.
   
5. Click [Detect Columns] to automatically detect the columns of the report. The detected columns are displayed in the section Output Columns.
6. Click [Save] to save the service.
7. Click [Run] to check the output of the service, see Running Services in yunIO.
   

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.