Data Fetching issue through SAP

[#1]

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

[Anonymous]

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