Xtract QV - Access to SAP R/3 and SAP ERP from QlikView
| Related Subjects |
Xtract QV Table
Using Xtract QV's table component you can extract data from SAP tables and view. It is also possible to process WHERE statements to restrict the data to the user's needs. Of course, dynamic SQL statements involving variables are also supported.
- Data extraction can be processed in packets to handle large amounts of data
- Asynchronous processing of data packets
- Variables for dynamic WHERE statements
- Type safety and meta data support by 100% from SAP’s data dictionary
- No significant effect on the production system
The screenshort below shows the table dialog in the foreground. In the background you see the designer workbench with other extractions, which are created in the repository.
SAP Queries
SAP queries are so popular as data suppliers because tables can be joined on the SAP end without any developer authorization. With Xtract QV Query, you can make your SAP queries directly available in QlikView. With a graphical user interface and full metadata support, the result is available for further processing within seconds.
As with every SAP query, variants can also be applied here. Alternatively or in addition, it is also possible to fill the selection screen with your own selection values. The variant and all selection parameters can be dynamically entered via variables.
The screenshot shows the query dialog in SAP and the Xtract QV Designer’s Query Form.
BAPIs and Function Modules
With the Xtract QV BAPI component you can access data from BAPIs and RFC function modules and directly use the output in QlikView.
Scalar import and export parameters are read or stored from variables. You can link one or many outbound tables with a pipeline to access them.
The Screenshot shows the function module SD_RFC_CUSTOMER_GET that returns a list of customers by a specified search pattern. The search pattern is not set directly but dynamically via a variable in the QlikView script.
ABAP Reports
The Xtract QV Report component allows you to use existing ABAP reports or ABAP programs as data sources within the QlikView script.
This technique is often used in the area of FI/CO reporting. In a lot of cases, a comprehensive pool of such reports has accumulated over the years and simply cannot be replaced or reengineered
With the Xtract QV Report component you can protect your investments because existing logic doesn’t have to be reengineered—it can simply be reused.
The screenshot below shows the component in the layout preview. The input values (select options) are filled with values (variables if necessary). With the help of a graphical tool, the report output is split up into columns that then generate the query output for further processing.
- Use of variants is possible (even dynamic per variable)
- Even complex reports based on an ALV grid can be generated
- Extremely long running reports are supported by asynchronous techniques (no RFC
timeout)
