1 Reply Latest reply: Oct 17, 2014 7:41 AM by Yaniv Feldman RSS

    Subselect query not working in SAP

      Hi All,

       

      I am trying to apply incremental load on a SAP table named CDPOS table using CDHDR & subselect keyword.

      The script is as follows :-

       

      let vDate = date(Today()-1,'YYYYMMDD');

       

      CDPOS:

      SQL SUBSELECT  * from CDPOS

      where OBJECTCLAS OBJECTID CHANGENR IN (SELECT OBJECTCLAS OBJECTID CHANGENR FROM CDHDR where UDATE = '$(vDate)');


      But it fails and the QV log file shows an error - "

      QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to an unexpected exception. Key = JOB_CANCELLED (ID:00 Type:E Number:001 Job aborted, check log for Job /QTQVC/READ_DATA in Job Overview (transaction SM37))

      10/15/2014 12:39:24 PM:       Error: Custom read failed "

       

      Hence i checked the sap log which shows me the error - " Subselect with one table is not possible"

      The query does contain two different tables.

      PFA the snapshot of the same.


      Note:-  All the other SAP extractors are working fine.


      Can anybody please help me ...... there are very less posts on subselect and not helpful to me.


      Thanks in Advance

      Sarang M. Mehta