The following section describes the functions of the Xtract Report component of Xtract IS.
The Xtract IS Report component is a data source for SSIS that enables ABAP report execution and processing of the output in SSIS data flow.

Note: The Report component requires installation of the custom function module Z_XTRACT_IS_REMOTE_REPORT in your SAP system. For detailed information, see Install Report Custom Fuction Module.

Warning! Missing Authorization To use the Report component, access to the designated authority objects (RFC) in SAP must be available. For more information, see the knowledge base article on SAP User Rights: Report.

Tip: To get information on the basics, refer to Getting Started with Xtract IS.

How to use the Xtract Report component #

  1. A valid connection manager connected to a SAP system must be defined, see section Connection Manager.
  2. Drag the appropriate component from the toolbox and drop it to your data flow task.
  3. Double-click the [icon] of the component. The main window of the component opens.

The majority of the functions of the component can be accessed using the main window.

General Workflow for Creating a Report Extraction #

The following steps describe the most simple workflow for creating a report extraction. Further tweaking may be required, see below.

When creating a new report extraction, start by executing the report in SAP. Know the selections or variants when executing the report. Format the report layout/output in a way that it returns a table-like structure. Save the layout as a variant if possible.

  1. In the Xtract Report component, look up the ABAP report or transaction you want to extract, see Look Up a Report or Transaction.
  2. Select a variant or manually enter selections in the Selection Screen, see Variants and Selections.
  3. Detect the report columns automatically. If the columns are detected, column name, width and offset are listed in the columns section, see Define Columns automatically.
  4. If step 3 returns a single field, the report columns can not be detected automatically. Set the report columns manually, see Define Columns manually.

More information on working with the Xtract Report component is provided in the following sections:

Defining a Report Extraction

Variants and Selections

Defining Report Columns

Settings

Parameterization