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');
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
I think you need to correct one minor issue: - Insert blank character between the brackets
where OBJECTCLAS OBJECTID CHANGENR IN ( SELECT OBJECTCLAS OBJECTID CHANGENR FROM CDHDR where UDATE = '$(vDate)' );