Data Fetching issue through SAP

Mon, 26 Jan 2026 21:26:37 GMT

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

Re: Data Fetching issue through SAP

Anonymous — Wed, 02 Apr 2014 02:55:08 GMT

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

topic Re: Data Fetching issue through SAP in QlikView

Data Fetching issue through SAP

Re: Data Fetching issue through SAP