SAP CONNECTOR

80% of people found this useful
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.

 

Recent Comments

By: Julio Navarro Posted on Fri, Mar 5 2010 3:20 PM

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.

By: Julio Navarro Posted on Fri, Mar 5 2010 3:22 PM

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.

Share
Feedback Form