Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

SAP CONNECTOR

Luminary
Luminary

SAP CONNECTOR

For SAP customers Qlikview provides the SAP Connector. This is a valuable component giving access to data structures not reacheble when using direct access to the database.

One of these structures are Cluster Tables. see details here Pool and Cluster Table Definition . You can read data from these tables, but you need filters based on the cluster index. You also can't use this table in a join statement.

The connector allows only reading of data.

You can't call RFC functions.

To read the SAP tables you need to use SQL statements based on SAP OPEN SQL. see details here Reading with OPEN SQL.

Performance Notes

The performance of an ABAP program is largely determined by the efficiency of its database accesses. It is therefore worth analyzing your SQL statements closely. To help you to do this, you should use the Performance Trace andRuntime Analysis tools (Test menu in the ABAP Workbench). In particular, the SQL Trace in the Performance Traceshows you which parts of Open SQL statements are processed where, and how long they take. Check detais here.

Tags (1)
Labels (1)
Comments
Not applicable
We are currently using SAP Connector against SAP BW. It works fine for DSO objects and Queries. Nevertheless, the performance accessing BW InfoCubes is quite poor. Have anyone experienced good performance accesing InfoCubes? Regards, Julio.
Not applicable
Another thing I missed in the SAP Connector is the ability to load BW Master Data InfoObjects. We usually access these master data through queries, but it will be nice to load the master data directly... Any idea? Regards, Julio.
Not applicable
All masterdata is stored in transparant tables. When you look up the InfoObject in the Administrator workbench, you can find the name of the table. It usualle starts with /BI0/... for business content tables and /BIC/... for custom tables. The next letter can be M, Q, H, J, T for master data view, Time dependant data, Hierarchy data (like cost centres, product hierachies and customer hierachy), Time-dependant hierachy tables, Text tables. Attributes can be stored in seperate tables, when available. The InfoObject in RSA1 gives you all the names of the tables.
Not applicable
Why would you want to load the aggregated and compressen InfoCubes, when you can load the full detail from flat tables in the DSO objects? these tables can give you delta's for incremental load if you want too, where the InfoCubes only give you rolled-up data which is not very helpfull if you want to do a further drill-down in Qlikview? but nevertheless the transparart tables from the InfoCubes are available: simply run a LISTSCHEMA transaction and you get all the table details, including SID-tables, DIM-tables and the master data joined to the cubes. Mind the F- and E-tables, which both hold the fact-rows in rolled-up and not-rolled-up status.
suniljain
Honored Contributor
Dear Julia, if you required any help regarding SAP . pls reply me. I already implement project on SAP BW.
Not applicable
Very Useful article, thank you for posting it and also for your updates
Version history
Revision #:
1 of 1
Last update:
‎02-04-2010 08:01 PM
Updated by: