Report Settings
This page contains an overview and description of all available Report settings.
Open the Report Settings
To open the service settings of an existing Report service:
- Open the Services menu
- Select a service of type Report.
- Click [ Edit].
The settings of the Report service open.
Report
The Report tab contains settings related to the source report in SAP.
ABAP Report
The ABAP Report section displays the name and description of the selected ABAP report.
Select Report
To select a different source file, click Select in the upper right corner of the section.
Variant
A variant contains a set of selection parameters that limit the result set of the report to records that match the selection. A selection variant can be created in SAP at the input screen of an ABAP report. The purpose of a variant is to minimize the necessity to enter selections each time you run a report. If available, variants can be selected from the drop-down-list.
Note
Manual selections and variants can be combined. Manual selections overwrite any selections in the variant.
Output Rows
The Output Rows section contains settings to exclude report rows from the service output.
Skip rows from top
Reports can display meta information in the header section of the report, before the actual report body. The setting Skip rows from top allows skipping the meta information.
Enter the number of rows to skip at the beginning of the report.
Skip rows from bottom
Similar to Skip rows from top, the setting Skip rows from bottom allows skipping rows in the footer section of the report.
Enter the number of rows to skip at the end of the report.
Output Columns
The Output Columns section displays the length and names of the detected report columns.
Tip
To manually adjust the length and names of columns, download and edit the service definition of the report service.
Detect Columns
Detecting columns is mandatory for using the service. Click [Detect columns] to execute the report based on the selected variant or selections and detect columns automatically.
Note
If a report has variants, the variant must be selected, before using [Automatically detect columns].
Selection Parameters
The Selection Parameters section corresponds to the report’s input screen in SAP.
Some selection fields only have a technical name and no description. To understand which field corresponds to a field in SAP, compare the results with the report’s input screen in SAP.
Click a selection field and press F1 to display the technical name of a selection field.
Note
If a selection parameter is left empty, the report uses the value defined in the report.
Service Settings
The Service Settings tab contains settings specific to the service type. Report does not have specific settings.
Destination Settings
The Destination Settings tab contains settings specific to the destination assigned to the service.
The destination settings define how and where a service saves its output data. The settings vary depending on the destination.
- HTTP Destination Settings
- Microsoft Azure Storage Destination Settings
- Microsoft Fabric Mirroring Destination Settings
- Microsoft Fabric (OneLake) Destination Settings
- Microsoft Power BI Destination Settings