Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-03-31 10:39 AM

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,338 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2014-04-01 10:55 PM
Author

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

453 Views