Qlik Community

QlikView Connectors

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.
Not applicable

Data Fetching issue through SAP

Hi All,

I am facing issue while fetching one table i.e. KONV from SAP as in that record are too much hence I am getting error custom read failed error I tried to filter data through various condition but still not successfully loaded.

Any help would be appreciated.

Regards

Sumita Chawla

1 Reply
yfe
Contributor III

Re: Data Fetching issue through SAP

Hi Sumita

Table KONV is of type 'Cluster'. In order to improve performance you should try to use 'Subselect', for example:

SQL SUBSELECT KDATU KAWRT KBETR WAERS FROM KONV WHERE KNUMV IN ( SELECT KNUMV FROM VBRK );

SQL SUBSELECT CHANGENR TABNAME TABKEY FNAME CHNGIND VALUE_NEW VALUE_OLD FROM CDPOS WHERE OBJECTCLAS OBJECTID CHANGENR IN ( SELECT OBJECTCLAS OBJECTID CHANGENR FROM CDHDR WHERE CHANGENR BETWEEN '0000100000' AND '0000300000' );

For detailed explanation - please read the SAP connector manual (page 26 in the manual for version 5.8. SR1)

Yaniv

Community Browser