Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
HSD
Contributor
Contributor

SUBSELECT not working after Migration from SAP ECC -> SAP HANA

Hello All,

We have recently migration our DATA SOURCE from SAP ECC to SAP HANA, after this our SUBSELCT is not running and giving error as per attachment.

Syntax which was working in SAP ECC:

Subselect  A B C Qty

from ItemTable

WHERE A B C IN ( SELECT A B C FROM HeaderTable WHERE
    (EntryDate GE '$(STARTDATE)') OR
    (ChngDate GE '$(STARTDATE)'))

 

Kindly suggest correction required.

Labels (1)
1 Reply
Hakan_Ronningberg

Hi,

There was a bug regarding Subselect in S/4HANA systems. It is fixed in the latest SAP connector release 8.0.1. Check the Release Notes: 
https://community.qlik.com/t5/Release-Notes/Qlik-Connector-for-use-with-SAP-NetWeaver-v8-0-1/ta-p/18...

Regards,
Håkan