1 Reply Latest reply: Apr 1, 2014 10:55 PM by Yaniv Feldman RSS

    Data Fetching issue through SAP

    Sumita Chawla

      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
          Yaniv Feldman

          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